|
|
Posted by Steve on 05/16/07 17:09
Hi;
I thought I would rephrase a question I asked in another post to more
quickly get to the heart of the matter. My apologies for anyone who
is offended by what appears to be a repetition.
My company has two identical web sites. One copy is for our customer,
and one copy is for us to test our code changes on.
We developed a hard to isolate bug in the copy of the web stie for our
customers.
We believe the bug might be data related.
We would like to replace our test database with our production
database to try to reproduce the problem without interrupting our
service to our customers.
The test database and production database have all the same tables and
structures,but the names of the databases are slightly different.
We have tried dropping tables from our test database and importing
tables from our customer database in Management Studio. We got the
data but the identity fields were turned off as identities. We can
manually turn them back on in Management Studio, but we have several
hundred tables.
In the end we just want to the data from our customer db to be in our
test db with the test db name being the same, and have our identity
fields preserved.
What is the easiest way to do this?
Thanks in advance for anyinformation
Steve
Navigation:
[Reply to this message]
|