How to generate SQL script from Access database?

  • Thread starter Thread starter news.comcast.net
  • Start date Start date
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
 
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.
 
Back
Top