View Single Post
Join Date: Nov 2008
Posts: 1
Reputation: tom_wilson is an unknown quantity at this point 
Solved Threads: 0
tom_wilson tom_wilson is offline Offline
Newbie Poster

Migrating database made easy

 
0
  #1
Nov 14th, 2008
Working with multiple database I was always wondering if there's a way to simply transfer tables structures and data from one database to another.

Looking over the internet I found that using a database migration SQL script is often the best way to migrate a database. Then I found SQL Script Builder, with this small but yet powerful app I was able to connect to my data source using ODBC, a universal interface, extract data as SQL, and dump data to destination, like for example uploading the script on one website server.

Scripts can be made as MySql, MS SQL, Oracle, Pervasive and Postgres.

You can also export to Access mdb, xml and csv files !

I hope you will find this link useful : http://www.sqlscriptbuilder.com

Tom
Reply With Quote