Monday, December 29, 2008

Using ExportSQLCE from Visual Studio

Using an external tool from Visual Studio is an easy way to make use of command line utilities like ExportSQLCE. In this post I will show how to add ExportSQLCE to your Visual Studio tool set.

Start Visual Studio, and select the Tools menu, External Tools option.

This will bring up this dialog:

image

Click Add to add ExportSQLCE:

image

Click OK, and you now have a new menu option on the Tools menu, called ExportSQLCE.

Try it out:

image

Fill in the sdf file name and the name of the output file, which will be placed in your VS project folder and click OK.

Notice how the output appears in the VS Output window:

image

Technorati Tags: ,

And the cstest.sql file is now available in the project folder (use Show All Files):

image