I am evaluating Umbraco (I noob) and read that it supports multiple databases. My preference is to use an embeddable DB just because it's easier. As such I was considering using VistaDB for all our sites.
I was wondering if anyone could tell me if this is a bad idea? And am I likely to find it difficult to migrate if indeed it does turn out to be a bad idea. (I see a post just now that is about MySQL to MSSQL difficulties :)
Am I delusional thinking embeddable DB would make things easier?
Are there other options that work readily, such as firebird or SQLite?
Yup, vistadb is no longer supported (due to license restrictions). If you need a cheap solution, go with MySql or MsSql Express (altho would prefer MsSql for high traffic sites). Firebird and SqlLite aren't yet supported, but as the datalayer is interface based, you could write your own provider to support those.
I totally agree with that, MS SQL Express is a MS SQL server with a few restrictions, so you get a server that should handle almost anything you throw at it, and if your site is really big and you run into the max. 2GB database restriction (is it 4 these days?), you can probably afford getting a full-blown MS SQL license, and you can take the database from the Express version and restore it on another MS SQL server without having to do much work.
As it's free, and the management tools comes in a free version too, you can install it where ever you need to (developers desktop, dev server, staging server, live server etc etc.) and it integrates perfectly with Visual Studio too.
Which looks like a decent way to do embedded if I decide I do want to do that.
I installed my first Umbraco test which I am playing with now under mySQL, just tried to install the uForum Package and it only works with SQL Server.....
So, SQL Server is the way of the future for me it looks like....best and most compatible solution.
I'm Pretty sure that MS SQL Express is a 4GB limit now since 2008 to allow for unicode, but don't quote me on that.
Choosing a Database
Hello there,
I am evaluating Umbraco (I noob) and read that it supports multiple databases. My preference is to use an embeddable DB just because it's easier. As such I was considering using VistaDB for all our sites.
I was wondering if anyone could tell me if this is a bad idea? And am I likely to find it difficult to migrate if indeed it does turn out to be a bad idea. (I see a post just now that is about MySQL to MSSQL difficulties :)
Am I delusional thinking embeddable DB would make things easier?
Are there other options that work readily, such as firebird or SQLite?
A penny for your thoughts.
Thank you kindly
Yup, vistadb is no longer supported (due to license restrictions). If you need a cheap solution, go with MySql or MsSql Express (altho would prefer MsSql for high traffic sites). Firebird and SqlLite aren't yet supported, but as the datalayer is interface based, you could write your own provider to support those.
Honestly, I'd go with either MsSql(Express)
Cheers,
/Dirk
I totally agree with that, MS SQL Express is a MS SQL server with a few restrictions, so you get a server that should handle almost anything you throw at it, and if your site is really big and you run into the max. 2GB database restriction (is it 4 these days?), you can probably afford getting a full-blown MS SQL license, and you can take the database from the Express version and restore it on another MS SQL server without having to do much work.
As it's free, and the management tools comes in a free version too, you can install it where ever you need to (developers desktop, dev server, staging server, live server etc etc.) and it integrates perfectly with Visual Studio too.
regards,
Steen
Thanks Guys,
It's a shame about vistaDB, that would have been nice :(
I have trawled the forum and found this;
http://our.umbraco.org/wiki/install-and-setup/using-umbraco-with-embeded-sql-database-(sqlexpress-user-instance)
Which looks like a decent way to do embedded if I decide I do want to do that.
I installed my first Umbraco test which I am playing with now under mySQL, just tried to install the uForum Package and it only works with SQL Server.....
So, SQL Server is the way of the future for me it looks like....best and most compatible solution.
I'm Pretty sure that MS SQL Express is a 4GB limit now since 2008 to allow for unicode, but don't quote me on that.
Umbraco looking really good so far :)
is working on a reply...