Hey guys - I need your help. We are using SQL Server 2000- which version do you think we should upgrade to. Also, wondering if you tried any Open Source data base and any thoughts on those. Thanks guys for your help - Mark Smith
View 3 RepliesDear All,
please correct me if i'm going in a wrong way.
i need to upgrade my sql server2000 ent to 2005 standard edition.
1) i'm installing seperatly on the same server, and later i'l stop the service of sql server 2000 then detach the databases later attach in sqlserver 2005, then change the compatiability level to 90.
now my doubt is can i install 2005 with the same instance name of 2000?
after finishing the installation, is there anything to change at application or automatically it connects to 2005 instance? please let me know
thank you very much
Arnav
Even you learn 1%, Learn it with 100% confidence.
Hey guys - I need your help. We are using SQL Server 2000- which version do you think we should upgrade to. Also, wondering if you tried any Open Source data base and any thoughts on those. Thanks guys for your help - Mark Smith
View 1 Replies View RelatedMyCompany Inc.is running SQL 2000. They do not want to upgrade to newer version.What compelling reasons will you give them to upgrade to a) SQL 2005 b) SQL 2008
Thanks.
Hey guys - I need your help. We are using SQL Server 2000- whichversion do you think we should upgrade to. Also, wondering if youtried any Open Source data base and any thoughts on those. Thanksguys for your help - Mark Smith
View 1 Replies View RelatedHi,
We are currently using Sql6.5, planning to upgrade to 7.0. Could anyone pls tell me the what are all steps and precautions i have to take, and possible errors, mistakes.
Thank u in advance
--Surya
I am using Sql Server 2000 . Its a heavy db with Lots of Objects and Data.I will be using 2005 for new projects and I wanted to upgrade the existing one. Can anybody tell a study report about the merits and demerits of upgrading ..
Thanks
Hi Experts,
I am gointo upgrade our SQL database servers to Service Pack4. Presently our servers configurations as follows
1) OS : Windows 2000 Server
DB : MS SQL Server 2000 Enterprise Edition with SP3
Db's : 7 Databases.(Contains 950GB Data Each)
Componets : 1)MS SQL Server 2000 Analysis Services
2)MS SQL Server 2000 Reporting Services Ent.Edtn
3)MS Data Access 2.6 SDK lite
4)MS XML parser SDK
2) OS : Windows 2000 Server
DB : MS SQL server 2000 Standar edition with SP3
DB's : 3 Databases.(Contains 350GB Data Each)
Components: 1)MS Data access Components KB870669
2)MS Soap toolkit 3.0
3)MS SQL server Analysis services
Let me know what all steps should i take before & after deploying Service pack4 & Which Services i must stop. All are live servers and having very crucial data.
I downloaded following Files from Microsoft Site.
1)SQL2000-KB884525-SP4-ia64-ENU.EXE
2)SQL2000-KB884525-SP4-x86-ENU.EXE
3)SQL2000.AS-KB884525-SP4-x86-ENU.EXE
4)SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
I am having less experiance in SQL Servers. but i can handle. Can you please advice.
Hope you will do that.
Thanks & reg'ds
Sree
Dear All,
i've run the upgrade wizard. i'm trying to upgrade from sql server 2000 ent edition to sql server 2005 standard edition.i'm getting the below error after run the wizard. please help me
Error:
ActiveX components cant create an object
Arnav
Even you learn 1%, Learn it with 100% confidence.
I want to know when I doing the upgradation from SQL server 2000 to SQL server 2005 is it true all the Cube will also upgraded or we required some extra effort?
View 3 Replies View Related