December 7, 2009 at 2:16 am
Hi All,
I have a small database that needs upgrading as opposed to making changes to the production database i oftern take a backup and work on it offline. What is the best way of getting my changes (tables / views and procs) back into the live database?
at present im just making a note of my changes then replicating them manually back into the live database but this is sometimes a lengthy process.
just wondering what is the best practice for this?
Regards
Greg
December 7, 2009 at 7:19 am
The easiest way is to buy a product like RedGate SQLCompare or Apex SQLDiff.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 7, 2009 at 8:06 am
gregwhite83 (12/7/2009)
Hi All,I have a small database that needs upgrading as opposed to making changes to the production database i oftern take a backup and work on it offline. What is the best way of getting my changes (tables / views and procs) back into the live database?
at present im just making a note of my changes then replicating them manually back into the live database but this is sometimes a lengthy process.
just wondering what is the best practice for this?
Regards
Greg
Generally, I'd suggest that you get all the databases into source control and then come up with a mechanism for building your database out of source control (as previouisly mentioned Red Gate or Apex have tools, or there's Visual Studio or even writing your own) automatically. Then, you only make changes to the source code, deploy it to dev or to sandbox machines, qa, etc., label versions, and do targeted builds to prod. It's a pretty complicated process to set up, but really easy to maintain and has HUGE awards for time & effort in the future.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 7, 2009 at 10:56 am
Many thanks for the replies, i will check out the products.
Cheers,
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply