Book a Demo

Author Topic: Export DDL to different DBMS?  (Read 4150 times)

Bill Egge

  • EA User
  • **
  • Posts: 93
  • Karma: +0/-0
    • View Profile
Export DDL to different DBMS?
« on: November 24, 2015, 01:33:43 am »
Is it possible to convert a database model from one DBMS to a different one?

I have imported a table structure from Pervasive and would like to generate a SQL Server version of it.  If I try to generate the DDL I get an error saying "Pervasive.SQL" does not exist or something like that even though I setup the project and imported as SQL Server 2012.

MMA

  • EA User
  • **
  • Posts: 63
  • Karma: +3/-0
    • View Profile
Re: Export DDL to different DBMS?
« Reply #1 on: November 24, 2015, 09:09:06 am »
There are two processes:
1. Import: connect to the database from EA and import the schemas
Then EA will have a model, you can change this model's database to another DBMS.
2. Export: Export this model as .SQL or Execute the generated sql to create tables/indexes/procedures....

However, I'm not quite sure whether "Pervasive" is supported or not.
« Last Edit: November 24, 2015, 09:13:22 am by milesma »