Sign in Register
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 5908 posts 22603 karma points MVP 4x 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 5908 posts 22603 karma points MVP 4x 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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies