Command line tool to move your SQL Server Compact database to SQL Server
C#
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
src
.gitignore
LICENSE
README.md

README.md

SqlCeMigrator

Command line tool to move your SQL Server Compact database to SQL Server

Configured via the App.Config file:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <!-- Full path to the local sdf file to migrate from, for example C:\data\test.sdf -->
    <!-- Required -->
    <add key="SqlCeDatabasePath" value=""/>

    <!-- What to migrate: Data only = 0, Schema only = 1, Data & Schema = 2 -->
    <add key="Scope" value="0"/>
    
    <!-- If true, will rename the SQL Compact database file with date stamp -->
    <add key ="RenameSqlCeDatabase" value="true"/>

    <!-- If true, will remove the generated scripts from temp folder -->
    <add key ="RemoveTempScripts" value="false"/>

    <!-- Comma seperated list of SQL Compact tables to ignore during migration -->
    <add key ="SqlCeTablesToIgnore" value="__MigrationHistory"/>

    <!-- Comma seperated list of SQL Compact tables to to be appended to existing tables -->
    <!-- Only applicable if Scope = 0 -->
    <add key ="SqlCeTablesToAppend" value=""/>

    <!-- Comma seperated list of SQL Server tables to clear (DELETE), in that order -->
    <!-- Only applicable if Scope = 0 -->    
    <add key ="SqlServerTablesToClear" value=""/>
    
  </appSettings>
  <connectionStrings>
    <!-- Connection string for SQL Server database to migrate to -->
    <!-- Required -->
    <add name="SqlServer" connectionString="" />
  </connectionStrings>
  <startup> 
      <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
  </startup>
</configuration>

Latest daily build

You can download a .zip file with the latest build of the master branch from AppVeyor