Methods to migrate SQL Database (mdf) to SQL Compact Edition (sdf)

sql-server-2005 migration sql-server-ce
Refracted Paladin picture Refracted Paladin · Aug 6, 2009 · Viewed 12.6k times · Source

I have 4 SQL Server 2005 db's that I want to move to SQL CE. I know I cannot keep the SProcs,Views, and Functions(Differences Between SQL Server Compact and SQL Server) but I would like to keep everything else.

I have tried this app, SQL Server to SQL Server Compact Edition Database Copy but it errors out on me. I have the source and am looking into it but I thought I'd check and make sure I wasn't over complicating the solution to my ACTUAL goal.

Is there a simple, can be one shot, way of converting standard SQL .mdf to SQL CE .sdf?

Right now my best idea is to set up Replication to the SQL CE from the SQL 2005 Standard.

Answer

Danny Varod picture Danny Varod · Apr 28, 2011

http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html

Related questions

SQL Server String or binary data would be truncated

I am involved in a data migration project. I am getting the following error when I try to insert data from one table into another table (SQL Server 2005): Msg 8152, Level 16, State 13, Line 1 String or binary data would be truncated. The …

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More