About Dan Wilson
Dan Wilson
Dan Wilson
Model-Glue:Gesture for Fun and Profit
Watch Video
Presentation Files
DataCurl LLC, My Company
2010 Speaking Engagements
Video Interviews
DZone Articles
How to migrate from one database to another
Posted By : Dan Wilson
May 27, 2008 8:21 AM
I am a fan of most all Database platforms. I have used MSSQL 7/2000/2005, IBM UDB, Oracle 8/9i/10g, MySql 4/5 and PostgreSQL 7.3/8.1 in production. When working in multiple database platforms, there inevitably comes the need to port a database from one platform to another.
Rather than spend my days mapping and transforming a database schema, I use SQL Script Builder. SQL Script Builder is a tool that generates SQL scripts of a database and the data for 5 officially supported platforms:
- MySql
- MS SQL
- Oracle
- Pervasive
- PostgreSQL
The last time I blogged about this tool it lacked proper key management. Newer versions have support for:
- Better importation of primary keys has been added.
- Faster performance
- CSV and XML export formats added
- Better management of Foreign Keys
What I continually love about this program is the excellent support. I had a small issue with the way primary keys from MSAccess were treated in generated scripts under certain conditions. I reported the issue to Dave and his crew. The issue was found, fixed and a new version uploaded to the website in a matter of a few hours. If only all Software Support was that good.
An evaluation version is free, paid version is 20$. No matter how you slice it, this program saves time and provides good value for the money. Check it out at SQL Script Builder
There are no comments for this entry.
Add Comment
Subscribe to Comments
Using ESF Database Migration Toolkit( http://www.easyfrom.net/download/ )
A toolkit migrates data across various database/file systems. Supporting Oracle, SQL Server, MySQL, PostgreSQL, MS-Access, MS-Excel, Firebird, CSV and so on.
Hi, I want to move oracle 9i databse servers running on different platforms to Oracle 10g. Can you please let me know the 'storage migration' steps to do the same?
To move data from one database to another (regardless of their type or location), you can use a tool called Data Moving Tool (http://www.sersoftware.com/prod/data-moving-tool-o...). It's micro ETL that does exactly what you need.
Suscribe
Follow Us
Contact
Thanks for the tip, Dan. I've been using
AdeptSQL Diff (http://www.adeptsql.com) to compare schemas and migrate data between MS SQL databases, but I'll definitely take a look at this product.