all groups > sql server replication > may 2007 >
You're in the

sql server replication

group:

HowTo: DDL replication only, no data ?


HowTo: DDL replication only, no data ? mEmENT0m0RI
5/21/2007 11:21:51 AM
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


Re: HowTo: DDL replication only, no data ? Paul Ibison
5/21/2007 9:17:27 PM
Have a look at Redgate's SQL Compare....
HTH,
Paul Ibison

RE: HowTo: DDL replication only, no data ? Paul Ibison
5/22/2007 1:49:00 AM
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
RE: HowTo: DDL replication only, no data ? mEmENT0m0RI
5/22/2007 6:40:53 AM
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



RE: HowTo: DDL replication only, no data ? Paul Ibison
5/22/2007 8:12:01 AM
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
RE: HowTo: DDL replication only, no data ? mEmENT0m0RI
5/22/2007 9:20:46 AM
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.



RE: HowTo: DDL replication only, no data ? Paul Ibison
5/22/2007 9:40:02 AM
Can't vouch for it but this looks interesting:
http://www.idera.com/Products/SQLchange/
Probably much the same as what you can build yourself, but might save a
little time....
Cheers,
Paul Ibison
Re: HowTo: DDL replication only, no data ? mEmENT0m0RI
5/22/2007 1:30:47 PM
Paul,
I would assume your yesterday's reply has just made it LOL



Re: HowTo: DDL replication only, no data ? Hilary Cotter
5/25/2007 7:05:48 AM
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]

Re: HowTo: DDL replication only, no data ? mEmENT0m0RI
5/25/2007 12:32:40 PM
!!!That's IT!!!

Thank you very much!



AddThis Social Bookmark Button