Issue with passing data between two SQL Server databases

Tags:
Data
Linked Server
SQL
SSIS
Stored Procedures
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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).

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • LL123
    Hi Mr Denny, Thank you so much.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following