SQL Server Performance Forum – Threads Archive
Replication of schema/table structure without dataI 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.
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.