Help! SQL Express, Standard Or Enterprise? Or Access?

Oct 30, 2006

I'm not a developer and would like your input to compare against what a sales rep is telling me.

I'm managing a small web project that will have a database with a max of 20,000 records with less than 50 field each. It will be hit by anything from 200 to 500 people in a day (max) via Internet connection from all over with all sorts of speed.

The users will select less than 50 filters to obtain the results of the info they are looking for among the 20000 records. Most users will only choose less than 10 filters per search.

That's all that the database will do...seems to me enterprise is way too much, but since I'm not expert, need one of you to help with your input.

Thanks very much!

View 5 Replies


ADVERTISEMENT

Enterprise To Standard

Nov 20, 2002

Does anyone know if it is possible to go from the Enterprise edition of SQL, back to Standard?

In other words, Enterprise Edition is installed, but what we really want is Standard. Is there any way around this, other than uninstalling and reinstalling SQL?

I assume not, but thought I would check...

View 1 Replies View Related

Enterprise To Standard

Nov 12, 2006

dear all,

if one has purchased enterprise edition of sql server, could he install the standard version instead of the enterprise one without violating software license?

regards

View 1 Replies View Related

SQL STANDARD/ ENTERPRISE

Dec 27, 2007

How are you, I was wondering if I could uninstall and reintall sql server standard and upgrade to enterprise edition.

What i mean..

We have 10 computers running sql server standard. We want to upgrade them to enterprise edition bc there are another 10 machines with enterprise.

Would we have to uninstall standard edition before installing enterprise.
Or could we just install enterprise edition over standard

Has anyone done this? Compatibilty issue?? We are doing it remotly as well, some machines in NC, some in Vegas, some in Cali. So all will be done through RDC.


any and all help will be great

Thanks

View 3 Replies View Related

SQL 7 Standard To SQL 7 Enterprise Edition

Oct 3, 2001

Is it possible to "convert" from SQL 7.0 Standard Edition to SQL 7.0 Enterprise Edition?
Thanks.

View 4 Replies View Related

Best Way To Go From Standard To Enterprise Edition?

Nov 21, 2002

What's the best/easiest method to upgrade from Standard Edition to Enterprise Edition and still keep the databases in tact?

My thoughts were to:
1)Backup databases
2)Detach User Databases
3)Uninstall Standard
4)Install Enterprise
5)Restore Master and msdb
6)Reattach the User Databases

Comments?

View 1 Replies View Related

How To Know If It Is Standard Or Enterprise Edition?

Aug 7, 2003

How to know if it is standard or enterprise edition that a remote sql server is?

View 7 Replies View Related

Standard Vs Enterprise Edition

Feb 19, 2004

Recently, I worked on installing SQL Server 2000 into a clustered environement. I installed the Standard edition, tested it, and everything works fine. However, in reading some information on Enterprise Edition from Microsoft, I see where it says to install Enterprise Edition when using a clustered, or failover, environement. Can anyone give me a layman's explanation as to why this is? Everything is functioning just fine with the Standard Edition installed.

I really don't want to re-install if I don't have to.

Thanks in advance.

View 2 Replies View Related

Sql 6.5 - Enterprise Or Standard Edition

Nov 29, 2000

How can I find out if a sql 6.5 server was loaded with the Standard or Enterprise version of sql server?

thanks

View 2 Replies View Related

Enterprise V Standard SQL 2K Edition

Jan 9, 2002

Does any one know if the Standard or Enterprise version of SQL Server 2K allows Maintenance Procedures like "DBCC CHECKDB REPAIR_REBUILD" to execute with users logged in, without the requirment of single user mode on the Database?

Any help would appreciated.

View 2 Replies View Related

Replication Standard Or Enterprise

Jul 17, 2007

In setting up replication between databases do both sql installations have to be enterprise or can it be done with both sql server standard edition.


thanks,

View 7 Replies View Related

SQL Server Standard Vs. Enterprise

Apr 30, 2004

I'm setting up a new system and want to do a cluster. We have Win2k3 Enterprise already. My question is do you have to have enterprise edition of SQL2K to do clustering w/ win2k3?

View 7 Replies View Related

Sql Server Standard Vs Enterprise

May 16, 2006

Hello,

I have a question.
I want to migrate from mySql to Sql Server, and I should decide which version will I use.
The problem is that I need partitioning, and it is included only in the Enterprise version. But the Enterprise version costs 5 times more than the standard and the workgroup version.
Is it worth to spend so much money only for the partitioning?
Also, maybe I am wrong, and the partitioning is also included in the Standard version?

Thanks,
Edi.

View 15 Replies View Related

Is MS SQL Enterprise Or Standard Edition?

Mar 18, 2007

