DB Migration Tools

chiwi · Post by **chiwi** » Thu Jun 25, 2020 5:33 am

Hi everyone

I was just wondering if anyone/has and DB Migration tool recommendations they would like to share? In particular for moving from Advantage to PostgreSQL.

We have a DB schema with some 400 tables with about 50 instances (an instance per Customer). I know EDB has some tools, and I found a promising looking tool from Spectralcore. Has anyone used these tools for migrating from Advantage?

Thanks in advance for any suggestions.

Cheers

Duncan

wriedmann · Post by **wriedmann** » Thu Jun 25, 2020 5:57 am

Hi Duncan,
if it comes to migration tools between different SQL products, I can recommend the dbMigration.NET by fish from Taiwan ( https://www.fishcodelib.com ), and the author is really helpful if needed.
For a migration from Advantage I would write something myself - compared with the changes needed in the application this should be really easy to accomplish.
If you need code to create/modify PostgreSQL tables in X# please let me know - I have done something not only for PostgreSQL, but also for SQLite. What my tools is currently missing in this context are the indexes.
Wolfgang

chiwi · Post by **chiwi** » Mon Jul 06, 2020 6:32 am

Hi Wolfgang

Thanks for you reply and inputs. I took a look at dbMigration.NET and from my limited testing seems to be a pretty good tool.

As for writing our own migration script, while it could be done, having a tool do most of the work for us will work out much cheaper.

The tool "Full Convert" from Spectral Core covers pretty much everything we need it to do: data & index migration, schema & datatype mapping, cli support. For less than the cost of one developer day.

Thanks again, Cheers,

Duncan