Microsoft SQL 2012 CTP3 - Compatible with XP Pro-SP3?

Posted on 2011-10-19
Last Modified: 2012-05-12
I want to learn some .NET framework stuff and MS-SQL. I found some websites that listed XP-Prof SP3 as a supported O/S. Now after the download I see that it is not. Can someone verify this?

I have just installed .NET 4 and it look like I need Windows Powershell 2.0 and possibly
WinRM 2.0 and BITS 4...all part of Windows Management Framework. Haven't installed this yet
as I was stoped by my non supported O/S.

If that is the case can someone point me to a good path on learning SQL? Here are the requirements:
1. The SQL has to be free
2. My PC is a 64-bit machine running WIN XP-Pro-SP3
3. I'm not opposed to getting a dirty copy of another O/S as the machine
will not connect to the internet, but this is a last resort. I think Win7 SP1 and
Vista SP2 are supported, just wish XP was (or is it?)

What is the best way to go about this?  
Question by:TGarey123
    LVL 2

    Accepted Solution

    SQL 2008 Express and SQL 2005 Express should still work:

    If it's SQL coding, you might check out the documentation on the mySQL site:

    Here's a general SQL tutorial:

    Author Comment

    Which O/S do you prefer Vista or Win7 and why?

     I believe the express versions are
    very limited in features, that 2012 CTP 3 has but I am talking way over my head.
    So I may want to get either Vista or Win7 in order to use 2012-CTP3 which has more
    features. On the other hand I may not need the extra features as a beginner.

    The download site you mention for 2008 R2 has a choice of 2 downloads for 64 bit:

    1. 2008 R2 64-bit
    2. 2008 R2 64-bit database with tools.

    What is the difference? Is the second choice the same as the first but with extra stuff?

    My first project will probably be to catalog my music collection 1300 albums, 200 CD's 100 cassette's,
    and my mp3 collection with 3000 windows folders. I guess I could do this with SQL2008?
    LVL 2

    Expert Comment

    I have both and prefer Windows 7.  It seems to respond faster.

    Which particular features are you considering?   Are you looking at learning to manage SQL or program with it?  

    The tools would include SQL Server Management Studio, and you definitely want that.  That makes life a whole lot easier.

    SQL 2008 Express has 10 GB of allowed space I think.  If you're putting actual mp3's in there, then you might have a chance of using all your space.  If you're just putting references to your MP3's, then you'll need years to run out of space.

    Author Comment

    As I am completely new with SQL I will probably want to manage it first. I will not be placing actual mp3s into the Db, only references. It will be challenging to see if I can find a way to add all the top level mp3 folders (Artist) which in turn contain folders for each (Album) which in turn contain the individual songs.

    1. Can this be easily automated to read into the Db? I realize this may be a loaded question.

    For all my vinal albums. and CD collection I'll  have to enter it all in by hand but can probably easily do that in 10 weeks or so, assuming 100/week (10-20 per day)

    At some point I would probably like to learn to program with SQL as well.

    2. How is this done? Are there tools that leverage .NET 4? Can you shed a little light on programming tools?
    3. I installed NET 4 on my XP PC. Will this be backwards compatible with SQL 2008?

    4. Is Server Management Studio a developers tool or a GUI for SQL or both? Any other useful tools?

    5. Do you think that the free 2012 version is worth my getting and installing Windows 7 for all the features that Express may not have? I honestly do not know the differences between them. Again another loaded question. Just sort of wondering what sort of Db things I will not be able to do with SQL 2008 that I will be able to do with SQL 2012.


    Author Closing Comment

    Sorry for the late reply

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now