Page 1 of 1

IntegrityCheck/Update methods

Posted: Tue 15 Mar 2022 17:52
by FlorianDahn
Hey!

I have seen that you got a CreateDatabase/DeleteDatabase method in the DataBaseContext.

Is there any way to compare the database model (lqml) to the database and get a list of differences ?
Missing tables, column changes, etc?

And optional an update method, to update the database where you can pass the result of the method from above ?

Thank you!

Re: IntegrityCheck/Update methods

Posted: Tue 03 May 2022 16:33
by Shalex
There is no such functionality in the DataContext class but you can use Entity Developer for this purpose either via design time using Update To Database Wizard (copy update script instead of applying it) or via the console version of the tool calling "ed Get-Update-Script" (https://www.devart.com/entitydeveloper/ ... r_app.html).

Re: IntegrityCheck/Update methods

Posted: Fri 06 May 2022 15:53
by FlorianDahn
Shalex wrote: Tue 03 May 2022 16:33 There is no such functionality in the DataContext class but you can use Entity Developer for this purpose either via design time using Update To Database Wizard (copy update script instead of applying it) or via the console version of the tool calling "ed Get-Update-Script" (https://www.devart.com/entitydeveloper/ ... r_app.html).
Ok, thanks!

Issue here is right now, it seems that only for the Create method I can specify a ConnectionString.
I'm having a server with multiple versions (and names) of the database, would be great to easily change which database to check and generate the update script.

Thank you

Re: IntegrityCheck/Update methods

Posted: Mon 09 May 2022 09:03
by Shalex
Thank you for your suggestion. We will notify you when the --Connection parameter is added to the Get-Update-Script command.