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. Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Malcolm Greene Sent: 09 August 2011 11:42 To: [email protected] Subject: [NF] Copying SQL Server 2008R2 databases SQL Server gurus: I'm working on a project where we need to copy a build copy of a database to a public facing equivalent database. Both databases will exist on the same SQL Server instance. The build database schema may change from time to time, so we can't do a simple truncate and copy. This is one of those tasks that sounds easy until you drill into the details, eg. detach/attach vs. alter, copy vs. backup/restore, forcing exclusive access/restoring multi-user access, copying schema and data, moving rights/priviledges, etc. Any recommendations on a script or utility to make the process fast and fool proof and/or tips on things to watch out for during this process? We would like to automate this process so that it runs on an automated basis several times a day. Thanks, Malcolm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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/[email protected] ** 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.
