Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Tony Thompson 18 posts 90 karma points
    May 16, 2017 @ 14:30
    Tony Thompson
    0

    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

    Copy Link
  • Tony Thompson 18 posts 90 karma points
    May 16, 2017 @ 15:20
    Tony Thompson
    1

    My error...

    I needed to set the checkboxes in Database Role Membership in SQL to "dbowner" dbdatawriter" and "db_datareader"

    Copy Link
  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    May 16, 2017 @ 15:23
    Alex Skrypnyk
    100

    Hi Tony

    As I know "dbowner" is enough.

    Alex

    Copy Link
  • Tony Thompson 18 posts 90 karma points
    May 16, 2017 @ 15:30
    Tony Thompson
    1

    You're right Alex ( I just copied permissions from an example database).

    With just ' db_owner ' checked, the app still ran fine.

    Thanks

    Copy Link
  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    May 16, 2017 @ 15:41
    Alex Skrypnyk
    0

    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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft