meds
Reputation: 22966
Convert SQL Server database to SQL Server CE?
I have a SQL Server database which I can read from, is there a quick way I can turn it into an SQL Server CE database through C# or will I have to read in all the data then output it in SQL Server CE.
Upvotes: 0
Views: 1095
Answers (1)
ErikEJ
Reputation: 41819
You can use my SQL Server Compact scripting API, which will allow you to export a Server database to a script file, and run the resulting file against a SQL Server Compact database from your C# code. http://exportsqlce.codeplex.com/wikipage?title=Scripting%20API%20samples&referringTitle=Documentation
Upvotes: 2
Related Questions
- How to migrate SQL Server CE to SQL Server 2012 Express from C# code
- Easy way to transfer schema from SQL Server database to SQL Server CE database?
- Convert SQL Server CE 4 database to SQL Server 2008 Express without Visual Studio Pro edition
- Migrating from SQL Server CE to SQL Server database
- Converting SQL Server database to local C# database
- Migrating SQL Server 2008 tables to SQL Server CE
- SQL Server 2008 to SQL Server Compact Edition?
- Moving data from SQL Compact to SQL Server 2008
- Converting an SQL Server database to an SQL Server Compact database. And back
- How migrate or transfer SQL Server 2008 Compact Edition Database To Express Edition