Posted by steve on 09/30/30 11:16

Hi,
I have the following simple situtation:

I created my database (just tables) in Server1, then made a copy to Server2.
There, i changed all the datatypes and created relationships
between the tables.
Now, I want to transfer, not update, completely replace, all the previous
versions of tables from Server1 with the new DB.

I want to ask before i do something stupid.

- Will DTS delete and replace all previous-version tables and add the new
relationships automatically?
- How about all these system tables that are generated automatically
(sysfiles, sysdepends, etc.) ? Do I have to replace them too?

Thanx in advance,
I know its simple but i am very afraid to screw up my DB during the copy.

-steve

• Next in forum: BULK INSERT Question
• Prev in forum: How to assign quota on a specific datafile?
• Thread view: Newbie: Transfering databases from different servers

[Reply to this message]