question

siugoalie78 avatar image
siugoalie78 asked

Generate Scripts without Replication Items

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.
replicationsql server 2008 r2generate-script
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

siugoalie78 avatar image siugoalie78 commented ·
Actually, it looks like the Conflict tables aren't even available to uncheck when generating these scripts. You get them no matter what.
0 Likes 0 ·

1 Answer

·
WilliamD avatar image
WilliamD answered
I would look at the Red-Gate tools for this. [Schema Compare][1] 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. [1]: http://www.red-gate.com/products/sql-development/sql-compare/
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

siugoalie78 avatar image siugoalie78 commented ·
While I appreciate William actually bothered to write SOMETHING, "Go buy this piece of software" isn't really the solution I was looking for, as it doesn't work for me in my environment. I am un-marking this as answered, as it is not, and I did not sanction this answer on my behalf. If nobody else can answer it, I'll delete it.
0 Likes 0 ·
siugoalie78 avatar image siugoalie78 commented ·
0 Well, apparently I cannot un-mark it. Grant Fritchey - please undo your mark you placed on my behalf.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.