minimun installation

I need to reduce de installation pack of sql server express 2005. how
can i do that?
thanks.AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

I need to reduce de installation pack of sql server express 2005. how
can i do that?

I'm afraid that I don't really understand the question. Do you want remove
compenents from your installation?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog ha escrito:

Quote:

Originally Posted by

AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

I need to reduce de installation pack of sql server express 2005. how
can i do that?

>
I'm afraid that I don't really understand the question. Do you want remove
compenents from your installation?
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

size of SQL Server Express distrubition files is 180 MB, i want to
reduce this size. I need to make the possible smallest distribution.
Thanks for the answer.|||On 24 Aug 2006 03:31:28 -0700, "AKS" <dagato2@.terra.eswrote:

Quote:

Originally Posted by

>
>Erland Sommarskog ha escrito:
>

Quote:

Originally Posted by

>AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

I need to reduce de installation pack of sql server express 2005. how
can i do that?

>>
>I'm afraid that I don't really understand the question. Do you want remove
>compenents from your installation?
>>
>>
>--
>Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>>
>Books Online for SQL Server 2005 at
>http://www.microsoft.com/technet/pr...oads/books.mspx
>Books Online for SQL Server 2000 at
>http://www.microsoft.com/sql/prodin...ions/books.mspx

>
>size of SQL Server Express distrubition files is 180 MB, i want to
>reduce this size. I need to make the possible smallest distribution.
>Thanks for the answer.

These days, if 180 MB was a concern, I would expect to find myself
dealing with either (1) a nickel-and-dime client that wasn't worth
my time anyway, or (2) an embedded system (in which case I would
look into SQL products specifically designed for embedded systems).|||AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

size of SQL Server Express distrubition files is 180 MB, i want to
reduce this size. I need to make the possible smallest distribution.

I'm not into redistribution of SQL Express myself, but I note that the
download file for SQL Express is 55 MB. But you probably have to include
..Net Framework 2.0 as well, which is another 22 MB.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||i know it, but when you extract files with option /x, it will be 180
MB, without .net framework. I need install database with another
application, so i need to reduce 180 MB, is it possible?.

Erland Sommarskog ha escrito:

Quote:

Originally Posted by

AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

size of SQL Server Express distrubition files is 180 MB, i want to
reduce this size. I need to make the possible smallest distribution.

>
I'm not into redistribution of SQL Express myself, but I note that the
download file for SQL Express is 55 MB. But you probably have to include
.Net Framework 2.0 as well, which is another 22 MB.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

i know it, but when you extract files with option /x, it will be 180
MB, without .net framework. I need install database with another
application, so i need to reduce 180 MB, is it possible?.

Why would distribute the whole thing expanded? Is there any reason why
you would not distribute your own setup files of which SQLEXPR.EXE is a
part? If nothing else, just put the thing in a ZIP archive.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||icant do it, i have to customize de sql installation and this can not
be interactive with user( silence installation ). And i have to call
sql setup from other setup. Sql will be part of another aplication.

Erland Sommarskog ha escrito:

Quote:

Originally Posted by

AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

i know it, but when you extract files with option /x, it will be 180
MB, without .net framework. I need install database with another
application, so i need to reduce 180 MB, is it possible?.

>
Why would distribute the whole thing expanded? Is there any reason why
you would not distribute your own setup files of which SQLEXPR.EXE is a
part? If nothing else, just put the thing in a ZIP archive.
>
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

icant do it, i have to customize de sql installation and this can not
be interactive with user( silence installation ). And i have to call
sql setup from other setup. Sql will be part of another aplication.

And that was essentially what I said: integrate your SQLEXPR.EXE in
your setup.

I'm sorry, I can't assist with any details, because I don't work with
Windows Installer (or any other installer). But it is quite clear to
me that there is no need to distribute the SQL Express installation
expanded into 180 MB. If Microsoft can distribute it 54 MB, so can you.

It's possible that you can remove some files from the SQL Express
installation, but I seriously doubt that you can slash it to 54 without
compressing it, one way or another. After all, once you've extracted
the exe-file, right-click and select Add to Zip file. Don't tell me
you cannot that.

You should probably investigate if you can find a forum devoted to
Windows Installer, so you can get some tips on building your setup.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||To beat this dead horse a little more, I looked what it's in the extracted
install file, and while it's possible that you could remove some files
for documentation or tools, there is not much to win. Besides installation
would surely fail.

The two largest file in the pack are mssqlsystemresource.mdf and
sqlerver.exe and together they account for more than the full SQLEXPR.EXE.
And few files are more essential than these two...

So you need to learn how to incorporate SQLEXPR.EXE in your setup.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I think it too. Thanks for all.

Erland Sommarskog ha escrito:

Quote:

Originally Posted by

To beat this dead horse a little more, I looked what it's in the extracted
install file, and while it's possible that you could remove some files
for documentation or tools, there is not much to win. Besides installation
would surely fail.
>
The two largest file in the pack are mssqlsystemresource.mdf and
sqlerver.exe and together they account for more than the full SQLEXPR.EXE.
And few files are more essential than these two...
>
So you need to learn how to incorporate SQLEXPR.EXE in your setup.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

sql

Minimum Setup Requirements for SQL 2005 Replication.

What are the minimum setup requirements to support the following.
2 Remote Laptops running SQL Server 2005 Express databases with the ability
to synchronize with each other. Also they should be able to synch with a
server hosting a SQL Database whci is accessible from 2 other Desktop PCs.
What are the SQL CAL Licensing issues that would apply to this scenario.
Regards
Unfortunately SQL Server Express can only be a subscriber to all types of
replication. All subscriptions must be created through RMO or replication
stored procedures.
Regarding your desktop pc's - If they are running workgroup edition they can
have up to 25 merge subscribers, but 5 transactional subscribers. In regards
to licensing anything which accesses the desktop must have a license, which
can be a CAL or a server per processor license (which will not make a whole
lot of sense).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Stuart Lowe" <StuartLowe@.discussions.microsoft.com> wrote in message
news:6C1471E6-61F1-4BF2-AAA8-16E67A29A967@.microsoft.com...
> What are the minimum setup requirements to support the following.
> 2 Remote Laptops running SQL Server 2005 Express databases with the
> ability
> to synchronize with each other. Also they should be able to synch with a
> server hosting a SQL Database whci is accessible from 2 other Desktop PCs.
> What are the SQL CAL Licensing issues that would apply to this scenario.
> Regards
sql

Minimum Hardware Requirement Warning

Hi all, we have released a shrink-wrapped software package that uses SQL Server Express as it's backend. I am currently tracking down an issue to do with SQL Server Express not installing correctly, and at the end of a lot of investigation I have come to the conclusion that it is a CPU problem.

The CPU is not "PII Compatible" enough for SQL Express. It appears as though the Cache prefetching instructions are the most likely culprit, but I was just wondering why the SQL Server Installer allows the user to continue with only a warning about the minimum hardware requirement not being met?

It seems to me that a lot of time and pain would be saved if the installer just said "Sorry, but you have no hope in hell of running SQL Server... go out and buy yourself a real machine" instead of allowing the user to continue all the way through the install and finally crash out at the final step.

Hey Scott,

Yeah, it turns out that the cache prefetching is required and we're not checking for it up front. I've filed a request to add that check for the next version of the product.

-Jeffrey.

|||Thanks, that would be a great help.|||

Sorry, signed in with the wrong passport.

This will be a great help, thanks.

Migration Tools For 2005 Express

Hi everyone

Does anyone know or has anyone heard of any migration tools which
are/might be available for converting SQL Server 2000 databases to SQL
Server 2005 Express?

I'm guessing it is probably a bit early but it was worth a shot!
Thanks

Dave[posted and mailed, please reply in news]

Bungle (dave@.court-technologies.com) writes:
> Does anyone know or has anyone heard of any migration tools which
> are/might be available for converting SQL Server 2000 databases to SQL
> Server 2005 Express?
> I'm guessing it is probably a bit early but it was worth a shot!

Well, I know of one, which is currently in beta. It's called SQL Server
2005.

You can simply attach your SQL 2000 databases to SQL 2005, and they
will be converted to SQL 2005. The same if you restore a backup from
SQL 2005. They will be left in compatibility mode 80, though.

Will the code run right away on SQL 2005? Well, it depends a little.
If you want to move on to compatibility level 90, there are a few
things to check:

o If you use index/lock hints, they must now be preceeded by WITH:
SELECT * FROM tbl WITH (INDEX = pk_tbl)
There is an exception for one-word hints, though.
o Old-style outer-joins *= may not work. (They do in the current
beta, but I think I saw something that it will change. They are
an abomination, so change them anyway.)
o There might be more, this is what I recall here and now.

Even if you stay on level 80, there are issues to look out for:

o SQL 2000 permitted for some incorrect syntax:
SELECT col FROM tbl ORDER BY crap.col
That is, in ORDER BY you could use non-existing aliases. There
were also some other funny things, that SQL 2005 now traps.
o If you make direct access to metadata in stored procedures
executed by plain users - system tables or INFORMATION_SCHEMA
does not matter - beware that users now by default does not
have access to metadata, if they don't have access to the
object itself.

And then of course, there is always the risk that a query executed
fine, now suddenly takes very long time, because the optimizer finds
another plan.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Migration from SQL Server Enterprise Edition to SQL Express Edition 2005

Hi, I'm trying to import databases in sqlexpress edition 2005 from sql
enterprise edition. Any Idea? thank in advance
Backup and restore. Just be aware of the DB size limit of Express, namely
4GB.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"luca drink" <luca.bevilacqua@.gmail.com> wrote in message
news:1134147824.493604.266210@.g43g2000cwa.googlegr oups.com...
> Hi, I'm trying to import databases in sqlexpress edition 2005 from sql
> enterprise edition. Any Idea? thank in advance
>

Migration from SQL Server Enterprise Edition to SQL Express Edition 2005

Hi, I'm trying to import databases in sqlexpress edition 2005 from sql
enterprise edition. Any Idea? thank in advanceHi
I would expect this to work are you having problems?
John
"luca drink" wrote:
> Hi, I'm trying to import databases in sqlexpress edition 2005 from sql
> enterprise edition. Any Idea? thank in advance
>|||Backup and restore. Just be aware of the DB size limit of Express, namely
4GB.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"luca drink" <luca.bevilacqua@.gmail.com> wrote in message
news:1134147824.493604.266210@.g43g2000cwa.googlegroups.com...
> Hi, I'm trying to import databases in sqlexpress edition 2005 from sql
> enterprise edition. Any Idea? thank in advance
>

Migration from SQL Server Enterprise Edition to SQL Express Edition 2005

Hi, I'm trying to import databases in sqlexpress edition 2005 from sql
enterprise edition. Any Idea? thank in advanceBackup and restore. Just be aware of the DB size limit of Express, namely
4GB.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"luca drink" <luca.bevilacqua@.gmail.com> wrote in message
news:1134147824.493604.266210@.g43g2000cwa.googlegroups.com...
> Hi, I'm trying to import databases in sqlexpress edition 2005 from sql
> enterprise edition. Any Idea? thank in advance
>

Migration from MS Access 2003

Hello,

I'm very new to MS SQL Server; I just downloaded Express 2005 yesterday. I have it up and running; it seems to be working fine.

Now onto business - I need to migrate data from existing MS Access 2003. How, exactly, do I do this? I've tried searching MSDN, TechNet, and here, and while I get results that seem to tell part of the story, I don't seem to get a true "How to" for this task.

Can someone please assist me with this?

Thank you.

Here you go:

http://support.microsoft.com/default.aspx/kb/237980

Buck Woody

Migration from MS Access 2003

Hello,

I'm very new to MS SQL Server; I just downloaded Express 2005 yesterday. I have it up and running; it seems to be working fine.

Now onto business - I need to migrate data from existing MS Access 2003. How, exactly, do I do this? I've tried searching MSDN, TechNet, and here, and while I get results that seem to tell part of the story, I don't seem to get a true "How to" for this task.

Can someone please assist me with this?

Thank you.

Here you go:

http://support.microsoft.com/default.aspx/kb/237980

Buck Woody

Migration Assistant For Access Can''t Find SQL Database?

I've installed SQL 2005 Express Addition which created a default database using Windows Authentication -- MachineName/SQLEXPRES. I want to convert some access databases to sql server in the migration assistant, however, when I try to connect the migration assistant to the default database I can't find the database in the drop down box wizard? I'm perplexed? Please shed some light or point me to some articles that will help. Thanks.

It is not practical to use standard Express to migrate Access so see if you can use the one with Management Studio instead, this will give you control of all the steps. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/

|||

Yes, Management Studio is the one I used. I am able to connect via Management Studio, however, the Migration Assistant can't locate it? Looking for other suggestions? Thanks.

|||

Try the eval good for 6 months, you could buy the developer for under $40 online if you have the ram this can help you move Access if all you have is tables and queries. If you have VBA you may need professional help. I have seen Access migration taking six months or more because it lets users add stuff SQL Server will not accept and it uses limited data types.

http://www.microsoft.com/sql/downloads/trial-software.mspx

|||

I'm not sure I understand what you mean by "default database" in this context. SQL Server does not create any default databases when you install it.

In my use of SSMS I find that the drop down box that show the database name does not actually show the list of databases in the server because it has not actually connected to the server yet, so it can not list the databases. You can either specify a new database to be created or specify an existing database to open once you connect, but you need to type the name of the database, it won't populate the list for you.

Regards,

Mike

Migrating to SQL Server 2000 Standard to 2005 Express

I am working for a small company. We have an in-house web application that
was purely used by internal employees. At the time, it was cheaper to get a
per user license. Now we have application that is open to the public and so
we need to change the licensing mode to per processor mode. Right now, we
have a tight budget, so we are thinking about getting SQL Server 2005
Express. If performance is an issue, we may upgrade to other version later.
Looking at the http://msdn2.microsoft.com/en-us/library/ms143393.aspx, 2000
standard to 2005 express upgrade is not supported. Does that mean that if
I get a copy of backup of 2000 standard database and restore it to 2005
express, it will not work? If the upgrade works, will I able to use Upgrade
Advisor?
ThanksAFAIK, you *should* be able to restore your database to SQL Express.
I'd recommend doing a test migration onto a development server or
workstation and trying it out. You're going to want to migrate, instead
of upgrading, though...
JJ wrote:
> I am working for a small company. We have an in-house web application tha
t
> was purely used by internal employees. At the time, it was cheaper to get
a
> per user license. Now we have application that is open to the public and
so
> we need to change the licensing mode to per processor mode. Right now, we
> have a tight budget, so we are thinking about getting SQL Server 2005
> Express. If performance is an issue, we may upgrade to other version late
r.
> Looking at the http://msdn2.microsoft.com/en-us/library/ms143393.aspx, 200
0
> standard to 2005 express upgrade is not supported. Does that mean that i
f
> I get a copy of backup of 2000 standard database and restore it to 2005
> express, it will not work? If the upgrade works, will I able to use Upgra
de
> Advisor?
> Thanks
>
-Dave Markle
http://www.markleconsulting.com/blog|||The only thing I can think of that would prevent this is a database bigger
than 4GB. There might also be some performance differences because Express
won't use as many system resources as standard.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Dave Markle" <"dma[remove_ZZ]ZZrkle"@.gmail.dot.com> wrote in message
news:OX3yXomSHHA.4744@.TK2MSFTNGP02.phx.gbl...
> AFAIK, you *should* be able to restore your database to SQL Express. I'd
> recommend doing a test migration onto a development server or workstation
> and trying it out. You're going to want to migrate, instead of upgrading,
> though...
> JJ wrote:
>
> --
> -Dave Markle
> http://www.markleconsulting.com/blog

Migrating to SQL Server 2000 Standard to 2005 Express

