Tool to convert MS-Access database to SQL script

Question

Our software package uses the MS-Access database, this database has been changed many times, so it’s a little difficult to just browse files (relations between tables are a little hell), anyway,

Is there a way or program to convert this mdb file to SQL Script (any kind of SQL Script will do this for now).

Thanks,

Answer 1

Have you looked at SQL Server migration for Microsoft Access ?

If you convert a copy to SQL Server, you can better understand the database.

Answer 2

SubSonic , "" SQL. .

2.1 SubSonic.

script , App.Config, . .Net App.Config . App.Config : http://subsonicproject.com/configuration/config-options/

:

<?xml version="1.0" encoding="utf-8" \>
<configuration>
    <configSections>
        <section name="SubSonicService" 
            type="SubSonic.SubSonicSection, SubSonic" 
            requirePermission="false"/>
    </configSections>

    <connectionStrings>
        <clear />
        <add name="subTest" 
            connectionString="Data Source=MYCOMP\MICROSOFTSMLBIZ\,56183;Database=someDB;User ID=someId;Password=somePasswrd!"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

    <SubSonicService defaultProvider="subTest">
        <providers>
            <clear/>
            <add name="subTest" 
                type="SubSonic.sqlDataProvider, SubSonic" 
                connectionStringName="subTest"
                generatedNamespace="TerraCognita.Project.Services.DAL"
                includeTableList="^Bug$, ^Person$, ^Groups$, ^Project$, ^TimeInterval$"/>
        </providers>
    </SubSonicService>
</configuration>

, , ( ) , Access. ( , .)

, App.Config. :

[ ]\SubCommander\sonic.exe [Command]/out [OutputFileName]

[Command] scriptschema scriptdata. ( , , . .

Answer 3

You can look at Database Comparer