Database Compare

Question

Post reply

Database Compare

Prateek Guru

SSC Enthusiast

Points: 153
More actions
July 2, 2003 at 10:19 am

#82703

I want to compare the DDL/Schema, Views and Stored procedures on two versions of my database. Is there any utility or scripts to do that ?
Thanx in advance.
Prateek.

Prateek.
~~~~~~~~
"Remember: 80% of bugs are just undocumented features waiting to be discovered!"

Viewing 11 posts - 1 through 10 (of 10 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 1

Check out SQLCompare from Red Gate. Low priced and seems to work well.

Our own Andy Warren loves it!

http://www.sqlservercentral.com/columnists/awarren/reviewofsqlcomparisonandsynchronizationtoolkit.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 2

I use SQLCompare. Think you can download a trial copy. If you like it I would buy it. It is a great tool for a number of different things. One thing it does good, is create the database objects in the correct order. This helps if you have view A the use view C.

EM generates view A first, then view c, so your create scripts fail, since view C does not exist. But SQLCompare knows this dependency exists and creates view C prior to creating view A.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

Crispin Proctor SSCoach Points: 18161 More actions · Answer 3

Another brilliant one (My favorite) is Embarcadero's Change Manager.

http://www.embarcadero.com/"> http://www.embarcadero.com/

Cheers,

Crispin

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Tim-24860 Mr or Mrs. 500 Points: 578 More actions · Answer 4

I've been using SQLDiff by Lockwood http://www.lockwoodtech.com/index_sqldiff.htm

I found SQLCompare very slow.

Prateek Guru SSC Enthusiast Points: 153 More actions · Answer 5

Thanx all for all the trouble and prompt replies.

Prateek.

Prateek.
~~~~~~~~
"Remember: 80% of bugs are just undocumented features waiting to be discovered!"

G.R.Prithiviraj Kulasingham SSCarpal Tunnel Points: 4105 More actions · Answer 6

there are a few scripts available at SQLServerCentral.com

try one (It is mine so that I may help you)

http://www.sqlservercentral.com/scripts/contributions/221.asp

There are a few other scripts as well. Please try some of them

Cheers,
Prithiviraj Kulasingham

http://preethiviraj.blogspot.com/

JanVangorp SSC Veteran Points: 262 More actions · Answer 7

I'm currently using SQLMatcher (http://www.berryware.com) which does the work. Even supports my older 6.5 databases. And has some nice batch options.

Prakash Heda SSCertifiable Points: 5539 More actions · Answer 8

I have used DBDiff and it does the job..

Prakash

Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA

j_g_krishnan Old Hand Points: 319 More actions · Answer 9

quote:
I want to compare the DDL/Schema, Views and Stored procedures on two versions of my database. Is there any utility or scripts to do that ?
Thanx in advance.
Prateek.

j_g_krishnan Old Hand Points: 319 More actions · Answer 10

quote:
There are many SQL server Schema Comparision Utilities available in market.
AdeptSQL (http://www.adeptsql.com) is one such a utility
Thanks
JGK
I want to compare the DDL/Schema, Views and Stored procedures on two versions of my database. Is there any utility or scripts to do that ?
Thanx in advance.
Prateek.