Deploying application with MS SQL Server database

So far I have develop and run CUBA based application with PostgreSQL database and now I need to implement the same application on MS SQL Server as database.

In the user guide, it is said that we have to user clustered id here. When I use the MS SQL Server as a database in the IDE and build the application, will CUBA studio automatically regenerate the database / table creation scripts based on these requirements or I will have to modify it manually?

CUBA Studio will generate necessary scripts for MSSQL dialect. For that you need to change dbms type in the Main Datastore settings dialog and re-run CUBA -> Generate Database Scripts action.

1 Like

Thanks. It worked.