Post reply

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

  • September 5, 2008 at 8:23 pm

    #192429

    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

    #868132

    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

    #868136

    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.

  • September 8, 2008 at 12:53 pm

    #868681

    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