SideBySide: SQL Enterprise & SQL Express

  • I need to test something for a freelance side gig of mine that would require installing SQL Express. The problem is that I have SQL Enterprise / Developer on both my laptops and my work box.

    If I install SQL Express as a side-by-side install (different directory) does anyone know if it'll screw up my regular SQL install in any way?

    The reasoning behind this is my client might change their webpage from being hardcoded with the data in question to pulling the data from a database, but he can't afford real database fees. Which means SQL Express or MySQL are my only options. So, on to the webpage question.

    How difficult is it to have a website pull from a read-only database? I've never done that kind of connectivity before. And I'm going to have to build a search feature, so I'm thinking Full Text Index except I'm pretty sure that Full Text doesn't come with SQL Express.

    Any thoughts, directions or web/BOL links?

    Thanks in advance!

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Hey Brandie,

    I don't think there are any issues with running Developer and Express side by side.

    Full-Text search comes with the Express with Advanced Services download both in 2005 and 2008. I've never used a read-only database, but it isn't hard to get a web site to be driven from SQL Server. I'm assuming the host will have SQL Server.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply