DTS - Data Transformation Services
-
Hy I have 2 databases and one table for each of database. The tables have the same structure. One of them is populate and I want to copy the contain of this to the second table. I want to ask if this is possible with DTS. thx
Yes, And You can check the (DTS Export/Import Wizard) section of this article[^].
Hesham A. Amin My blog
-
Yes, And You can check the (DTS Export/Import Wizard) section of this article[^].
Hesham A. Amin My blog
-
Hy I have 2 databases and one table for each of database. The tables have the same structure. One of them is populate and I want to copy the contain of this to the second table. I want to ask if this is possible with DTS. thx
You can do this with DTS - however I would advise just writing a stored procedure or an adhoc script to do a select from one table to insert into the other. The reason I mention this is that DTS packages with all their VBScripting etc can hide a lot of their functionality. From a maintenance point of view this can sometimes make it very difficult to see what is going on. One more issue is this - SQL Server 2000 DTS packages don't like temporary tables in their data pumps(I don't know about 2005), you can use them but you have to be wily in how you use them.
You always pass failure on the way to success.