Mustrum Ridcully writes "Sitting here at work trying to figure a way to find wether SQL server is Enterprise or Standard edition. Submitting this question won't probably help much as I have to deliver report in about 30min. Nevertheless, somebody might benefit from this information in the future.

Regards"

View 3 Replies View Related

SQL Enterprise Eval =&> SQL Standard

May 2, 2007

We've got a SQL 2000 Server running the Enterprise 120-day trial.Normally you can retain the information by upgrading it to the full-blown version of Enterprise edition. However, we have decided to gowith the Standard version instead. Will I need to BACKUP the data anddo a complete install then RESTORE or can I "upgrade" it to Standard?Has anybody actually done this?

View 1 Replies View Related

How Do I Know If I Have Enterprise Or Standard On My Machine?

Nov 29, 2006

I go to help>About and it just says SQL Server 2005

Microsoft SQL Server Management Studio Version 9.00.1399.00

View 7 Replies View Related

SQL 2005 Enterprise And Standard

Apr 11, 2007



I am running SQL 2005 Enterprise Edition on a 2 node cluster. Can I install SQL 2005 Standard edition on the same cluster?

View 2 Replies View Related

Standard Vs. Enterprise Editions

May 28, 2008

hello all,
has anyone attempted (or succesfully implemented) a solution using Standard Edition, **as a replacement** for Enterprise Edition, in a multi-partition environment?

I believe one can use external partitions in SSAS to draw data from SQL Server, I'm not sure if that's a feature that works with the Standard Ed. of SSAS.

Namely, I'd like to see if I can use a setup of 4 installs of SQL Server, Standard Edition, and use that as a feed data into SSAS Standard Edition, and save some money on licensing (probably at a cost of increased maintenance). I know that the Enterprise version also has some enhanced analytics functions and other cool stuff so that'll be lost as well, with this potential setup.

My inclination is that to use external/Remote Partitions one would still need to use the Enterprise Edition, making this the only choice, for large cube builds -- but I may be wrong.

thanks much for any feedback,
Cos

View 3 Replies View Related

Effects Of Restoring SQL Enterprise To SQL Standard

Jul 17, 2002

I need to know if it is possible, and if so, the effects of restoring databases from a server running SQL Enterprise Edition to a server running SQL Standard Edition. There will be an application database as well as the "master" database to be restored.

Any suggestions?

View 1 Replies View Related

Upgrade Standard Edition To Enterprise

Feb 13, 2003

Hi,
right now I'm using SQL2000 Std Edition. Our new application requires an OLAP Svcs to be installed. As I found in SQLBooksOnline HTTP access to OLAP cubes is available only in OLAPSvsc Enterprise Edition. Do I have to upgrade SQL Std Edition as well or it is possible to run OLAP Enterprise on top of SQL2000 Standard? Does anyone of you know about step-by-step guide how to move SQL2K Std to SQL Ent?

Thanks in advance for help

Regards
Karel

View 11 Replies View Related

Migrating From Standard To Enterprise Edition

Sep 19, 2004

Hello everyone,
My company is thinking of migrating from SQL Standard to Enterprise Edition. I am the dba--but not much experience in SQL. Not sure what I need to do if this projec falls onto my shoulder. Any advise will be very much appreciated. Thanks!!!

View 3 Replies View Related

SQL 2000 Enterprise Or SQL Standard 2003

Nov 25, 2004

I need to max out on RAM somewhere around 3 to 4 GB and I am using SQL 2000. Standard SQL 2000 RAM is limited to 2 GB. SQL Enterprise 2000 is maxed out around 32GB and it cost is $1K. I need to purchase a Windows based SQL package but I can't find the specs on SQL Standard 2003 (which is ~$700) to compare.
What is the Max RAM for SQL Standard 2003?
Which is a better purchase relative to RAM?
What O/S is recommended as this also limits RAM usage?

View 1 Replies View Related

Question About Standard / Enterprise Editions

Jan 14, 2008

Can either of these be installed on a laptop?

Thanks,

Jaybee.

View 3 Replies View Related

Upgrade From SQL 2005 Standard To Enterprise

Aug 31, 2006

I'm installing SQL 2005 on a cluster. Currently we do not need the features of enterprise edition, but we may need them in the future. Can you upgrade Standard edition to Enterprise edition (on a cluster)?

View 3 Replies View Related

SQL 2005 Standard To Enterprise Upgrade

Dec 2, 2006

As I found on http://msdn2.microsoft.com/en-us/library/ms143393.aspx its only possible on 32 Bit subsystems and not on native 64 bit - is this true?

In addition is it a complete installations which remains the current configuration? (i guess this because we have to apply all service packs again)?

and at least - is a license upgarde possible or do we have to buy a complete new licence?

Thanks HANNES

View 5 Replies View Related

Mirroring Between Standard And Enterprise Editions...

Sep 15, 2006

Hi All,

We are going to use database mirroring and database snapshots for reporting. The principal server runs SQL Server 2005 Standard Edition and mirror (reporting) runs SQL Server 2005 Enterprise Edition (64-bit). I failed to setup database mirroring trough GUI using SQL Server Management Studio and got this error:
This mirroring configuration is not supported. Because the principal server instance, <server_name>, is Standard Edition, the mirror server instance must also be Standard Edition.
But when I use T-SQL commands I was able to setup database mirroring and it works OK so far.
SQL BOL says that one of requirements for database mirroring is to use the same SQL Server editions but I am wondering if it works trough T-SQL why MS mention it in the requirements list, also is totally unsupported by MS?

Thanks

Oleg

View 6 Replies View Related

SQL 2005 Enterprise To Standard Replication

Jan 16, 2008

Hi Folks,

A simple question, but I can't seem to find the answer anywhere on line:

Can you use SQL 2005 Standard edition to replicate a SQL 2005 Enterprise Edition?

Many thanks in advance,

Ron Fowler

View 4 Replies View Related

Upgrading From Standard To Enterprise Edition

May 22, 2006

We have SQL 2005 standard edition and Reporting Services installed on the same server. We are now upgrading from standard to enterprise edition, so we ran setup and let it do its thing. This upgraded SQL Server without any problems but it failed to upgrade Reporting Services. We got a message saying "...set up did not have the administrator permissions required to copy a file: C:Program FilesMicrosoft SQL ServerMSSQL.5Reporting ServicesReport Server
ssrvpolicy.config...".

As we tried to upgrade reporting services using the same administrator account we cannot understand why this error would occur. From checking the version of SQL Server to Reporting Services we have 9.00.1399.06 on SQL Server and 9.00.1399.00 on Reporting Services so I presume this proves the upgrade did not work?

Has anyone got any idea what we need to do?

Thanks

View 4 Replies View Related

Differences Between Enterprise And Standard Editions.

Apr 26, 2007

I have been given the "Performance and Scalability Guide" for Forefront Client Security by one of our representatives from Microsoft. The document is listed as published in July 2007, so I apparently can not supply a link. The document makes a couple of hard to swallow claims, though. One of these is this:










The sizing differences between SQL Server Standard Edition and SQL Server Enterprise edition are due to the differences in the index sizes between the two editions.
I have to say I do not buy this. Can anyone disillusion me, or give me a link to anything that even implies this? I have not found anything to prove or disprove this, as yet.

Another oddity in this document is that FCS will not support 64 bit SQL Server, but encourages the use of AWE and /3GB. I can not believe there are functionality differences between the two, unless their database performance is negatively impacted by the 64 bit architecture (naturally the document is silent on why they do not support 64 bit).

Anyway, the questions are does the quote above actually hold any water? And would 64 bit SQL server cause functionality problems, other than performance problems?

View 4 Replies View Related

Mixed Environments - SQL 2000 Standard && Enterprise??

Oct 6, 2005

We are upgrading a production database server to new hardware. The server is currently running SQL Server 2000 Standard Edition. We are thinking about installing SQL Server 2000 Enterprise Edition, however that would mean the test server (2000 Standard) and production server (2000 Enterprise) have different edtions of SQL Server. How much of a risk does this present? Later in the year we would upgrade test to SQL Server 2000 EE, but for a couple of months the environments would be different.

Thanks, Dave

View 3 Replies View Related

2005 Standard To Enterprise Edition Migration ?

May 1, 2008

I installed SQL 2005 Standard edition on a failover cluster (Windows 2003). It is in production. Vendor wanted Enterprise Edition. What are my options to migrate to Enterprise? Is there an in-place way to do this, or is it a big deal?

Vendor probably doesn't need Enterprise. It's a low volume OLTP application with small databases. No fancy stuff (other than the failover clustering). Vendor simply did not test his application on Standard so he says we need Enterprise. Nevertheless, Management will probably want me to make the change.

View 3 Replies View Related

How Can I Tell If A Sql Server Is MSDN Or Standard Or Enterprise Version

Nov 3, 2005

Hi,How can I tell If my sql server is MSDN or Standard or Enterpriseversion.Thank youAR

View 5 Replies View Related

Migrating Form Standard To Enterprise Edition

Nov 10, 2005

Hi,Can someone tell me what the best way is to migrate from a SQL Server 2000Standard Edition to a SQL Server 2000 Enterprise Edition?Is this a migration possible from the setup program of the EnterpriseEdition?What are the pitfalls?Thanks in advanceTheo Linnenbank

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved