Post reply

Replicate tables, stored proc''s and DTS Packages?

  • June 17, 2005 at 9:31 am

    #362973

    Guys,

    I would like to get inputs on how to go about replicating tables, stored proc's and DTS Packages from a Production Server to Development server in SQL Server 2005 environment!

    I appreciate your time on this!

    Thanks,

    Ram

  • June 19, 2005 at 3:00 pm

    #566638

    Replicating tables and stored procs is the same in SQL 2005 as it was in SQL 2000 - transactional, snapshot, merge etc. There are loads of new features, and one that might be relevant to your case is the automatic replication of schema changes - as you are talking about stored procedures. I'm not sure if anyone has yet created scripts to replicate SQLIS packages (the new DTS) but I'll post back if I hear of anything.

    HTH,

    Paul Ibison, SQL Server MVP (http://www.replicationanswers.com)


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • June 20, 2005 at 7:07 am

    #566701

    Paul,

    Thanks for your inputs!

    Ram

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

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