TOPIC:

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

Hi Duncan,
if it comes to migration tools between different SQL products, I can recommend the dbMigration.NET by fish from Taiwan ( 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

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