September 5, 2008 at 8:23 pm
I have read about ssis but am still not sure how I would do this.
I have two sql 05 servers. I would like 3 of the tables on one to copy over to another in an another domain. The other server is reachable through a vpn link. Could I set this up so it would happen automatically every night?
thanks
September 6, 2008 at 6:42 am
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
September 6, 2008 at 7:11 am
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 8, 2008 at 12:53 pm
How big are the tables ?? If they're huge, transactional replication might be good. otherwise the SSIS option would be simpler.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply