This post has been republished via RSS; it originally appeared at: Microsoft Developer Blogs - Feed.In this post, Premier Consultant Tim Omta explains how to migrate from SQL CE to SQL Azure.
I was recently working with a customer that needed to migrate an old web site to Azure. It was an ASP.Net Razr Web Pages site was originally created several years ago using WebMatrix. WebMatix is now deprecated, but it allowed a developer to quickly create a web frontend and database backend. By default, the database was created as a local file database using SQL CE. Part of my job to migrate the site for them was to get the data migrated to an Azure DB instance. After a few web searches and poking around it didn’t seem to be a common question with an easily laid out set of steps, so I documented the approach that allowed me to install an extension and use my favored SQL Server DB interface, SQL Server Management Studio (SSMS). The source for the extension is located in the author’s GitHub site: https://github.com/ErikEJ/SqlCeToolbox
Installing the extension into SSMS 18This is a manual process, but worth it if you have a few databases to convert. Here is the installation process: First, navigate to this page: https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolboxforSSMS
- Click the Download button and save the extension, which is named SSMSToolbox.vsix.
- Copy the vsix file to C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions. That is the default installation directory for SSMS.
- Rename SSMSToolbox.vsix to SSMSToolbox.zip.
- Use an unzip utility or PowerShell’s Expand-Archive command to decompress the zip file.
- There should be a new folder in your Extensions directory named SSMSToolbox. Rename the SSMSToolbox folder to SQLCEToolbox.
- The manual install of the extension is now complete.