Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hello All,
I have deployed my umbraco website to my host. Unfortunately it doesnt seem to want to publish my Database.
It is SQL CE that i am using ojn visual studio version of the project. When i publish the site it doesnt take it with it.
What is the best way to ensure it does?
Should i individually publish the database?
Hi James
I think that currently there is an issue with that. Can it perhaps be related to this issue? http://issues.umbraco.org/issue/U4-4621
Have you tried deploying the /app_data/umbraco.sdf file manually rather than using visual studio?
/Jan
Would i need to rebuild the site with a SQL Express database? Rather than CE?
No you should be able to just copy the CE SQL file manually from your dev to the server.
But depending on the site your building it might be a good idea to use a database server.
What would be the difference between copying manually and right clicking the database file and publish?
Is there a difference?
There seems to be a few files that it doesnt copy across from the app_data file. Would copying only the database solve this?
It doesnt work if i right click and publish the database.
Not sure - But seems like there is an issue with publishing the database using visual studio. So trying to do it manually will reveal if it works at all :)
What other files are not included? Maybe you need to copy those manually as well.
Nuget Packages and some of the config files for uMbraco that are sat in that directory.
Uploading the dtabase file didnt work :(
Strange. Does it usually work when you develop it in visual studio with CE and publish it out?
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Publishing Databases
Hello All,
I have deployed my umbraco website to my host. Unfortunately it doesnt seem to want to publish my Database.
It is SQL CE that i am using ojn visual studio version of the project. When i publish the site it doesnt take it with it.
What is the best way to ensure it does?
Should i individually publish the database?
Hi James
I think that currently there is an issue with that. Can it perhaps be related to this issue? http://issues.umbraco.org/issue/U4-4621
Have you tried deploying the /app_data/umbraco.sdf file manually rather than using visual studio?
/Jan
Would i need to rebuild the site with a SQL Express database? Rather than CE?
Hi James
No you should be able to just copy the CE SQL file manually from your dev to the server.
But depending on the site your building it might be a good idea to use a database server.
/Jan
What would be the difference between copying manually and right clicking the database file and publish?
Is there a difference?
There seems to be a few files that it doesnt copy across from the app_data file. Would copying only the database solve this?
It doesnt work if i right click and publish the database.
Hi James
Not sure - But seems like there is an issue with publishing the database using visual studio. So trying to do it manually will reveal if it works at all :)
/Jan
What other files are not included? Maybe you need to copy those manually as well.
/Jan
Nuget Packages and some of the config files for uMbraco that are sat in that directory.
Uploading the dtabase file didnt work :(
Strange. Does it usually work when you develop it in visual studio with CE and publish it out?
is working on a reply...