Ziff Davis Internet
News & Resources for the IT Reseller
NewsReviewsTech AnalysisCommentarySecurityLinux/Unix
My Account |  

SQL Server Express a Mixed Bag for ISVs
By Lisa Vaas

Microsoft Corp.’s decision to boot out its MSDE embedded database in favor of its relatively new SQL Server 2005 Express Edition is getting mixed reviews with ISVs.

While many ISVs are thrilled with Express’ new features and the fact that it’s free, others that are doing good business basing their applications on MSDE are nervous that Microsoft is rocking the boat.


“Most [applications that default install with MSDE (SQL Server Desktop Engine)] can be rehosted to a full-fledged Microsoft SQL Server installation, but these migrations aren’t necessarily advantageous to the IT staff or to the end user,” said Daniel Sydnes, of IT Builders LLC, in an e-mail exchange.

What’s the problem? Many applications already include their own reporting, backup and API features, thus making these Express-delivered new features redundant, Sydnes said. Also, there’s “rarely any benefit in accessing their underlying raw (and often undocumented!) data structures,” he wrote.

Greg Paul, product marketing manager for Ipswitch Inc.’s WhatsUp line of network management tools, said that while Ipswitch will “definitely be looking” at the new features, the ISV won’t want to bring those features into the forefront.

“We’ll try to suppress [those features] as much as possible and do silent install,” he said. “Our goal is to hide a lot of that complexity from the end user.”

For its part, Express Metrix, maker of IT asset management tools, shied away from embedding Express’ new feature set in its latest release set because the ISV didn’t have time to test out the features before shipping.

“For us, we had to step back and make a decision: What do we do about brand-new software being released that we had to add to the testing process?” said Kris Barker, CEO and head of Express Metrix’s development team.

eWEEK.com Special Report: SQL Server 2005

“The challenge for a lot of ISVs is not just do you go ahead with something like this and just start shipping an updated version of MSDE, but do you take advantage of SQL Server 2005 Express functionality that didn’t exist in previous versions?” he said. “That’s a tough call for any vendor. In an environment where you’re just one of a number of database environments, you’re not in a position to dictate what version of SQL a customer will run.”

Even when Express Metrix does move to SQL Server Express, likely in its next version, it will probably continue to stay away from SQL Server Express’ new features, Barker said, just to avoid alienating customers.

“Likely in the next release we will ship with Express, but it probably won’t take advantage of anything specific to that version, just to make sure we’re not pushing people in a direction they don’t want to go,” he said.

Tim Tow, Microsoft’s SQL Server product manager, hastens to reassure ISVs that at least when it comes to silent install, that’s one feature that makes Express the ideal choice for an embedded database.

“[It has] new installation and a new installer,” he said. “But it still has additional support for silent install. It has more options than MSDE. The silent install is hidden installation. The ISV can install and execute it in the background. The ISV doesn’t have to expose the SQL Server install process at all. That simplifies it for ISVs.”

Silent install is important because users only care about the ISV’s application, not whatever application is under the surface, Tow said. In addition, small organizations without a lot of technical support don’t want to deal with multiple install options.

Next Page: ISVs test Express.

1 | 2   next >



Free Hands-On Training Lab
Find out how key features of SBS 2003 can help you open up a new line of revenue. Register now >>

SBS 2003 Sales Reference Card
This handy reference card contains features at a glance, sales objection handling, pricing guidelines & more. Get it now >>

Microsoft Empower for ISVs rewards your big idea with big benefits and support.
Access key development tools at a low cost to help you develop that idea into an innovative application. Learn more >>

Autotask makes your IT business run. Better!
  • Manage your entire business from a single integrated system accessed over the web
  • Track and control service tickets, and efficiently dispatch field service techs
  • Monitor and analyze project profitability by project, customer and type
  • Bill by fixed price, time & materials, block hours or retainers
  • Set up workflow rules and automated notifications
  • Nothing to install. Easy to use. Affordable.
Click here ONLY if you want a personalized demo via the web
(North America only, please)

Attention Microsoft Solution Providers!

Want to gain a competitive edge? Try Microsoft Watch – FREE!

Each week you receive:
  • Microsoft News and Insider Information
  • Expert Analysis
  • Code Names of Upcoming MS Products
  • Year-Ahead Calendar, updated monthly

    Click Here to sign up now for your FREE 14 Day Trial to Microsoft Watch.
  • Add up to $1,200 of value with the new BONUS PACKS.
  • High Performance Storage That Blows Away Competitors.
  • Adaptec Adaptec SATA II RAID Outperforms LSI, Promise, 3Ware
  • Create, manage, and archive all content with EMC
  • Go Pro.Introducing Intel® vPro™ technology.
  • Free on-line courses at Data Center University
  • The Power to Build Great Devices – Windows Embedded
  • Windows gets top EAL 4+ security rating from SAIC.
  • Get the Facts on Linux and Windows Server.
  • Get a FREE Forrester white paper courtesy of Oracle.
  • Free Whitepaper: The future of Identity Management.

  • table of contents
    ISVs Test Express

    •Catalog Publishing
    •Dealer Management
    •Order Configuration
    •Price Management
    •Sales Management

    View All >

    Search the jobs you want & get the info you need – post your resume here today!

    Powered by Dice
    White Boxes
    MS vs. IBM
    Linux in the Channel
    Stay in the Zone
    Put The Channel Insider on your desktop.
    Subscribe to The Channel Insider: Channel News, Reviews, Resources and more.

    Make your selections below:

    Contract Watch

    The Channel Insider Update

    Preferred e-mail format:

    Enter your e-mail:

    view all newsletters >>
    Channel Insider Quick Links
    Ziff Davis Footer Logo