Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Development and Production Database Synchronization Expand / Collapse
Author
Message
Posted Monday, December 07, 2009 2:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2014 10:17 AM
Points: 2, Visits: 98
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
Post #829701
Posted Monday, December 07, 2009 7:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:31 PM
Points: 10,910, Visits: 12,545
The easiest way is to buy a product like RedGate SQLCompare or Apex SQLDiff.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #829838
Posted Monday, December 07, 2009 8:06 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:38 AM
Points: 14,797, Visits: 27,271
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #829883
Posted Monday, December 07, 2009 10:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2014 10:17 AM
Points: 2, Visits: 98
Many thanks for the replies, i will check out the products.

Cheers,
Greg
Post #830082
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse