On Tue, Aug 9, 2011 at 8:42 AM, Dave Crozier <[email protected]> wrote: > Take a look at Datadmin: http://www.datadmin.com > > it is a database administration tool but has built in Database data/structure > etc syncronisation between servers that you can generate a script for and run > at any time. I use it to synchronise my work development server to the one I > have at home. Also you can have versioned databases if you want and the > program also has a command line interface for scheduling. > > SP's, Views, Functions etc etc are all replicated if required and you can > just copy over Dif data. The free version unfortunately doesn't contain these > features but I can assure you they do work and you can request a one month > evaluation license from the Developer who has added a few things I requested > over the last 6 months. Support is almost immediate as well. --------------
Do you own all three products or just two? Redgate tool belt will handle most of your needs but it is TSQL only, and expensive. You can write your own tools to do this by using the SMO api as well. this is what I am doing because RedGate is expensive. :) What they do is VERY GOOD and fast. <http://www.red-gate.com/> -- Stephen Russell Unified Health Services 60 Germantown Court Suite 220 Cordova, TN 38018 Telephone: 888.510.2667 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYJZc4zpV=S=BewN-ns63x1BnrQKA=qpyyyymdk2rds...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
