Best way to migrate SQL CE 4.0 database to Azure Sql

I have an older database developed in VS2010 that I would like to move to SQL Azure.

I was hoping I could just load the .sdf file into SQL Azure, but couldn't find a way to make this work.

I cannot open the .sdf file in Management Studio 2008 (I get an "Incompatible version of the database"), so a simple way to generate a script is not available.

What would be a quick and easy way to complete this migration?

+4
source share
2 answers

Best use of SQL Server Compact and SQLite Toolbox, this is a Visual Studio add-in

  • Visual Studio ( 2012) >
  • "SQL Server Compact SQLite Toolbox" .

Visual Studio .

  • , .sdf.
  • SQL CE ( SQL CE, , " " ).
  • () SQL Server Compact SQLite Toolbox
  • SQL Server Compact/SQLite Toolbox , .
  • Script > Script SQL Azure
  • Script .sql .

Script SQL Azure Script 50 ( , sqlcmd):

sqlcmd -U user_dbo -P -S cloudserver -d -i c:\dataScript.sql -o c:\azuremigration.txt

+6

SQL Server Compact addin/standalone SQL Azure script script SQL Azure

0

Source: https://habr.com/ru/post/1530093/


All Articles