Automate copy of 3 tables to sql server in another domain?

Question

Automate copy of 3 tables to sql server in another domain?

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John H Marsh SSChampion Points: 11671 More actions · Answer 1

Hello,

You could consider using Snapshot Replication, but may be a scheduled SSIS package is easier to Administer.

For the SSIS package, use the Export Wizard to perform the task once and use the Wizard’s option to store the task as an SSIS Package. Then use SQL Agent to schedule a regular overnight job to execute the stored SSIS Package.

Regards,

John Marsh

www.sql.lu
SQL Server Luxembourg User Group

Steve Jones - SSC Editor SSC Guru Points: 739542 More actions · Answer 2

I'd prefer the SSIS stuff myself, though it would be more work. Replication will do it, just remember that there will be a time the table is not available as it's dropped/truncated and rebuilt.

homebrew01 SSC Guru Points: 55566 More actions · Answer 3

How big are the tables ?? If they're huge, transactional replication might be good. otherwise the SSIS option would be simpler.