It is possible to convert Sql 2000 to 2008

Question

It is possible to convert Sql 2000 to 2008

jbkumar03

SSC Rookie

Points: 40
More actions
April 27, 2012 at 11:46 pm

#267995

Hi Friends,
I need to upgrade my Sql Server from sql 2000 to Sql 2008.
Is there any problem will arise or any syntax issue will come..
Can any know...
whether u have previously Experienced.
Please share freely......

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

vinu512 SSCoach Points: 15729 More actions · Answer 1

jbkumar03 (4/27/2012)
Hi Friends,
I need to upgrade my Sql Server from sql 2000 to Sql 2008.
Is there any problem will arise or any syntax issue will come..
Can any know...
whether u have previously Experienced.
Please share freely......

Check these links:

Upgrading Databases to SQL Server 2008 - a few lessons learned

upgrading from SQL Server 2000 to 2008

Vinu Vijayan

For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

Microsoft has available (for free) Upgrade Advisor software which you can run before attempting the upgrade... it will advise you of most problems which you might encounter.

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[/url]
Before posting a performance problem please read[/url]

rraja Default port Points: 1486 More actions · Answer 3

Yes you can upgrade. just have a look on this

http://www.techrepublic.com/blog/10things/10-tips-for-upgrading-to-sql-server-2008-r2/2376