I have a database that uses Transactional Peer to Peer replication on SQL Server 2008 R2. Periodically, I need to generate scripts (schema only) to send to other offices who do not have access to my servers to utilize. Normally, I use the Generate Scripts wizard for this, but, the scripts always include all the replication objects (System tables, Stored Procedures, etc). Is there an easy way to generate the scripts without including these items? I know I can uncheck them individually from the list of objects to generate, but that is a lot of boxes to uncheck, and I'm afraid i would inadvertently uncheck the wrong thing.
I would look at the Red-Gate tools for this. [Schema Compare] would be the tool to do this. It can generate scripts for you and allows you to filter out certain object types. It can be scripted via command line if I recall correctly, so that you could generate the scripts semi-automatically too. :