Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Ways to move only table data in database? Expand / Collapse
Author
Message
Posted Tuesday, December 18, 2012 4:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 10:05 AM
Points: 69, Visits: 306
Hi

i have two databases in different instances i need to transfer data between two tables are by querry can any one specify the ways for the above process

Thanks in advance

With best regards
pradeep
Post #1397686
Posted Tuesday, December 18, 2012 4:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:20 AM
Points: 5,231, Visits: 5,106
By query, then use linked servers



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1397688
Posted Tuesday, December 18, 2012 7:56 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 2:36 PM
Points: 416, Visits: 2,542
mpradeep23 (12/18/2012)
Hi

i have two databases in different instances i need to transfer data between two tables are by querry can any one specify the ways for the above process

Thanks in advance

With best regards
pradeep


You can do this by using the script wizard. Basically right click database/task/generate script....this will open the script wizard, then script out the table you want and apply in the other database.

SueTons.


Regards,
SQLisAwe5oMe.
Post #1397815
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse