SQL Server Performance

Replication of schema/table structure without data

Discussion in 'SQL Server 2005 Replication' started by IT-Drone, May 18, 2006.

  1. IT-Drone New Member

    I am a relative neophyte when it comes to doing database replication. I would like to know how to set up a databse replication plan in Sql Server 2005 [RTM] which will replicate only the table structures (schema) without copying the approx 2,000,000 lines contained within those tables. Thanks in advance for your assitance.
  2. satya Moderator

    Why do you want to waste SQL resources with replication for this, you can script the schema and apply to the desired database/tables. Refer to the books online (2005)for Object Explorer Wizards F1 Help or press F1 Help for the wizards in SQL Server Management Studio.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page