You don't need anything to use SQL Express. install SQL Server Express on your server, don't forget to specify your instance name (like YOURSERVER\SQLEXPRESS) and specify valid authentication informations in the installer.
I don't know about the mdf file but it's interesting.
Actually asp.net should support having a mdf database fil in the app_code folder without having to attach the database file to the SQL server running. I think it's meant to make it easier deploying a site to a server without having remote access or without having somebody to actually create a database on the server for you.
I was hoping the empty umbraco.mdf could be used in the installer (just like VistaDB) and it would be filled with the Umbraco tables after the installation.
Well, it should, but I'm not sure what to write in the Umbraco database installation step. I bet Google can tell you how to write a connect string to that mdf file.
You should ignore (well in fact delete) that file, it wasn't meant to be included in the release. It's part of a prototype for a replacement embedded DB
Edit: Actually it might be for the Sql CE edition, my previous comment may be way off the mark!
I've been trying to use the umbraco.mdf file, but I can't get it working. During "Step 2/5: Database configuration" of the setup you need to enter the connection string. I assume you need the custom connection string in the dropdown to select the umbraco.mdf file? Anyone got an example how to connect to the umbraco.mdf file?
So if we can't use the umbraco.mdf file what is the best alternative to use a database which is also stored in the umbraco folder like VistaDB used to be?
umbraco.mdf in Umbraco 4.5
Hello,
In Umbraco 4.5 there is an umbraco.mdf file. Can this be used for an SQL Express installation (and replacement for VistaDB)?
What do I need to configure if I want to use SQL Express during the Database configuration of the installer?
Jeroen
Hi,
You don't need anything to use SQL Express. install SQL Server Express on your server, don't forget to specify your instance name (like YOURSERVER\SQLEXPRESS) and specify valid authentication informations in the installer.
I don't know about the mdf file but it's interesting.
Hi,
I just took a look at the mdf in VS and it looks empty so I'm not sure what it's for.
Jay
Actually asp.net should support having a mdf database fil in the app_code folder without having to attach the database file to the SQL server running. I think it's meant to make it easier deploying a site to a server without having remote access or without having somebody to actually create a database on the server for you.
http://www.4guysfromrolla.com/articles/110905-1.aspx
I was hoping the empty umbraco.mdf could be used in the installer (just like VistaDB) and it would be filled with the Umbraco tables after the installation.
Well, it should, but I'm not sure what to write in the Umbraco database installation step. I bet Google can tell you how to write a connect string to that mdf file.
You should ignore (well in fact delete) that file, it wasn't meant to be included in the release. It's part of a prototype for a replacement embedded DB
Edit: Actually it might be for the Sql CE edition, my previous comment may be way off the mark!
@slace I just read a bit about the Sql CE editition. This would be great for Umbraco :).
I've been trying to use the umbraco.mdf file, but I can't get it working. During "Step 2/5: Database configuration" of the setup you need to enter the connection string. I assume you need the custom connection string in the dropdown to select the umbraco.mdf file? Anyone got an example how to connect to the umbraco.mdf file?
The umbraco.mdf file should just be ignored/deleted. It's an error in the build script that it's a part of the distro. New version coming next week.
So if we can't use the umbraco.mdf file what is the best alternative to use a database which is also stored in the umbraco folder like VistaDB used to be?
Patience. An alternative is on its way. But right now there's only support for MySQL and MS SQL Express/2005/2008.
Sounds interesting :). How much patience do we need? Are you talking about months or weeks?
In Umbraco 4.5.1 the umbraco.mdf is still available. Shouldn't it have been removed? Any new info on the alternative?
Jeroen
Yes please...the alternative...is there a standalone file database in 4.5.x?
There will be very, very soon. We're testing our implementation of SQL CE 4 internally and it'll hopefully get out in beta next week.
Mucho cool...or caliente...next week (will wait for it then:)
So 4.5.3 beta...or some other...please notify us.
Thanks in advance
is working on a reply...