Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KenA
Starting Member
28 Posts |
 Posted - 2004-05-28 : 03:56:20
|
| Hi. Suppose I have an SqlServer DB and some tables in it. Table A and Table B and some Relationship between A and B. Suppose I have those tables filled with some data in.Well, in case I use DTS to transfer my local DB to the remote DB. Once the DB was transfered:1. Will the Relationships between A and B be preserved?2. Will the table´s data be transfered?»»» Ken.Awamura |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2004-05-28 : 10:16:33
|
| The easiest way to make sure that the table data and the relationships are maintained is to use the copy sql objects task in DTS. You could also script out your tables and run a 2 step job, where step 1 would build them for you on the destination server and step 2 would be an insert to populate the data. I'm a fan of using jobs instead of DTS, but that's really just personal opinion.Mike"oh, that monkey is going to pay" |
 |
|
|
KenA
Starting Member
28 Posts |
Posted - 2004-05-29 : 08:25:59
|
| Ok. Thanks for clarifying it :-)»»» Ken.Awamura |
|
|
|
|
|
|
DTS doubt