Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
canguro
Starting Member
2 Posts |
 Posted - 2009-07-27 : 04:41:09
|
| Hello,I am interested in doing some SQL development for personal (home) use, but I definitely need to have the capability to write stored procedures and run them. Both my desktop and laptop have the Vista OS, and for now I am quite happy with that. Also, both my desktop and laptop have the SQL Server 2005 Compact edition pre-installed.To access the power of writing stored procedures and running them, do I need to move to Express? Is it free? If I move to Express should I uninstall Compact Edition first?I hope someone can clear my head of the confusion.Many thanks,Joe |
|
|
RitaBowman
Starting Member
10 Posts |
Posted - 2009-07-27 : 12:28:11
|
| Check out this link http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx. It seems to indicate that you do need Express and it's free. Personally, I would uninstall Compact before installing Express. I've had issues reinstalling over software in the past, and now uninstall first as a matter of course. |
 |
|
|
canguro
Starting Member
2 Posts |
Posted - 2009-07-28 : 03:24:46
|
| Hi Rita,Thank you for your reply. What you say makes sense. I kind of had a feeling that I might have to go with Express, but I couldn't convince myself. I was hoping to contact Microsoft directly by email, but somehow getting thru to them seems convoluted, and after plowing thru a couple of screens I found myself confronted by a possible charge for support.My instinct is also along the same lines as you, since I think it's intuitively cleaner to remove a different version of the same program. I just needed someone to point me in the right direction before uninstalling Compact and possibly losing it.Thanks again.Joe |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-28 : 03:30:37
|
SQL Express and Compact are not really the diff version of same program. Compact is a totally different class for different purposes. What you need is the Express editionThere is a doc "Compare SQL Server 3.5 Compact and SQL Server Express Edition Features" here. http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-07-28 : 03:56:35
|
| And the answer to your other question is yes its Free |
|
|
|
|
|
|
|
|
Confused About Best SQL Server 2005 Choice