CODEWITHSUNDEEP
sql-server-2005migrationsql-server-ce
Refracted Paladin
Refracted Paladin

Reputation: 12216

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

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.

Upvotes: 11

Views: 12737

Answers (4)

Danny Varod
Danny Varod

Reputation: 18069

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

Upvotes: 4

Khaled Abdo
Khaled Abdo

Reputation: 21

Use the SDFViewer utility:

go Tools Menu > From SQL Server

Enough said....

Upvotes: 2

emdadgar2
emdadgar2

Reputation: 840

1.Use SQL Server to SQL Server Compact Edition Database Copy with sqlcompact 3.1 or 3.0 not sql compact 3.5 You can use a virtual machine like sun virtual box, install sql compact 3 or 3.1 on it, and convert your database inside it

2.You can convert to sql compact manually

Upvotes: 3

n8wrl
n8wrl

Reputation: 19765

What if you scripted the objects from 2005 and ran the script in CE? That'd give you the structure of the DB, then you could select/insert?

I haven't tried this, but what about SQL's DB export/import tools in management studio?

Upvotes: -1

Related Questions