Deploying application with MS SQL Server database

Support
#1

Hi
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?

#2

Hi,
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
#3

Thanks. It worked.