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
Hi,
I'm trying to migrate my SDF file over to full SQL using the instructions here:
http://www.geektantra.com/2012/10/umbraco-deployment-exporting-ms-sql-ce-database-to-ms-sql-server-express/
Everything seemed to go OK except I am now seeing the installation screen background image and it won't proceed any further.
If I change the web.config file back to the SDF link it works fine again.
Any tips as to what I'm doing wrong?
Thanks
My error...
I needed to set the checkboxes in Database Role Membership in SQL to "dbowner" dbdatawriter" and "db_datareader"
Hi Tony
As I know "dbowner" is enough.
Alex
You're right Alex ( I just copied permissions from an example database).
With just ' db_owner ' checked, the app still ran fine.
you are welcome, Tony
Glad that you solved this issue!
By the way, easiest way to migrate database from sqlCE to MSSQL is visual studio extension - https://github.com/ErikEJ/SqlCeToolbox
It can migrate a database from one connection string to another in few seconds.
Thanks,
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Exporting MS SQL CE Database to MS SQL Server causes install screen to show
Hi,
I'm trying to migrate my SDF file over to full SQL using the instructions here:
http://www.geektantra.com/2012/10/umbraco-deployment-exporting-ms-sql-ce-database-to-ms-sql-server-express/
Everything seemed to go OK except I am now seeing the installation screen background image and it won't proceed any further.
If I change the web.config file back to the SDF link it works fine again.
Any tips as to what I'm doing wrong?
Thanks
My error...
I needed to set the checkboxes in Database Role Membership in SQL to "dbowner" dbdatawriter" and "db_datareader"
Hi Tony
As I know "dbowner" is enough.
Alex
You're right Alex ( I just copied permissions from an example database).
With just ' db_owner ' checked, the app still ran fine.
Thanks
you are welcome, Tony
Glad that you solved this issue!
By the way, easiest way to migrate database from sqlCE to MSSQL is visual studio extension - https://github.com/ErikEJ/SqlCeToolbox
It can migrate a database from one connection string to another in few seconds.
Thanks,
Alex
is working on a reply...