Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

upgrading sql 2000 to sql 2008 will make any problem to my database ? Expand / Collapse
Author
Message
Posted Monday, October 15, 2012 5:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 20, 2014 12:36 AM
Points: 65, Visits: 205
hi,
i am running sql 2000 now my company has decided to go for sql server 2008.
i have many tables,indexes,functions,procedures in my database. if i upgrade it, will it make any problem to me ?
Something like some function or procedure will not work properly in sql 2008 which is running ok in sql 2000.
Post #1372658
Posted Monday, October 15, 2012 6:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
You can answer your questions by obtaining a copy of

Microsoft SQL Server 2008 Upgrade Advisor

http://www.microsoft.com/en-us/download/details.aspx?id=11455


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1372701
Posted Tuesday, October 16, 2012 7:03 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:10 PM
Points: 1,322, Visits: 2,937
The answer is it depends. You need to have a test environment and test, test, test. If you don't have a test environment for the upgrade then you MUST get one. Look into and use the Upgrade advisor:

http://www.microsoft.com/en-us/download/details.aspx?id=11455




Post #1373224
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse