Compare Tables in 2 database

ajayjain
ajayjain Member Posts: 119
edited 2014-03-17 in NAV/Navision Classic Client
Hi,

Is there any way I can compare my 2 database and it can show me only tables & fields which are different
by different fields data type, size or missing field etc.

Ideally, if I can sync all tables structures automatically would be superb
like adding fields, change data type, length, adding new table from 1 database to another

I can google for sql scripts but I cannot add fields via sql

Thanks
Ajay
Ajay Jain
UK

Comments

  • kriki
    kriki Member, Moderator Posts: 9,127
    [Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]

    Trick: create a form/page on table "Field" (a virtual table) and copy the output in Excel. Then it is easy to confront.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • ajayjain
    ajayjain Member Posts: 119
    Thanks Kriki,

    I thought about field table as well
    export into excel and import into another database in temp table and compare
    but I will have to modify tables manually.
    that will not take long copy/paste

    thanks
    Ajay Jain
    UK

Categories