CODEWITHSUNDEEP
sql-serverreplicationdatabase-schema
Tom Limksky
Tom Limksky

Reputation: 11

SQL Server - Schema only replication

Is there a way to replicate only schema (and all schema objects) without data between two SQL server instances?

Upvotes: 1

Views: 2073

Answers (2)

Kenneth Fisher
Kenneth Fisher

Reputation: 3812

I found this researching something else so I don't know if it is still an issue for you or not but there is an object in SSIS called Transfer SQL Server Objects. I haven't used it before but it has an option to copy data or not and you can select copy all objects or just specific types of objects, permissions etc.

Upvotes: 0

Stephen Turner
Stephen Turner

Reputation: 7314

For copying, rather than replicating, the simplest way would be to "Create scripts" for the database and run them on target server. This will create a new blank database on the new server.

Replicaton in SQL server implies that as you make changes to one schema they are automatically replicated on the other server. This can be done to some extent with SQL server replication, you just prevent he data being transferred but setting a criteria. I don't see how this would be of much use though.

Upvotes: 1

Related Questions