Issue with passing data between two SQL Server databases
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server, which means I can not access data on other server from Stored Procedure (Am I right ?). The bottom line I can think so far, create a fake DB under the same server and work on "20%" data then use SSIS transfer the whole fake DB to other server. Please let me know what you think. Thank you so much!
Software/Hardware used:
SQL 2000, SQL 2005, SSIS, Stored Procedure
Software/Hardware used:
SQL 2000, SQL 2005, SSIS, Stored Procedure
ASKED:
November 12, 2009 9:07 PM
UPDATED:
June 13, 2013 4:25 PM
Answer Wiki:
I've had to do stuff like this in the past.
In my case it was a loan processing system, so the master number to work off of was the Account Id. So I created a table, and loaded up 10% of the Account Ids into the table. Then used the records in the table to decide which records to transfer from Production to Development.
Any tables which didn't relate to the Account Id value I transferred over completely (I'm talking the lookup tables here).
To see all answers submitted to the Answer Wiki: View Answer History.
Hi Mr Denny, Thank you so much.