Email Password Remember me?  Lost your password?

• Download codebase - 399.5 KB
• Download help file - 345.7 KB
• Download installer - 657.25 KB

Introduction

CEQuery is written in C# with the help of Visual Studio 2008 platform. Some of the features of this tool are described below:

• User is able to create CE database. If the schema is provided, the tool is able to create the tables and columns.
• User is able to overview an existing CE database with its table and column structure in tree format.
• User can design a query by dragging and dropping tables and columns from the database tree. The query pane in the tool is able to hold multiple queries provided that only one of those queries is active [As SQL Server CE engine does not support multiple queries in a single statement]. The tool is able to handle multiple query panes in the form of tabs. The query designer of the tool is able to highlight the keywords. The tool is able to handle the execution of user's selected query.
• User can manipulate [Insert/Update/Delete] records in a selected table.
• User is able to generate scripts from a single table or multiple selected tables. [Both for SQL CE or SQL Server]
• User is able to open multiple SQL Server CE files simultaneously.
• User is able to convert a SQL Server database to a SDF file with schema and data.
• User is able to change password of a SQL CE DB. The tool is now capable of handling the database with no password.
• User is able to Create or Delete Table by wizard.
• User is able to Export Query Result.

Background

In one of my projects, I have to use SQL Server CE database rigorously as the application interacts with the local version of SQL Server CE file for displaying and manipulating data. SQL Server CE 3.5 version has been used in the application. The application is built on Visual Studio 2005 platform with the support of .NET Framework 2.0. I was initially faced with some problem for querying the SQL Server CE files. Following are the reasons for creating a separate tool for querying a CE database:

• SQL Server 2005 Management Studio does not support querying SQL Server CE 3.5 or SP1 database for displaying contents and querying data.
• There are no free tools for querying CE database available on the internet.
• The only option to view the content of a CE database file is to install VS 2008 which has built in support for viewing and querying a CE database. But the UI provided for querying a CE database in Visual Studio 2008 is not a user friendly one. We need to type hell lot of things for querying a table. Users who are using SQL Server Management Studio will be very uncomfortable with Visual Studio 2008 for querying CE database.

So to manage the queries for CE database, the concept of writing a new tool comes to mind. As SQL Server CE architecture is completely written in C#, there should not be any problem to write a small new tool in a short time period. The main aspects of the tool are as follows:

• The tool should be able to view the table and column structure in a CE database.
• User should be able to design a query in less time like dragging and dropping table names and column names in the query pane from the DB tree like SQL Server management studio.
• The tool should be able to create a new blank CE database. If a schema file is provided, the tool should be able to create tables and columns in the database.
• The user should manipulate data [like Insert/Update/Delete] in any table from the tool.
• The user should generate a script for individual table as well as the whole database.
• The user should be able to place multiple queries in a single query pane. Also she/he should be able to use multiple query panes.
• The query editor should highlight the keywords in the query so that the user should feel like using SQL Server Management Studio.

Using the Code

A brief description of how to use the article or code has been provided in the help [CEQuery-Help.zip] file attached with this article.

Points of Interest

The following articles were very helpful in terms of learning for me:

• Syntax Highlighting Text box. I took help of the CodeProject article Enabling syntax highlighting in a RichTextBox. I have customized the code as per my requirements.
• IE7 like Tab View in Windows. I have used the following CodeProject article in my application - A tab control similar to IE7's
• SQL CE script generator framework. I took the help of the following blog - Generate Data and Export Data from SQL CE (Compact Edition 3.5). I have customized the framework as per my requirements.

You need to have SQL Server CE 3.5 installed to run the code.

Improvement in the Latest Version

The latest version of CEQuery has some enhancements as well as bug fixes. The suggestions from users have been the keen interest for posting the new release.

Enhancements

• Convert SQL Server database to SQL CE database with schema and data
• Password change and Blank password support for the SQL CE DB
• Generate schema and data script for SQL Server
• Run highlighted code only
• Undo and some extent of Redo functionality in SQL editor
• New: Create/Delete Table
• New: Export Query Result in XML Spreadsheet
• New: Script Generator with flexibility of table selection

Bug Fixes

