2

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?

Improve this question
7
  • 1
    Have you looked into SQLLite?
    – Zoidberg
    Mar 2, 2011 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, 2011 at 13:26
  • 4
    I NEED SQL SERVER!
    – 10.
    Mar 2, 2011 at 13:28
  • 2
    Please don't yell, friend.
    – Matt Ball
    Mar 2, 2011 at 13:30
  • 2
    Am I the only one thinking "I NEED SQL SERVER!" is going to become an instant meme? :-D
    – Massimo
    Mar 2, 2011 at 14:05

5 Answers 5

Reset to default
7

SQL Compact Edition:

Improve this answer
0
4

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

Improve this answer
2

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

Improve this answer
1
  • i will try that, thx
    – 10.
    Mar 2, 2011 at 14:21
1

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.

Improve this answer
0

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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .