fbpx
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: DB Migration Tools

DB Migration Tools 25 Jun 2020 07:33 #15064

  • chiwi's Avatar

  • chiwi

  • Topic Author


  • Posts: 4
  • 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
    DV Bern AG
    Bern, CH

    Please Log in or Create an account to join the conversation.

    Last edit: by chiwi.

    DB Migration Tools 25 Jun 2020 07:57 #15065

  • wriedmann's Avatar

  • wriedmann


  • Posts: 2281
  • 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
    Wolfgang Riedmann
    Meran, South Tyrol, Italy

    www.riedmann.it - docs.xsharp.it

    Please Log in or Create an account to join the conversation.

    DB Migration Tools 06 Jul 2020 08:32 #15118

  • chiwi's Avatar

  • chiwi

  • Topic Author


  • Posts: 4
  • 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
    DV Bern AG
    Bern, CH

    Please Log in or Create an account to join the conversation.

    • Page:
    • 1