I am working for a small company. We have an in-house web application that
was purely used by internal employees. At the time, it was cheaper to get a
per user license. Now we have application that is open to the public and so
we need to change the licensing mode to per processor mode. Right now, we
have a tight budget, so we are thinking about getting SQL Server 2005
Express. If performance is an issue, we may upgrade to other version later.
Looking at the http://msdn2.microsoft.com/en-us/library/ms143393.aspx, 2000
standard to 2005 express upgrade is not supported. Does that mean that if
I get a copy of backup of 2000 standard database and restore it to 2005
express, it will not work? If the upgrade works, will I able to use Upgrade
Advisor?
Thanks
AFAIK, you *should* be able to restore your database to SQL Express.
I'd recommend doing a test migration onto a development server or
workstation and trying it out. You're going to want to migrate, instead
of upgrading, though...
JJ wrote:
> I am working for a small company. We have an in-house web application that
> was purely used by internal employees. At the time, it was cheaper to get a
> per user license. Now we have application that is open to the public and so
> we need to change the licensing mode to per processor mode. Right now, we
> have a tight budget, so we are thinking about getting SQL Server 2005
> Express. If performance is an issue, we may upgrade to other version later.
> Looking at the http://msdn2.microsoft.com/en-us/library/ms143393.aspx, 2000
> standard to 2005 express upgrade is not supported. Does that mean that if
> I get a copy of backup of 2000 standard database and restore it to 2005
> express, it will not work? If the upgrade works, will I able to use Upgrade
> Advisor?
> Thanks
>
-Dave Markle
http://www.markleconsulting.com/blog
|||The only thing I can think of that would prevent this is a database bigger
than 4GB. There might also be some performance differences because Express
won't use as many system resources as standard.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Dave Markle" <"dma[remove_ZZ]ZZrkle"@.gmail.dot.com> wrote in message
news:OX3yXomSHHA.4744@.TK2MSFTNGP02.phx.gbl...
> AFAIK, you *should* be able to restore your database to SQL Express. I'd
> recommend doing a test migration onto a development server or workstation
> and trying it out. You're going to want to migrate, instead of upgrading,
> though...
> JJ wrote:
>
> --
> -Dave Markle
> http://www.markleconsulting.com/blog

Migrating to SQL Server 2000 Standard to 2005 Express

I am working for a small company. We have an in-house web application that
was purely used by internal employees. At the time, it was cheaper to get a
per user license. Now we have application that is open to the public and so
we need to change the licensing mode to per processor mode. Right now, we
have a tight budget, so we are thinking about getting SQL Server 2005
Express. If performance is an issue, we may upgrade to other version later.
Looking at the http://msdn2.microsoft.com/en-us/library/ms143393.aspx, 2000
standard to 2005 express upgrade is not supported. Does that mean that if
I get a copy of backup of 2000 standard database and restore it to 2005
express, it will not work? If the upgrade works, will I able to use Upgrade
Advisor?
ThanksAFAIK, you *should* be able to restore your database to SQL Express.
I'd recommend doing a test migration onto a development server or
workstation and trying it out. You're going to want to migrate, instead
of upgrading, though...
JJ wrote:
> I am working for a small company. We have an in-house web application that
> was purely used by internal employees. At the time, it was cheaper to get a
> per user license. Now we have application that is open to the public and so
> we need to change the licensing mode to per processor mode. Right now, we
> have a tight budget, so we are thinking about getting SQL Server 2005
> Express. If performance is an issue, we may upgrade to other version later.
> Looking at the http://msdn2.microsoft.com/en-us/library/ms143393.aspx, 2000
> standard to 2005 express upgrade is not supported. Does that mean that if
> I get a copy of backup of 2000 standard database and restore it to 2005
> express, it will not work? If the upgrade works, will I able to use Upgrade
> Advisor?
> Thanks
>
-Dave Markle
http://www.markleconsulting.com/blog|||The only thing I can think of that would prevent this is a database bigger
than 4GB. There might also be some performance differences because Express
won't use as many system resources as standard.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Dave Markle" <"dma[remove_ZZ]ZZrkle"@.gmail.dot.com> wrote in message
news:OX3yXomSHHA.4744@.TK2MSFTNGP02.phx.gbl...
> AFAIK, you *should* be able to restore your database to SQL Express. I'd
> recommend doing a test migration onto a development server or workstation
> and trying it out. You're going to want to migrate, instead of upgrading,
> though...
> JJ wrote:
>> I am working for a small company. We have an in-house web application
>> that was purely used by internal employees. At the time, it was cheaper
>> to get a per user license. Now we have application that is open to the
>> public and so we need to change the licensing mode to per processor mode.
>> Right now, we have a tight budget, so we are thinking about getting SQL
>> Server 2005 Express. If performance is an issue, we may upgrade to other
>> version later.
>> Looking at the http://msdn2.microsoft.com/en-us/library/ms143393.aspx,
>> 2000 standard to 2005 express upgrade is not supported. Does that mean
>> that if I get a copy of backup of 2000 standard database and restore it
>> to 2005 express, it will not work? If the upgrade works, will I able to
>> use Upgrade Advisor?
>> Thanks
>
> --
> -Dave Markle
> http://www.markleconsulting.com/blog