Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL database comparison

Author  Topic 

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2005-06-02 : 06:06:45
Hi,

I sort of accidentally stumped upon a small piece of freeware called StarInix SQL Compare, have any of you guys tried it out? I'm thinking there must be something wrong here but the app seemingly works like nothing I've seen before! The application is a completely standalone file of about 500kb and it compared my 600-objects test and production database in about 10 seconds (they are in different countries!!). It only checks for the existance of objects and fields in tables but still...could prove to be invaluable for me. Second opinions anyone?

-> http://www.starinix.com/products.htm

(I have absolutely nothing to do whatsoever with this site or its creators)

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-06-02 : 09:41:45
If it's free, and works for you... you don't really need a second opinion

It does look cool though. In the past I've used Red Gate's SQL Compare, or if I'm feeling ghetto I just script out the databases and DIFF them.


Damian
Ita erat quando hic adveni.
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2005-06-02 : 09:53:29
The thing is that after workigng a few years in the business I have learned that anything that seems to good to be true, usually is

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
Go to Top of Page
   

- Advertisement -