tags:

views:

105

answers:

4
+1  Q: 

Searching for (freeware) database migration tool

Hello there!

I'm searching for a tool to dump a database including DDL and content as plain SQL-SCript, so that in can be archived in plain text format. I know e.g. the Oracle dump tools or mysqldump, but is there a tool which can connect to different datasources and get the job done? GUI would be great.

Thanks, Chris

+1  A: 

Look at set of SSMA Microsft's free tools (Oracle, Sybase, MySQL..) http://www.microsoft.com/sqlserver/2005/en/us/Migration-oracle.aspx

Dewfy  2010-01-15 15:49:23
A: 

Have a look at Schemacrawler, has no GUI though. http://schemacrawler.sourceforge.net/

DKrause  2010-01-15 15:56:16
+1  A: 

Check out http://squirrel-sql.sourceforge.net/. Gui, cross-platform and supports any database with jdbc driver.

Peter Lynch  2010-01-15 16:00:03
Include an automatic DBCopy plugin too... might let a user omit the need for SQL Script entirely!
BobMcGee  2010-01-15 16:06:23
A: 

You can check database comparer

Hugues Van Landeghem  2010-01-15 19:19:27

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL