SQL Server Compact Edition

January 31, 2007

Be sure to download SQL Server Compact Edition quick, before it changes its name again… 🙂

(ps. I recomend downloading both the run-time and the SDK from the download page. The SDK doesn’t put the DLLs in the default directory of C:\%Program Files%\Microsoft SQL Server Compact Edition\v3.1\ referenced in the docs)

Update: SQL Server Express Studio doesn’t currently support SSCE – but it will with Service Pack 2. You can get the CTP of it here.


Data import / export with SQL Server Express using DTS Wizard

January 31, 2007

There are IMHO two major annoyances with SQL Server Express :
 – No Server Agent
 – No Import / Export function (called Data Transformation Services – DTS in SQL Server 2000)
Missing the Server Agent means you have to make your own backup (or other) scheduling, but luckily DTS is possible – it is just not installed as default with SQL Server Express (SSE). It’s very strange to me why Microsoft did not just include in the standard install so that it was available from SQL Server Studio, but I’ll settle for just being happy that it exists at all!

Check if you already have it by looking for this file: c:\%programfiles%\Microsoft SQL Server\90\DTS\Binn\dtswizard.exe. If you don’t have a ‘DTS’ directory (or even a ’90’ directory) it has not been installed.

Here is how you get it:
 – It is included in the SQL Server Express Edition Toolkit – and only that. It you have installed another version of SSE, it works fine to install this package afterwards without uninstalling the others. Get it here: http://go.microsoft.com/fwlink/?LinkId=65111
– The DTS Wizard is included in the option “Business Intelligence Development Studio” so be sure to select that for install 
– If you have installed another version of SSE, the installer might report that there is nothing to install. Override this by checking the checkbox that displays the version number (in the installer wizard)

After install has finished, the DTS Wizard is available at c:\<programfiles>\Microsoft SQL Server\90\DTS\Binn\dtswizard.exe
you might want to make a shortcut, or even include it on the tools menu of SQL Studio.