sql server replication:
I'm trying to keep my QA environmens in Sync. Is there a way to only transfer the schema changes without data? Thanks, Igor
Have a look at Redgate's SQL Compare.... HTH, Paul Ibison
Something strange here as I answered this yesterday but my reply disappeared! Anyway, I'd investigate Redgate's SQL Compare tool - we use it for something similar for auditing and it runs fine. Paul Ibison
Paul, Thanks for your reply. We do use this same tool here as well. However, I don't believe I can automate the procedure in there. I have 6 QA environments I have to keep in synch, doing 6 compares could be quite time consuming. Thanks, Igor
In that case I'd manage the change control requests centrally and propagate them out via scripts. You can use OSQL to run scripts against each server. Once a change control script comes in, you just run it in using a central batch file. You could do the same thing using linked servers. There is an API for RedGate tools, but it would amount to much the same thing, and for this type of thing you could easily create your own GUI quite easily to conceal the distributed programming required. HTH, Paul Ibison
It seems like this is waht I'm going to end up doing. Just wanted to make sure there wasn't a functionality like that already availble before I would start reinventing the wheel. Thank you for your replies.
Paul, I would assume your yesterday's reply has just made it LOL
Put filters that always evaluate as false on each table. Ie where 1=2 -- Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "mEmENT0m0RI" <nospam@devdex.com> wrote in message news:ex0DoT9mHHA.1776@TK2MSFTNGP05.phx.gbl... > I'm trying to keep my QA environmens in Sync. Is there a way to only > transfer the schema changes > without data? > > Thanks, > Igor > > > *** Sent via Developersdex http://www.developersdex.com ***
!!!That's IT!!! Thank you very much!
Don't see what you're looking for? Try a search.
|