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


  • MB 273 posts 936 karma points
    Jan 27, 2020 @ 16:00
    MB
    0

    Migrating SDF to SQL

    Hi guys,

    I opened my SDF file using CompactViewer and exported schema + data into 1 sql file.

    1. I opened SQL Server Management and connected to the server
    2. I right clicked the database and choosed New Query
    3. I inserted the entire SQL query exported from CompactViewer
    4. I get these errors and a lot of them:
        Msg 102, Level 15, State 1, Line 1218
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Line 1218
Incorrect syntax near 'ACTION'.
Msg 102, Level 15, State 1, Line 1233
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Line 1233
Incorrect syntax near 'ACTION'.

    enter image description here

    I am NOT a SQL shark so I'm pretty stranded here. Is this a common issue? I would like to switch from SDF to SQL.

    The entire SQL file is 61MB.

    Copy Link
  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    Jan 27, 2020 @ 16:07
    Alex Skrypnyk
    1

    Hi MBE

    I use visual studio extension called "SQLite/SQL Server Compact Toolbox".

    It helps to migrate databases from different sources without using SQL queries.

    Thanks,

    Alex

    Copy Link
  • MB 273 posts 936 karma points
    Jan 27, 2020 @ 17:11
    MB
    0

    Hi Alex,

    Thanks for your reply!

    I downloaded the plugin and gave it a try. I think it might be working but something is preventing me due to permissions.

    My SQL is hosted at UnoEuro. I connected to the Database and right clicking my SDF file selecting "Migrate to SQL Server".

    I select the database at UnoEuro but I get the following error:

    CREATE Table permission denied in database 'master'

    enter image description here

    I assume the issue is related to UnoEuro and not so much local permission problems?

    Copy Link
  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    Jan 27, 2020 @ 22:12
    Alex Skrypnyk
    1

    It looks like, some permissions are not allowed for your sql user.

    Copy Link
  • Matthew Wise 271 posts 1373 karma points MVP 5x c-trib
    Jan 27, 2020 @ 18:02
    Matthew Wise
    2

    I have done this using the package uSync and uSync content.

    Do a full export and then do a fresh umbraco install on SQL, followed by a full import with uSync

    Copy Link
  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    Jan 27, 2020 @ 22:15
    Alex Skrypnyk
    0

    Hey Matthew :)

    Thanks for a great idea of how to move the content between apps. uSync is amazing, isn't it?

    Alex

    Copy Link
  • MB 273 posts 936 karma points
    Feb 05, 2020 @ 16:31
    MB
    0

    Thanks for the tip Matthew!

    It actually did work but unfortunately, it doesn't export user data so my admin doesn't exist and my usergroups are empty.

    Copy Link
  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    Feb 05, 2020 @ 22:33
    Alex Skrypnyk
    0

    Hi MBE

    uSync doesn't move members, it's officially.

    uSync will read/write:

    Document types

    Media Types

    Data Types

    Macros

    Member Types

    Templates

    Dictionary Items (v7)

    Languages (v7)

    Stylesheets (no longer stored in the db in umbraco 7.3+)

    Copy Link
  • Alex Skrypnyk 6163 posts 24143 karma points MVP 8x admin c-trib
    Feb 05, 2020 @ 22:34
    Alex Skrypnyk
    0

    you can move members with sql script

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft