April 28, 2004 at 5:07 am
I everybody,
I have to compare two sql databases and need a good, simple and FREE tool. Any suggest?
Tanks
April 28, 2004 at 6:45 am
If you need to compare database structure you can just script out the entire database (of both servers) and then use windows command comp to compare the scripts.
If you also need to compare data, you can use SQL compare from RedGate at
http://www.red-gate.com/sql_tools.htm.
Is not free, but you can download a free trial.
April 28, 2004 at 11:05 am
See http://www.yessoft.com/ for a free compare tool. It only compares, it does not create a script to resolve differences.
Francis
April 29, 2004 at 5:57 am
considering the low cost of Redgate's SQL Compare I'd suggest you buy a copy, It's been an essential part of my toolbox for some years and is a key tool for the DBA team at my current employment.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 29, 2004 at 9:19 am
If you want something easy to use that even a an average pc user can handle, then you can't go wrong with :
http://www.topshareware.com/SQL-Server-Comparison-Tool-download-10628.htm
I found redgate a bit awkward to set up and some of the others way too confusing. This particular tool brings up schema A one side of a screen, and schema 2 on the other and gives various options for comparison. However, if you are looking to produce reports then this is not the option; there are none.
Want I want to know is how come Toad make such a good comparison tool for oracle, yet no-one has really come close with sql server. I know Toad have just released a sql version, but it is way too basic.
Hopefully someone out there will put something together that is easy to use, shows results on screen, runs reports and generates scripts to synchronise.
Whoops, wake up, I was dreaming there....
April 29, 2004 at 9:47 am
Well I'm slightly confused as SQL Compare does just what you list and is very easy to setup and use ( true you need the dot net framework ). Maybe you saw an old version of the product?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 29, 2004 at 9:55 am
Was not on the version I was given. I will download a new version and see. Thanks, Colin. May be some dreams do come true.
April 29, 2004 at 12:56 pm
Here's another free tool (at least until the end of May) http://www.x-sql.com/ This one compares DML, triggers, constraints etc but not data. And it will create the sync script.
Francis
May 4, 2004 at 4:15 am
try http://www.x-sql.com.
Lots of options, pretty fast
May 23, 2004 at 10:37 am
Check out DB Ghost at http://www.dbghost.com/
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply