Overview
The purpose of this utility to to provide a mechanism to copy Microsoft SQL Server databases to a SQL Server Compact Edition database. I developed this tool because I was unable to find a management tool that allowed me to design SQL Server Compact Edition database. SQL Server Management Studio can manage SQL Server Compact Edition 3.1 database files but does not offer a GUI for creating or modifying relationships. Also as far as I can tell you still cannot manage a SQL Server Compact Edition 3.5 database with either SQL Server Management Studio nor Visual Studio. If I am mistaken please let me know.
Screen Shots
you can find more screen shots on this post.
License
BSD License
Download
Download Binary Files (no source code included)
Download Source Files
You can also find this utility at:
Additional Resources
Download SQL Server Compact Desktop Edition v3.5
note: You must have at least version 3.0 or 3.5 of the SQL Server Compact Edition installed.
Update: 5/29/2008
-- Added the ability to select the schema you wish to copy. For most databases this will simply be "dbo".
-- Fixed a bug where the application did not recognize a valid version of "System.Data.SqlServerCe.dll".
If you found this application useful and are so inclined please feel free to make a small donation.
