up vote 2 down vote favorite
share [g+] share [fb]

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?

link|improve this question
1  
Have you looked into SQLLite? – Zoidberg Mar 2 '11 at 13:25
@IAdapter : off topic....perhaps more suited to superuser or serverfault? – Mitch Wheat Mar 2 '11 at 13:25
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
show 3 more comments
feedback

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

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

5 Answers

up vote 7 down vote

SQL Compact Edition:

link|improve this answer
feedback
up vote 3 down vote

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

link|improve this answer
feedback
up vote 2 down vote

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

link|improve this answer
i will try that, thx – 10. Mar 2 '11 at 14:21
feedback
up vote 1 down vote

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.

link|improve this answer
feedback
up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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