To use the scripting library, add references to ISqlCeScripting.dll and SqlCeScripting.dll (and optionally SqlCeScripting40.dll for version 4.0 support).
The API exposes 4 repository implementations, DBRepository (for 3.5 SQL Server Compact files), DB4Repository (for SQL Server Compact 4.0 files), SQLiteRepository and ServerDBRepository (for SQL Server 2005 and later databases).
Generate a single table script
using ErikEJ.SqlCeScripting;
....
using (IRepository repository = new DBRepository(@"Data Source=C:\Northwind.sdf"))
{
Generator generator = new Generator(repository, null);
foreach (var tableName in repository.GetAllTableNames())
{
generator.GenerateTableScript(tableName);
}
System.IO.File.WriteAllText(@"C:\script.sqlce", generator.GeneratedScript);
}
Generate data (INSERTs) from all tables script
using ErikEJ.SqlCeScripting;
....
using (IRepository repository = new DBRepository(@"Data Source=C:\Northwind.sdf"))
{
Generator generator = new Generator(repository, null);
foreach (var tableName in repository.GetAllTableNames())
{
generator.GenerateTableContent(tableName, false);
}
System.IO.File.WriteAllText(@"C:\script.sqlce", generator.GeneratedScript);
}
Generate a diff script
using (IRepository sourceRepository = new DBRepository(@"Data Source=C:\data\source.sdf"))
{
var generator = new Generator(sourceRepository);
using (IRepository targetRepository = new DBRepository(@"Data Source=C:\data\target.sdf"))
{
SqlCeDiff.CreateDiffScript(sourceRepository, targetRepository, generator);
//textBox.Text = generator.GeneratedScript;
}
}
More examples here:
Script a database to SQLite
http://erikej.blogspot.dk/2013/03/sql-server-compact-code-snippet-of-week.html
Migrate a SQL Compact database to SQL Server
http://erikej.blogspot.dk/2013/03/sql-server-compact-code-snippet-of-week_8.html
Generate a CREATE TABLE script
http://erikej.blogspot.dk/2013/03/sql-server-compact-code-snippet-of-week_12.html
Script all data in a table
http://erikej.blogspot.dk/2013/05/sql-server-compact-code-snippet-of-week_9.html
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4