Question on SQL 2005 Express

Question on SQL 2005 Express

Post by jhcore » Sun, 29 Jan 2006 00:37:58


We have a commercial VB6 app that uses Access. We want to start using
SQLServer, and I see that Express is 'a free, redistributable version
of SQL Server 2005' (quote from MS) that we could use as an imbedded
database.

However, if we change the app, we will have to provide a conversion
path for our customers.
I saw a post that said that Express did not come with DTS (unlike
MSDE).

Can someone confirm that there is no import tool with Express?

Other ideas on how to migrate data from Access to Express in this
situation?

TIA,
Jim
 
 
 

Question on SQL 2005 Express

Post by Jens » Sun, 29 Jan 2006 06:53:41

If you want to use the old packages you have to install the SQL2k tools
on the machines where the dts packages have to be executed. (use
dtsrun.exe) If you want to use the import/export tool you need to have
a look in the Binn\dts directory of SQLServer for the dtswizard.exe
app.

HTH, jens Suessmeyer.