Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-10-19
5
Medium Priority
?
488 Views
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?  
0
Comment
Question by:Link
  • 3
  • 2
5 Comments
 
LVL 2

Accepted Solution

by:
bkieler earned 2000 total points
ID: 36996853
SQL 2008 Express and SQL 2005 Express should still work:
2005: http://www.microsoft.com/download/en/details.aspx?id=21844
2008: http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

If it's SQL coding, you might check out the documentation on the mySQL site:
http://php.net/manual/en/book.mysql.php

Here's a general SQL tutorial: http://www.sql-tutorial.net/.
0
 

Author Comment

by:Link
ID: 36999543
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?
0
 
LVL 2

Expert Comment

by:bkieler
ID: 37000168
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.
0
 

Author Comment

by:Link
ID: 37001511
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.

Thanks
0
 

Author Closing Comment

by:Link
ID: 37141470
Sorry for the late reply
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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.
Screencast - Getting to Know the Pipeline
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

577 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