how to merge production and development database

Question

how to merge production and development database

Betty Sun

SSCrazy

Points: 2442
More actions
November 6, 2006 at 3:31 pm

#153276

Hi everyone,
About six months ago, I made a copy of our production database and started to use it as new development for a separate project. After six months, production database changed many times for other projects. Now this separate project is close to be done and I need to merge all the changes on both production database and testing database. it seems to be a big project, what's the strategy. This is the first time I do this. Can you give me some advices.
it seems I have to move all changes to a development environment and test for both production code against this database and this new project. Do I need to use enterprise manager to create all database objects on both database? don't know the exact step and if I will miss anything.
thank you.
Betty

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

This seems like a situation where a database comparison tool would be handy. Red-Gate SQL Compare, Quest Comparison Suite, ApexSQL Diff, et al. I use ApexSQL Diff to compare objects in two different databases and it generates a script to make the necessary changes.

Greg

laker_42 SSCarpal Tunnel Points: 4785 More actions · Answer 2

We use Red Gate's SQL Compare & Data Compare tools to do this exact thing in our environment. It seems to work very well. Much easier than keeping track of scripts that have changed on both the production & development sides.

A nice feature of SQL compare is that is shows you the differences of two objects line by line. So you can look through & see how the view has changed & whether you need to move that change to production or development.

We use Data Compare to preserve any data that we want to move over from either production or development.

Both have saved us quite a bit of time.

John

PS I do not work for Red Gate.

Betty Sun SSCrazy Points: 2442 More actions · Answer 3

Greg and John,

Thank you both for your advice and information and I will take a look at those sql compare software especially red-gate since you both mentioned that software.

Sincerely

Betty

Betty Sun SSCrazy Points: 2442 More actions · Answer 4

Quick question, what is the exact difference between red-gate standard and professional version, did find it on its web site

Betty

laker_42 SSCarpal Tunnel Points: 4785 More actions · Answer 5

Betty,

You would have to ask Red Gate. I didn't think there was professional & standard edition of SQL Compare. There is for their SQL Backup. Send them an email. They are quick with responses & very friendly there.

John