Install SQL Server Express on an external drive??

  • The reason that I would like to install SQL Server Express on an external hard drive is for portability. I am developing a database that I will be working on in the office and at home. At the current time, I do not have a laptop at the office (and I don't want to use my personal laptop for this project). I need a way to develop and test the database both at home and at the office.

    I was wondering if anyone knows if this crazy idea would work. I am also thinking of doing the same with Visual Studio Express. Since there are no licensing violations to speak of for these software packages, it would seem like this could work.

    Any thoughts?

  • I don't think you could do a SQL Server installation because there are registry keys written into the system, etc...

    What you might be able to do is do an attach/detatch of the database and have SQL Server installed on your home/work machines. Then just keep the MDF and LDF files stored on the portable. Just make sure you detatch the database from the server at the end of each day before you leave.

    It's fairly unorthodox but that rarely stops people. 🙂

  • Think this is a good idea... should work.

    keep us posted.

    "Keep Trying"

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

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