Database Structure Compare Tool

Question

Post reply

Database Structure Compare Tool

rechousa

SSC Enthusiast

Points: 185
More actions
March 17, 2005 at 6:25 am

#88296

Hi !
What's the best tool for database structure compare ?
I've tried RedGate SQL Compare, but is to slow.
Lockwood SQLDiff v2.3 has bugs.
The best tool I've found so far, is ApexSQL (but the trial is over, eheheh). Is there another one better than this ?
Thanks in Advance,
Regards,
Pedro Martins

Rechousa,
V.N.Gaia
Portugal

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

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

Jason Hall Hall of Fame Points: 3906 More actions · Answer 1

Give Speed Change Manager a shot from Imceda (www.imceda.com)

Bill Wehnert Ten Centuries Points: 1057 More actions · Answer 2

I use AdeptSQL's SQLDiff - it is smokingly fast and very affordable. (http://www.adeptsql.com)

I use this tool each time I deploy a new release. I compare my production databases to my QA server where we have all of the final scripts and adjustments made. This way I can find out if we didn't deploy something and get it out before we turn the app back on.

Bill

Ad maiorem Dei gloriam

Mike Dominick Ten Centuries Points: 1043 More actions · Answer 3

We use Imcedas Speed Change Manager and are really happy with it.

It has saved us considerable time building migration scripts and has identified changes that we would have missed when building our migration scripts manually.

Mike

schumacr SSC Veteran Points: 282 More actions · Answer 4

A couple of guys here use Embarcadero's Change Manager, and they seem to really like it. Simple, and quick. Plus it does cross-platform (Oracle, DB2, etc.) where others won't.

Paul Tischleder Newbie Points: 1 More actions · Answer 5

I use AdeptSQL Diff and have been very happy with it.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 6

On a side note... Lockwood Technologies became ApexSQL some time ago. So the ApexSQL one is obviously much newer.

K. Brian Kelley
@kbriankelley

Adrian Sims-164328 SSC Journeyman Points: 94 More actions · Answer 7

We have been using Embarcedro ER/Studio ( I have been told that this has the basic components as Change Manager) for producting upgrade script , and the method of creating a new column is by

- Drop all RFI referencing table

- Rename table to some temp name

- Create new table

- INSERT into new table select from temp data

- ADD RFI / Indices

but I would like a product that simply produces ALTER TABLE ADD/DROP/ALTER COLUMN statements that have been in existance from SQL 2000 ( I think )

The old method has worked well in the past , but in a SQL 2005 demo , the new improved replication automatically supported columns that were changed using ALTER TABLE, without any other interaction which was very impressive !

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 8

There is free tool called dbMaestro

http://www.dbmaestro.com/products/ActivatedbMaestro.aspx

http://www.sqlservercentral.com/columnists/dasanka/reviewdbmaestro.asp

My Blog: http://dineshasanka.spaces.live.com/

JellyRoll SSC Enthusiast Points: 138 More actions · Answer 9

Hi All,

I'd go with Red Gate SQL Compare for accuracy reasons. It will attempt to alter your columns if it can rather than trying to rebuild the table every time, provided you haven't enabled the switch to preserve column order. Of course, in that case, it's going to go through the process above in dropping the table and all dependent objects and rebuilding the table and copying the data back. This can be a headache in tables with millions of rows of data!

Regarding the speed of it, it's fairly quick since version 3. Version 2 was slow indeed.