Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to install SQL Server, however I have a BIG problem with it. I remember when I tried to install it I got error with MSXML and it was not installed because of MSXML and some other component. Is there any portable version of SQL Server?

share|improve this question

migrated from stackoverflow.com Mar 2 '11 at 13:53

This question came from our site for professional and enthusiast programmers.

1  
Have you looked into SQLLite? –  Zoidberg Mar 2 '11 at 13:25
    
you could use SQL CE or SQL Express, it all depends on what are your needs for SQL? –  K Ivanov Mar 2 '11 at 13:26
2  
I NEED SQL SERVER! –  10. Mar 2 '11 at 13:28
2  
Please don't yell, friend. –  Matt Ball Mar 2 '11 at 13:30
1  
Am I the only one thinking "I NEED SQL SERVER!" is going to become an instant meme? :-D –  Massimo Mar 2 '11 at 14:05

5 Answers 5

There is no such thing as a "portable" version of Sql Server, as provided by Microsoft. There are "light" versions of Sql Server such as Sql Server Compact edition, but any "portable" version would have to be created by you.

By "created by you" I mean:

  • Extracting all the files from the installers
  • Determining how/where they need to be deployed/registered
  • Understanding what configuration needs to be written in lieu of the installer doing so
  • Capturing any dependencies that are non-core-OS (such as MSXML, if the OS being targeted is absent of the required version) and doing all the previous steps for them as well.
  • Putting together a process/script to deploy everything listed above.

In other words, you'd need to write the Sql Server installer.

Find and resolve the issue around MSXML (try http://www.serverfault.com), that's the real way to solve this issue

share|improve this answer

You can fix the MSXML related errors while installing SQL Server 2005 with MSXML_FIX.VBS found here.

share|improve this answer
    
i will try that, thx –  10. Mar 2 '11 at 14:21

It would be quite useful to know which version of Windows are you working with, and which version of SQL Server your application requires.

"Light" versions of SQL Server have been around for a while, starting with MSDE (for SQL Server 7.0 and 2000) and ending with SQL Server Express and/or Compact for more current releases; but no one of them is going to install properly if you have issues with required components such as MSXML, so you really should first look into fixing them.

share|improve this answer

Microsoft SQL Server Compact 4.0 :

Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.