Newbie question - SQL server / development

Question

Newbie question - SQL server / development

sa02000

SSC Enthusiast

Points: 114
More actions
October 15, 2015 at 9:42 am

#301503

I would like to connect to real estate transaction data service (RETS), download data and do some calculations, set up alerts etc.
Is there a free version of SQL server that I can download and use? I already have Visual studio 2015.
Thank you in advance.
Jay

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

You can use either the SQL Server Express Edition which is free. It has several limitations, but for simple use, it should be fine.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Lowell SSC Guru Points: 323547 More actions · Answer 2

sa02000 (10/15/2015)
I would like to connect to real estate transaction data service (RETS), download data and do some calculations, set up alerts etc.
Is there a free version of SQL server that I can download and use? I already have Visual studio 2015.
Thank you in advance.
Jay

also, check your services on your machine ; Visual Studio typically silently installs SQL Server Express;

you may have it and not even be aware of it.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Phil Parkin SSC Guru Points: 247180 More actions · Answer 3

Luis Cazares (10/15/2015)
You can use either the SQL Server Express Edition which is free. It has several limitations, but for simple use, it should be fine.

Where is the OR to match your EITHER, Luis? 🙂

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

Phil Parkin (10/15/2015)
Luis Cazares (10/15/2015)
You can use either the SQL Server Express Edition which is free. It has several limitations, but for simple use, it should be fine.
Where is the OR to match your EITHER, Luis? 🙂

It was on the deleted suggestion on Evaluation or Developer editions, which might not be the correct options. And just to clarify, Developer is not free, but it's almost free. I'm not sure if the license would be adequate for this problem.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

sa02000 SSC Enthusiast Points: 114 More actions · Answer 5

Thank you for quick responses. Does it make a difference if I download 32 vs 64 bit?

Jay

Luis Cazares SSC Guru Points: 183706 More actions · Answer 6

sa02000 (10/15/2015)
Thank you for quick responses. Does it make a difference if I download 32 vs 64 bit?
Jay

Yes, 32-bit has several limitations listed in here: https://msdn.microsoft.com/en-us/library/ms143432(v=sql.120).aspx

However, a 64 bit version won't run on a 32 bit Windows.

The best option is to match the version of the SO.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Jeff Moden SSC Guru Points: 1004646 More actions · Answer 7

Luis Cazares (10/15/2015)
Phil Parkin (10/15/2015)
Luis Cazares (10/15/2015)
You can use either the SQL Server Express Edition which is free. It has several limitations, but for simple use, it should be fine.
Where is the OR to match your EITHER, Luis? 🙂
It was on the deleted suggestion on Evaluation or Developer editions, which might not be the correct options. And just to clarify, Developer is not free, but it's almost free. I'm not sure if the license would be adequate for this problem.

If you have a 64 bit box, use the 64 bit version.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)