Development and Production Database Synchronization

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Development and Production Database...

Development and Production Database Synchronization

Rate Topic

Display Mode

Topic Options

Author

Message

gregwhite83

Posted Monday, December 07, 2009 2:16 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 25, 2013 10:22 AM
Points: 2, Visits: 9

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

Jack Corbett

Posted Monday, December 07, 2009 7:19 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

Grant Fritchey

Posted Monday, December 07, 2009 8:06 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:57 PM
Points: 13,371, Visits: 25,152

gregwhite83 (12/7/2009)

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

gregwhite83

Posted Monday, December 07, 2009 10:56 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 25, 2013 10:22 AM
Points: 2, Visits: 9

Many thanks for the replies, i will check out the products.

Cheers,
Greg

Post #830082

« Prev Topic | Next Topic »

Permissions