I have a bunch of SQL files that I use in DBISAM to create tables. Unfortunately they don't work with ElevateDB because the syntax is different.

Is there some quick and dirty way I can convert my DBISAM SQL files into something that works with ElevateDB?

Richard


Being sneaky I'd suggest create a DBISAM database, use your files to create tables in there. Migrate that to ElevateDB and reverse engineer the result.

Roy Lambert [Team Elevate]

Roy Lambert wrote:

>Richard
>
>
>Being sneaky I'd suggest create a DBISAM database, use your files to create tables in there. Migrate that to >ElevateDB and reverse engineer the result.
>
>Roy Lambert [Team Elevate]


Roy you are a genius. That worked great. The only problem was that the migrator used a collation of ANSI when I would have liked ANSI_CI. However, the reverse engineer function lets you map ANSI to ANSI_CI when you create the SQL script, but unfortunately it doesn't alter the fields in the database.

Richard


This is the script I used in converting a major app. You should be able to adapt for your purposes. Its probably missing an END cos I chopped out all the highly specific stuff from the bottom.

Roy Lambert [Team Elevate]