0
Answered

Change database

Ken Gillett 5 years ago updated by dominic 3 weeks ago 3
Once a model has been created based on a specified database, how can you then change it to use a different database?

Looks to me like you cannot, which is rather limiting and major headache if you've spent a long time developing it and then find you have to use a different database,

Answer

Answer
Answered
You can do it this way:
1. export existing model as XML,
2. create a new model in the DB of your choice with this XML as a starting point. You can upload it in "From Vertabelo XML" tab.

After this operation, remember to recheck all "Additional Properties" of tables, columns etc. you've set (if any), since different DBs have a different set of those additional properties.

I hope this helps.
Answer
Answered
You can do it this way:
1. export existing model as XML,
2. create a new model in the DB of your choice with this XML as a starting point. You can upload it in "From Vertabelo XML" tab.

After this operation, remember to recheck all "Additional Properties" of tables, columns etc. you've set (if any), since different DBs have a different set of those additional properties.

I hope this helps.
That's how I ended up doing it, but it's a convoluted process. Far better if there was an option to simply change the database and then just report the errors, as when importing it in the method outlined above. 

There is option in the software to change the database and by using this option one can change the information at any time if he wants. Hopefully the best dissertation writers information will help you out.