1
General Board / Re: Database not defined
« on: September 13, 2010, 03:43:11 pm »
In fairness, it's not entirely stupid to expect this to work. If you generate plain vanilla DDL it should work with most databases supported or not and at the very least it does a lot of the typing and just needs a little bit of Search & replace massaging to make it work.
I right clicked on a table in my model did export DDL & got a nice helpful dialog giving me options which then generated a nice script. All seemed to work fine. I've not used SQLite, I have got an Oracle ODBC driver installed but I'm pretty sure it wasn't being used.
Now the table I generated the DDL from was reverse engineered from Oracle & on the table properties page (right click on the table & select "Properties") the Database set was Oracle so I think that could be your problem. Select one of the database types & experiment to see which supported database is closest in syntax to SQLite.
Good Luck
Mike
I right clicked on a table in my model did export DDL & got a nice helpful dialog giving me options which then generated a nice script. All seemed to work fine. I've not used SQLite, I have got an Oracle ODBC driver installed but I'm pretty sure it wasn't being used.
Now the table I generated the DDL from was reverse engineered from Oracle & on the table properties page (right click on the table & select "Properties") the Database set was Oracle so I think that could be your problem. Select one of the database types & experiment to see which supported database is closest in syntax to SQLite.
Good Luck
Mike