passing data between two SQL Server databases

25 pts.
Tags:
SQL 2005
SSIS
Stored Procedures
T-SQL
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 200 related tables.  Also we are not allowed to use the linked server,  which means I can not access data from other SQL server using 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 2005, Stored Procedures
ASKED: November 16, 2009  6:29 PM
UPDATED: January 12, 2010  4:52 AM

Answer Wiki

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

Use Linked Server to achieve this.

Discuss This Question:  

 
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

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