Sunday, February 12, 2012

Converting SP to SQL Server 2005

I have a SQL Server 2000 database that is approximately 100 GB in size with
200 stored procedures and 30 views.
I would like to convert this SQL Server 2000 database to a SQL Server 2005
database.
Have are the differences that I will have converting this database with
triggers, indexes, stored procedures, and views.
Thank You,You can run the SQL 2005 upgrade advisor against your database to identify
items you need to address before/after the conversion. In any case, it's a
good idea to test before upgrading production databases.
Hope this helps.
Dan Guzman
SQL Server MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:CDB6A87F-2BA7-4292-A7E8-3EA987E52006@.microsoft.com...
> I have a SQL Server 2000 database that is approximately 100 GB in size
> with
> 200 stored procedures and 30 views.
> I would like to convert this SQL Server 2000 database to a SQL Server 2005
> database.
> Have are the differences that I will have converting this database with
> triggers, indexes, stored procedures, and views.
> Thank You,

No comments:

Post a Comment