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, September 25, 2014 3:02 AM
Points: 65, Visits: 204
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: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
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: Yesterday @ 5:17 AM
Points: 1,289, Visits: 2,844
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