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 --- _______________________________________________ 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.
