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
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
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
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
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
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
Aug 7, 2003
How to know if it is standard or enterprise edition that a remote sql server is?
View 7 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Jan 14, 2008
Can either of these be installed on a laptop?
Thanks,
Jaybee.
View 3 Replies
View Related
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
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
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
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
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
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
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
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
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
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
