SQL 2000 vs SQL 2008 Express

Report · Feb 03, 2009

SQL 2000 vs SQL 2008 Express

We currently use SQL 2000 and we pay for that service.

I was wondering if We'd be better off going to SQL 2008 Express which is
free?

Report · Feb 03, 2009

Did a little more looking into this and I found a few limitations -

System Requirements

* Supported Operating Systems: Windows Server 2003 Service Pack 2,
Windows Server 2008, Windows Vista, Windows XP Service Pack 2
* Physical Limitations: 1 CPU, 1 GB Memory, 4 GB of user data per
database

http://www.microsoft.com/express/sql/download/

Report · Feb 04, 2009

Art wrote:
> Did a little more looking into this and I found a few limitations -
>
>
> System Requirements
>
> * Supported Operating Systems: Windows Server 2003 Service Pack 2,
> Windows Server 2008, Windows Vista, Windows XP Service Pack 2
> * Physical Limitations: 1 CPU, 1 GB Memory, 4 GB of user data per
> database
>
> http://www.microsoft.com/express/sql/download/

I guess it depends on what your doing with it. 2008 is way more advanced
than 2000, it can do all sorts of funky stuff that was very hard to do
on 2000. I am still on 2000, it does its job for my needs. But one day I
will bite the bullet and upgrade. One area thats much better is full
text indexing, the ability to do searches like Google, something very
hard to do with 2000.

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html

Report · Feb 04, 2009

>
> I guess it depends on what your doing with it. 2008 is way more advanced
> than 2000, it can do all sorts of funky stuff that was very hard to do
> on 2000. I am still on 2000, it does its job for my needs. But one day I
> will bite the bullet and upgrade. One area thats much better is full
> text indexing, the ability to do searches like Google, something very
> hard to do with 2000.
>
> Dooza

As we've discussed on other threads, the companies that are writing
extensions (that I am familiar with) are moving toward PHP. Windows, on
the other hand, is pushing people into .NET but companies like Adobe are
pushing back by not supporting .NET.

Fortunately, on my 2008 server, I can run either .NET, COLD FUSION, PHP
or ASP so I'm OK for a while; I still have choices.

So I think I'm OK moving to SQL express. I might have too much data to
use Express; there's a 4 gig max per user limitation.

Report · Feb 04, 2009

Art wrote:
>
>>
>> I guess it depends on what your doing with it. 2008 is way more
>> advanced than 2000, it can do all sorts of funky stuff that was very
>> hard to do on 2000. I am still on 2000, it does its job for my needs.
>> But one day I will bite the bullet and upgrade. One area thats much
>> better is full text indexing, the ability to do searches like Google,
>> something very hard to do with 2000.
>>
>> Dooza
>
> As we've discussed on other threads, the companies that are writing
> extensions (that I am familiar with) are moving toward PHP. Windows, on
> the other hand, is pushing people into .NET but companies like Adobe are
> pushing back by not supporting .NET.
>
> Fortunately, on my 2008 server, I can run either .NET, COLD FUSION, PHP
> or ASP so I'm OK for a while; I still have choices.

You can hand code PHP to work with MSSQL, and maybe CS5 will have a
server model for PHP and MSSQL, but MySQL works just as well on Windows
as Unix, so you have lots of options still.

> So I think I'm OK moving to SQL express. I might have too much data to
> use Express; there's a 4 gig max per user limitation.

Express really is meant to be a development platform, 4Gb is a lot, but
it really depends on your requirements. I have seen database's grow very
quickly well beyond that, and when it does you want it to run on more
than 1 processor with more than 1Gb memory.

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html

Report · Feb 12, 2009

OK, so now I've gotten word that I have a free 2008 (Full Version)
available to me with my service.

My choice has been made for me.

However, I've tried to install MS SQL 2008 Express for my development
server but it won't install.

It runs a check and the check fails with one of the

"Rule 'Consistency validation for SQL Server registry keys' failed"

One of the solutions is below but I've checked the registry and it's not
all that obvious what to delete. I've had three versions on my system at
one time or the other so I'm not exactly sure which to delete.

----------------SOLUTION?

1) Stop ALL SQL services - Control Panel - Administrative Tools -
Services - Right Click - Stop

2) Double click each Service and note the "Service Name:xxx"

3) From the Command line (Start - Run - CMD) type: sc delete xxx (enter
the Service Name from above) Example: sc delete MSSQLSERVER - Do this
for each SQL Service

4) Control Panel - Add/Remove Programs - Select and Remove all Microsoft
SQL Server programs

5) From REGEDIT (Start - Run - REGEDIT) Back up your Registry Editor
(Highlight My Computer - File - Export - Save)

6) From REGEDIT go to folders: HKEY_LOCAL_MACHINE/ SOFTWARE/MICROSOFT
then right click ALL Microsoft SQL folders and select DELETE

7) From Windows Explorer go to Program Files then right click all
Microsoft SQL folders and select DELETE

8) ***THIS STEP IS OPTIONAL - I SKIPPED THIS STEP AND SQL 2008 Express
Installed OK***

Run the Microsoft Cleanup Utility - remove all SQL programs

Report · Feb 13, 2009

Art wrote:
> 8) ***THIS STEP IS OPTIONAL - I SKIPPED THIS STEP AND SQL 2008 Express
> Installed OK***

So you have it installed now?

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html

Report · Feb 16, 2009

> So you have it installed now?
>
> Dooza

Yes SQL server 2008 is installed and working. It's different but I'm
starting to warm to it.

On a slightly different topic that we've engaged in.

In my attempt to warm up to PHP, I needed to setup an environment to run
it. I succeeded at that too. I'm building a simple shopping cart with
WebAssist for a friend and I got it going just the way I wanted it to go
so I'm feeling pretty good about this right now.

FYI, on my Vista system at home, I installed IIS7 and found a great
tutorial on how to integrate PHP into IIS server. So now, when I have a
site in Dreamweaver, I can use either PHP or IIS/SQL Server Express 09
with mySQL as a test server.

For a FANTASTIC guide to installing SQL IIS PHP MYSQL on a Vista system,
go to the link below.

http://maximumpcguides.com/windows-vista/how-to-create-a-windows-vista-iis7-mysql-php-web-server/

Report · Feb 16, 2009

Art wrote:
>
>> So you have it installed now?
>>
>> Dooza
>
> Yes SQL server 2008 is installed and working. It's different but I'm
> starting to warm to it.

When I first started playing with MSSQL I used to use MS Access to
access the server using a project. To begin with it was fine, but after
a couple of years my SQL skills got better and I now don't use it at
all, just the Studio software that comes with MSSQL.

Its only through constant use that my skills are now being honed, but I
still consider myself a beginner, as I am still on SQL 2000 as thats
what our in house servers use.

> On a slightly different topic that we've engaged in.
>
> In my attempt to warm up to PHP, I needed to setup an environment to run
> it. I succeeded at that too. I'm building a simple shopping cart with
> WebAssist for a friend and I got it going just the way I wanted it to go
> so I'm feeling pretty good about this right now.
>
> FYI, on my Vista system at home, I installed IIS7 and found a great
> tutorial on how to integrate PHP into IIS server. So now, when I have a
> site in Dreamweaver, I can use either PHP or IIS/SQL Server Express 09
> with mySQL as a test server.
>
> For a FANTASTIC guide to installing SQL IIS PHP MYSQL on a Vista system,
> go to the link below.
>
> http://maximumpcguides.com/windows-vista/how-to-create-a-windows-vista-iis7-mysql-php-web-server/

I have bookmarked that for future reading. I am glad you are seeing
light at the end of the ASP tunnel. PHP is the future, so jump aboard
the good ship PHP and see whats on the horizon.

I am diving in learning Javascript first, I also see AJAX as an
important part of the future, so want to get a good foundation in that
before moving on to PHP.

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html

Report · Feb 16, 2009

> I am diving in learning Javascript first, I also see AJAX as an
> important part of the future, so want to get a good foundation in that
> before moving on to PHP.
>
> Dooza

I think you have things a bit more under control than I do but perhaps
we are, somewhat, in the same boat.

I've been looking at all the things that can divide up my attention and
there's NEVER a shortage of new acronyms to baffle and amaze me.

There's AJAX, CSS, COM, DOM, OOP, SPRY, FLEX, AIR, YUI, JAVASCRIPT, PHP,
ASP, XML, RSS OR ATOM?, XSLT, DTD, RELAX NG, XPATH, ...DOT, DOT,
DOT...you get the point. And there's no end in sight to it.

I've been looking a little bit at YUI library that was built by Yahoo
but I'm not certain what the shelf life of this or any of them is so I
can't decide if I should jump into that or not. What's best?

Then there's Flex; should I just take the plunge and go with Flex
instead of YUI?

Of course, Javascript is a good start.

What do people recommend?

Report · Feb 17, 2009

Art wrote:
>
>> I am diving in learning Javascript first, I also see AJAX as an
>> important part of the future, so want to get a good foundation in that
>> before moving on to PHP.
>>
>> Dooza
>
> I think you have things a bit more under control than I do but perhaps
> we are, somewhat, in the same boat.
>
> I've been looking at all the things that can divide up my attention and
> there's NEVER a shortage of new acronyms to baffle and amaze me.
>
> There's AJAX, CSS, COM, DOM, OOP, SPRY, FLEX, AIR, YUI, JAVASCRIPT, PHP,
> ASP, XML, RSS OR ATOM?, XSLT, DTD, RELAX NG, XPATH, ...DOT, DOT,
> DOT...you get the point. And there's no end in sight to it.
>
> I've been looking a little bit at YUI library that was built by Yahoo
> but I'm not certain what the shelf life of this or any of them is so I
> can't decide if I should jump into that or not. What's best?
>
> Then there's Flex; should I just take the plunge and go with Flex
> instead of YUI?
>
> Of course, Javascript is a good start.
>
> What do people recommend?

Some of your list come under the same heading, which is most Javascript
based. For instance, AJAX, DOM, Spry and YUI and XPATH are all
Javascript. I know very little about it, so have bought myself Head
First Javascript to get myself on the right path. I am also playing with
Spry for a project, and have got good results from it so far.

XML and RSS and ATOM are all the same kinda thing, and can all be pulled
into the Javascript camp as well, lots of the AJAX stuff used XML, so
its another area to look at.

Then you have PHP and ASP being able to generate XML from your database.
So again its all going back to Javascript.

Now Flex is something else, I think it sits in the AIR/Flash camp, and I
have seen some nifty things built with AIR... but don't honestly know
much about it.

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html