Convert SQL Server database to SQL Server CE?

Question

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.

Really depends on what your current database has, and uses -- some stuff isn't supported in CE. — OMG Ponies
– OMG Ponies, Commented Apr 5, 2012 at 3:50
so what have you tried? codeproject.com/Articles/25685/… or exportsqlce.codeplex.com — Jeremy Thompson
– Jeremy Thompson, Commented Apr 5, 2012 at 4:12

Maslow · Accepted Answer · 2012-04-06 20:50:16Z

2

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

edited Apr 6, 2012 at 20:50

Maslow

18.8k22 gold badges113 silver badges198 bronze badges

answered Apr 5, 2012 at 7:45

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert SQL Server database to SQL Server CE?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related