How to generate SQL script from Access database?

N

news.comcast.net

Hi,
I am trying to generate sql scripts from Access database that can be used to
create databases in different database systems. I have tried a few third
party tools such as Interbase Data Pumper and SQL To Interbase Wizard;
however, they don't do the job well.

Please help.

GD
 
V

Van T. Dinh

Unfortunately, each SQL tends to have their different flavours so an SQL
script for one particular dabase engine may not work to re-create the
database in another engine.

Most likely, you will need to make do with the best you can find and then
manually edit the SQL to suit the target database engine rather than trying
to find a perfect scripter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to generate SQL script for Access databas? 1
Help creating a search form in Access XP 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Adding data to MS Access from csv file 0
generating sql script from diagram 1
Migrating app from 2003 to 2010 0
MS Access 2010 Training database 0

Top