Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: basic replication question

    I'm interested in creating a replicated SQL server database on my laptop to develop without having to be connected to the network. I'd like to make changes and then synchronize when connected, both data and design changes. With SQL it looks like replication only applies to data and not to schema, stored procedures, dts packages, etc.

    Do I understand this correctly.
    Thanks,
    Bill

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Do I understand this correctly.
    Nope.

    See
    Schema changes under replication in bol.
    A stored proc can be an published article.
    DTS packages are stored in msdb..sysdtspackages if you keep them in sql server and you can copy them by copying the contents of this table.
    It's usually easier just to copy all the stored procs too.

    Have you thuoght about restoring a backup rater than replication which has quite a large learning curve and administrative overhead.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •