Sunday, February 19, 2012

DTS with SQL Express

We have build a conversion for our customers to convert their data from our existing database system to Microsoft SQL. We've tested it with MSDE and SQL Server 2000. We based this conversion off of 183 separate DTS scripts saved as VB 6 files. We then heavily customized them to produce a final EXE in VB 6 that our end-users can run. They answer a few questions and then poof, SQL database. Works great.

Now enter SQL Server and SQL Express 2005. With no support for DTS in Express we expect out VB application will fail to execute. As 80% of our customers are MSDE/SQLExpress level customers, this is a real problem for us.

What are my options here?

When SQL Server 2005 ships, we will simultaneously release a "Backward Compatibility" redist. It will be available on the web and will contain, among other things, the same updated DTS 2000 binaries that are installed with SQL 2005.

|||That is really fantastic news. Thank you.

No comments:

Post a Comment