DB diff & update tool?

S

stoymigo

Senior Member
Joined
Dec 11, 2008
Messages
975
Reaction score
26
Hi guys, do you know of a tool that can save database structure & other stuff like stored procedures to a file so that if the app is run on another server it can compare and apply the additional differences?
I'm looking at updating an offline database regularly and I want to see if there is a tool before I try to make my
own solution.
Thanks
 
stoymigo said:
Hi guys, do you know of a tool that can save database structure & other stuff like stored procedures to a file so that if the app is run on another server it can compare and apply the additional differences?
I'm looking at updating an offline database regularly and I want to see if there is a tool before I try to make my
own solution.
Thanks
Click to expand...

What you are looking for is a database migration tool. Most good languages have a few available so without knowing what language you are using it is hard to recommend a specific one.

Have a look at Alembic to get an idea of what is out there.
 
After a few hours of searching I found one:
http://www.codeproject.com/Articles/33414/A-Tool-to-Compare-SQL-Database-Schema-Versions

I haven't tested it completely but it does allow you to save the database structure and compare it to another database's structure.
It recognizes when stored procedures are missing or when fields are missing, but I need to test if a field is changed and if a stored procedure is only changed.

A little hard to use, but seems to be the best free I've tried, and I need it for SQL 2000 only.
 
Money is an issue for me, doing some dev 4 some guy and he won't be paying R1000 for such a tool, plus you can make a basic version yourself.
 
R1000??

Ok, Scratch Redgate from that list, you're looking at minimum $300 for one tool, and you're probably need a few of them.
 
_kabal_ said:
Liquibase
Click to expand...

Thanks, Will Check


ToxicBunny said:
R1000??

Ok, Scratch Redgate from that list, you're looking at minimum $300 for one tool, and you're probably need a few of them.
Click to expand...

Yeah and they'll probably have extra features which I won't need. Plus the person I work 4 has a limited budget.
Not that I'm closed to the idea of buying tools that make your life easier.
 
stoymigo said:
Thanks, Will Check




Yeah and they'll probably have extra features which I won't need. Plus the person I work 4 has a limited budget.
Not that I'm closed to the idea of buying tools that make your life easier.
Click to expand...

For MS SQL stuff, the redgate tools are awesome.. but they're not small company/developer friendly in terms of cost.. we use them at work, SQLPrompt is bloody good, and the DB compare functionality is some of the best I've ever played with.
 
Hey there,

I currently use MsSQL, but this also works with MySQL...

It can copy a database (With views, procedures, structures etc), manipulate, and directly write to a connection.

The visual interface is also not to shabby:

http://www.datanamic.com/dezign/
 
AcidRaZor said:
I usually don't recommend **** software ;)
Click to expand...

Hehe, I'd rather try free software first.

I asked because it will take some time to develop a solution, whether it's 2hrs/2 days, it's nice to see what's out there.
 
I use Toad for Oracle. There is a Toad for MS SQL, mySQL etc.

There is a free version and an overpriced version.

Worth a look. I can't be sure if the free version will do everything you need. I havent used the free version for eons. Company has licences :)

Toad is popular in the industry. Made their name with the Oracle version.

The fact that they can get people to fork out over £800(the cheapest)for a single licence says a lot about the product. The MySQL is about £480.

This is the link to the SQL server freeware version
http://www.toadworld.com/Downloads/ToadforSQLServerFreeware/tabid/562/Default.aspx
 
Damn, I'm not so clever I found out.
The free tool I used can't make a proper sql script to execute, so I thought let me make one myself - did the part for synchronising stored procedures and then it clicked to me that I should use a tool to compare an old and an updated db on my side, and the difference that is generated as a sql script can be sent to the client to execute.

I used OpenDB diff, note that it works with SQL 2005 +, not SQL 2000.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X