Hi,
I have 2 similar sql server databases DB1 and DB2 with around 450 tables and much data. My problem is I need to copy specific records from all tables in DB1 to corresponding tables in DB2. What I have done right now is, running seperate INSERT scripts for each table like
INSERT INTO DB2..table1 SELECT * from DB1..table1 where code='XX'
I would like to know whether this is the right approach or any other better way or tool available to do so. Also since the no of records are very high, I insert it in blocks say 30,000 records each, so that log file limit will not create problem.
Thanks in advance. Please help
I would use integration Service for a job like this. I nice easy way to start this is to rightclick the database -> tasks ->export data and follow the wizard.
The outcome from this will be an integration service packagde that following can be edited in SQL Server Business Intelligence Development Studio as a normal Integration service object.
Take a look into the toturials in there. They helped me a lot.
see also this http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=631236&SiteID=1
|||
other alternatives could be
define views and bcp the data out from DB1 and in to DB2
copy the database files (they should not be accessible) and attach them as DB2
Integration Services and use the Database Copy Task
Regards
Norbert
|||you can use snapshot replication with row filter
No comments:
Post a Comment