Click here to Skip to main content
Click here to Skip to main content

SQL Server to SQL Server Compact Edition Database Copy Utility

, 26 Jun 2008
Rate this:
Please Sign up or sign in to vote.
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases

UPDATE

Please download the latest version of this tool from JohnnyCantCode.com. I have updated this utility based on some feedback from users.

I added the ability to select the schema you wish to copy. For most databases, this will simply be "dbo".

I fixed a bug where the application did not recognize a valid version of "System.Data.SqlServerCe.dll".

Introduction

This utility will copy the schema and data from a normal SQL Server 2000/2005 database and export it to a SQL Server Compact Edition database. The tool supports version 3.1 or 3.5 of SQL Server Compact Edition.

Background

I was working on a mobile application and needed an easy way to manage the table relationships and indexes without having to resort to scripting. I was familiar with using SQL Server Management Studio so I decided that I would write a utility that converted a normal SQL Server database to a mobile database. This way, I could continue using the tool I normally use to create and maintain my databases.

Using the Code

Feel free to take a look at the code and offer your most gracious comments. The application uses a wizard to walk you through converting a database. I have also included a normal WINFORM that also does the conversion, but I stopped development on this in lieu of the wizard, so the form is incomplete. I will be maintaining this code and writing more about it on my blog at www.JohnnyCantCode.com. You can find the original post here.

Points of Interest

This utility will copy Indexes, Primary Keys, Foreign Keys, Table structure and data. SQL Server Compact Edition does not have support for Views, Triggers nor Stored Procedures, therefore this utility does not copy these.

History

  • 1.0 Initial release

License

This article, along with any associated source code and files, is licensed under The BSD License

Share

About the Author

johnnycantcode
Software Developer (Senior) Gologic Tech LLC.
United States United States
I work as an independent software architect and senior developer. I have worked on many large enterprise projects as well as small single user applications.

Comments and Discussions

 
Question.Exe PinmemberMember 1028672113-May-14 2:09 
SuggestionNVarCharMAX support PinprofessionalMassood Khaari5-Nov-13 23:23 
Questionprovide .exe file for this project also PinmemberMember 942577126-Jul-13 8:11 
GeneralGreat tool - after some manual changes :-) Pinmemberdolbysys18-Feb-13 21:16 
GeneralRe: Great tool - after some manual changes :-) Pinmemberpmiossec27-Feb-13 12:45 
GeneralRe: Great tool - after some manual changes :-) Pinmemberronan_mc25-Apr-13 13:07 
GeneralRe: Great tool - after some manual changes :-) Pinmemberpmiossec28-Apr-13 1:43 
Questiongeht nicht! PinmemberMember 250914025-Jan-13 4:56 
AnswerRe: geht nicht! Pinmemberdolbysys18-Feb-13 21:20 
QuestionMdf----_> sdf and sdf ----> mdf Pinmembercjgallardo9629-Oct-12 3:03 
Questionasm.GetType("System.Data.SqlServerCe.SqlCeEngine"); returns null Pinmemberbradut15-Oct-12 11:25 
AnswerRe: asm.GetType("System.Data.SqlServerCe.SqlCeEngine"); returns null PinmemberJeff Wharton2-Jan-13 18:01 
QuestionMy vote of 5 PinmemberSPI24-Aug-12 7:20 
GeneralMy vote of 5 PinmemberBig D27-Apr-12 9:40 
GeneralMy vote of 5 Pinmembermanoj kumar choubey17-Apr-12 2:21 
GeneralMy vote of 5 Pinmemberfootnote9-Sep-11 8:28 
QuestionIs there anyone able to make it work with SQL Server 2008 R2? PinmemberEhsan.thabit21-Jun-11 8:14 
GeneralSupport for Compact edition v3.5 sp2 Pinmemberjcgk_7713-Apr-11 2:32 
GeneralRe: Support for Compact edition v3.5 sp2 PinmemberMember 849633121-Mar-12 9:40 
QuestionJohnny Can't Code? PinmemberMember 78058094-Apr-11 5:43 
Generalgetting error just-in-time (JIT) debugging instead of this dialog box Pinmemberpsnlakshmi30-Oct-10 1:40 
GeneralBad Image Format Exception Pinmemberi_lonsdale@hotmail.com15-Oct-10 22:43 
Generalproblem with varbinary Pinmemberpgarbo17-Aug-10 5:05 
GeneralThanks PinmemberUros Calakovic8-Aug-10 2:00 
QuestionException where Copying Database PinmemberEdgarVegaD14-Jan-10 4:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140827.1 | Last Updated 26 Jun 2008
Article Copyright 2008 by johnnycantcode
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid