Replicating structure only not data

I have a SQL 2005 database that I am using with a website. This basic website will be sold to other companies and ran on their servers with different URLs. Since, All of these databases will store different data, I'm not sure how I can make updates to original database and replicate those structure changes to the other DBs without changing the data also. Is there a way to automate the replication of structural DB changes without replicating the data along with it?

Thanks,

Kirk

You can enable @.replicate_dll at publication level, which will push the schema change to your subscriber. And you can set all the ins/upd/del commands to NONE for all of your articles, which will ignore all the data changes that took places on the publisher.

Gary

|||

Thanks Gary,

I am not new to SQL 2005 but I have never done any replication. Could you lead me to a good reference that would explain how to do some of the things that you wrote about? Any help is greatly appreciated.

Kirk

|||

I think the following would be a good start

General info on transactional replication

http://msdn2.microsoft.com/en-us/library/ms151176.aspx
http://msdn2.microsoft.com/en-us/library/ms151706.aspx

Creating create publication - by default @.replicate_ddl is on, so it will replcate ddl (aka - schema changes)

http://msdn2.microsoft.com/en-gb/library/ms147855.aspx
http://msdn2.microsoft.com/en-gb/library/ms188738.aspx

Create article - you want to set @.ins_cmd='NONE', @.upd_cmd='NONE', @.del_cmd='NONE'

http://msdn2.microsoft.com/en-gb/library/ms173857.aspx

Regards,

Gary

|||Thanks Gary, I will take a look at those links.