• Bug 1: Multi-column FKs not supported in generated schema files
• Bug 2: nVarChar field sizes omitted / lost in generated schema files
• Bug 3: Blank passwords not supported when creating new DB file
• Bug 4: Creating new database from schema file is broken after any editing of the schema file (doesn't handle empty lines)
• Bug 5: Datatype Error for varchar

History

• 30^th April, 2009: Updated code base and installer
• 27^th April, 2009: Third release
• 18^th March, 2009: Second release
• 16^th February, 2009: First release 

You must Sign In to use this message board.

Per page 102550

FirstPrevNext

SQL Server 2008 Management Studio does it as well Simon Mourier 2:58 16 Nov '09   Just for you to know that the standard SQL Server 2008 tool does all this also, AFAIK. Of course, your tool is more simple to deploy Sign In·View Thread·PermaLink Re: SQL Server 2008 Management Studio does it as well ray_mayukh 6:58 17 Nov '09   I know tht... Thnx for your comment... But when I have developed this, SQL Server 2008 management studio was not there. Sign In·View Thread·PermaLink Re: SQL Server 2008 Management Studio does it as well Simon Mourier 7:14 17 Nov '09   Well, your article was posted in feb 2009, that's why I commented. Sign In·View Thread·PermaLink Getting 'Requested value 'NO' was not found. pedribe 4:26 6 Oct '09   When exporting from sql2k to CE.. Any ideas? Tx! Sign In·View Thread·PermaLink Re: Getting 'Requested value 'NO' was not found. ray_mayukh 22:00 7 Oct '09   I have tested this functionality with SQL 2005..... Can you try to upgrade your database to SQL 2k5 and try the import again... and check the error still persists..... Thanks Mayukh Sign In·View Thread·PermaLink Unable to download CEQuery-Code evandrix 6:32 5 Oct '09   please reupload? Sign In·View Thread·PermaLink Re: Unable to download CEQuery-Code ray_mayukh 21:37 7 Oct '09   Hi, I am able to download the code from the link with no problem... Can you please retry again??? Thanks Mayukh Sign In·View Thread·PermaLink Converting Sql server express 2005 database to sql server ce Dude from backyard 7:15 30 Aug '09   What would happen to my stored procedures when I convert from sqlserver 2005 express edition? Will they get converted? Thanks Sam Sign In·View Thread·PermaLink Re: Converting Sql server express 2005 database to sql server ce [modified] ray_mayukh 2:04 3 Sep '09   Hi, SQL Server Compact Edition does not support stored procedures, views, or triggers. So these objects will not be conevrted when you are converting SQL Server to SQL Server CE. Only Table and Data will be moved. Let me know if this helps. Thanks Mayukh modified on Friday, September 4, 2009 2:39 AM Sign In·View Thread·PermaLink Unable to load DLL 'sqlceme35.dll' 64 bit frankpearson 12:59 15 Aug '09   An update may be required for people on 64 bit systems for SQL Server to get this project to load at database login. People on 64 bit might run into this. Thought it might help to post link: http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/83970f13-3614-43b8-a454-6d527d9c0815[^] Sign In·View Thread·PermaLink Re: Unable to load DLL 'sqlceme35.dll' 64 bit ray_mayukh 10:30 16 Aug '09   I have written the application in 32 bit system. I have never tried this in a 64 bit machine. Also the installer has been build targetting the 32 bit machine. I will do some analysis on this issue. Thnx a lot for pointing this. Sign In·View Thread·PermaLink That's awsome... monkeylover2 12:26 12 Aug '09   That's awsome...just what i was looking for! Sign In·View Thread·PermaLink Re: That's awsome... ray_mayukh 10:28 16 Aug '09   Thnx a lot sir!!! Sign In·View Thread·PermaLink Thanks you for sharing! MasTooool 21:58 25 Jul '09   Very useful tool ! Sign In·View Thread·PermaLink Re: Thanks you for sharing! ray_mayukh 9:32 27 Jul '09   Thanks a lot!!! Sign In·View Thread·PermaLink Could do SxS CE Install? Stephen Quattlebaum 5:16 1 Jul '09   For our app, we install SQL CE side-by-side with our app rather than running the separate installer, to lessen our installation requirements and footprint on the end-user's machine. (This is a configuration that Microsoft supports, not something strange.) Because of that, we make it a policy to avoid installing SQL CE in the GAC using MS' installer on our machines, to help us avoid accidentally making something depend on it being there. You might consider packaging SQL CE SxS in your installer in the same way. It would make it easier to use this tool in situations like ours. Thanks! Sign In·View Thread·PermaLink Re: Could do SxS CE Install? ray_mayukh 11:12 1 Jul '09   Thanks for the suggestion. I have done that locally. But for publishing the article and reducing the size of upload I have excluded that in the published installer. Thanks. Sign In·View Thread·PermaLink Export Sql Server CE to Sql Server? msdevdude 8:09 2 Jun '09   Will you be adding this kind of functionality? Sign In·View Thread·PermaLink Re: Export Sql Server CE to Sql Server? ray_mayukh 14:30 4 Jun '09   This feature is already there. The script generator can generate script for both schema and data for SQL server. Just run the generated script to migrate CE DB to SQL Server. Sign In·View Thread·PermaLink ASP.NET version ? bobk544 5:12 10 May '09   Hello Ray, how difficult would it be to convert this over so it work work on the WEB? Also Ray do you have an email address on this site? Thanks bk Sign In·View Thread·PermaLink Re: ASP.NET version ? ray_mayukh 20:32 10 May '09   Hi, I have to analysis a bit for this. I will let you know. I dont have any email address on Codeproject. You can contact me at mayukh.ray@gmail.com Thanks Mayukh Sign In·View Thread·PermaLink Change Scripts... ballistikx 9:44 30 Apr '09   Any plans to add the ability to produce a change script for 2 different versions of the same database? This would be very helpful. Otherwise, great job! ~ballistikx Sign In·View Thread·PermaLink Re: Change Scripts... ray_mayukh 20:54 3 May '09   I will try to incorporate in the next release.. Thanks Sign In·View Thread·PermaLink Impressive. Most impressive Guy Stuhlmiller 6:03 24 Apr '09   Just a quick note to say 'thanks'. Sign In·View Thread·PermaLink Re: Impressive. Most impressive ray_mayukh 9:47 24 Apr '09   Thank you very much... Sign In·View Thread·PermaLink

Last Visit: 11:15 21 Nov '09     Last Update: 11:15 21 Nov '09 123 Next »