Regarding data transfer ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » Regarding data transfer ?

Regarding data transfer ?

Rate Topic

Display Mode

Topic Options

Author

Message

mpradeep23

Posted Tuesday, February 19, 2013 3:15 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:38 AM
Points: 45, Visits: 168

Hi

i have a requriement
i have 3 sql servers instances
in 1st i have data in 3 to 4 tables

i need to transfer data from ser01 to ser02 and then ser03

for any updates in ser01 on those tables should update in ser02 and ser03

can any suggest the better way to do this

thanks

with best regrads
pradeep

Post #1421504

anthony.green

Posted Tuesday, February 19, 2013 3:30 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

1 time transfer or continuous transfer?

1 time, use import export data wizard, SSIS, BCP etc

continuous I would look at replication

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 #1421513

mpradeep23

Posted Tuesday, February 19, 2013 4:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:38 AM
Points: 45, Visits: 168

continous data transfer should move data every 3 min to 1/2 hour

Post #1421533

anthony.green

Posted Tuesday, February 19, 2013 4:12 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

then look at replication, logshipping, creating your own ssis packages, merge commands etc etc etc

Post #1421535

mpradeep23

Posted Tuesday, February 19, 2013 4:20 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:38 AM
Points: 45, Visits: 168

in SSIS Package can i get data from muitiple table in single data flow task

and can we pass connection string and tables name

thanks

Post #1421538

anthony.green

Posted Tuesday, February 19, 2013 4:21 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

connection string yes, table name no

you can have as many source and destinations in 1 DFT as you wish

Post #1421540

mpradeep23

Posted Tuesday, February 19, 2013 4:55 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:38 AM
Points: 45, Visits: 168

if many dft is that affect the performance are not

Post #1421561

anthony.green

Posted Tuesday, February 19, 2013 4:56 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Depends on your server hardware, load, network etc.

Could be 1 at a time could be 100000000.

Post #1421563

« Prev Topic | Next Topic »

Permissions