I would like to ask how to use a MSSQL as the backend of umbraco instead of the default vistaDB. Can we change the default provider name, umbraco connection string? Do you have any code examples using MSSQL for umbraco? We dont want to use vistaDB anymore if that is possible, we want everything on MSSQL. How do we do this?
Umbraco can use a range of databases. The easiest thing to do is create a new database on your MSSQL server. Then install (temporarily) a new copy of umbraco and select MS SQL from the installer. Once you've got umbraco installed your database will have all its tables and the web.config file will have the proper connection string.
There are some posts on how to migrate from VistaDB to MS SQL on the forum and also on Google if you need that.
Thats what we are trying to do. To migrate from VistaDB to MSSQL. Im not sure if we can import all the data from vistaDB to MSSQL, when we use the vistaDB builder the script that it generates for MSSQL gives us errors.
But basically to migrate is just changing the connection string on the web.config and migrating the data to the MS SQL database right?
MSSQL and umbraco membership
Hi!
I would like to ask how to use a MSSQL as the backend of umbraco instead of the default vistaDB. Can we change the default provider name, umbraco connection string? Do you have any code examples using MSSQL for umbraco? We dont want to use vistaDB anymore if that is possible, we want everything on MSSQL. How do we do this?
Regards,
Harry
Umbraco can use a range of databases. The easiest thing to do is create a new database on your MSSQL server. Then install (temporarily) a new copy of umbraco and select MS SQL from the installer. Once you've got umbraco installed your database will have all its tables and the web.config file will have the proper connection string.
There are some posts on how to migrate from VistaDB to MS SQL on the forum and also on Google if you need that.
cheers,
doug.
Thats what we are trying to do. To migrate from VistaDB to MSSQL. Im not sure if we can import all the data from vistaDB to MSSQL, when we use the vistaDB builder the script that it generates for MSSQL gives us errors.
But basically to migrate is just changing the connection string on the web.config and migrating the data to the MS SQL database right?
Regards,
Harry
Has anybody done a flawless migration from a vistaDB install to MS SQL? Can you teach us how? :D
Thank you.
is working on a reply...