I have tables ( 3 tables) in "A" database and I want to move these tables to database "B". Both the databases are in same server. And also I want to schedule the task as these 3 tables are daily updated and I want updated tables in "B" database.
I have tried with export/import functionality and created DTS package but I am able to just copy table structures only.
Also, I am using sqlserver2000
Last edited by sejal; 09-05-09 at 04:10.
Reason: Immediate help required