| Author |
Converting SQL Server 2000 database to 2005 format
|
|
| imarchenko 2006-02-10, 8:23 pm |
| Hello!
We have attached our 500GB SQL Server 2000 databases on 2005 server. The
process took literally took 10 seconds. I was wondering if databases should
undergo low level conversion when moved to 2005 environment in order to take
full advantage of new features. Will simply attaching the databases do the
job?
We are planning to switch databases to 9.0 compatibility mode. I am aware
certain features have been deprecated. Besides that I am concerned we won't
be able to take full advantage of new 2005 features unless we do low level
conversion. If this is the case, is there a way to initiate this process
after attaching the database ?
Any help is greatly appreciated,
Igor
| |
| Andrew J. Kelly 2006-02-10, 8:23 pm |
| There really is no low level conversion to take place. Most of the changes
are meta data and with the system and resource databases. It is highly
recommended that you run sp_updatestats after you attach it or better yet
after you set the mode to 9.0. Once you do that you will have full access
to the 2005 feature set.
--
Andrew J. Kelly SQL MVP
"imarchenko" < igormarchenko@hotmai
l.com> wrote in message
news:OMvyLypLGHA.2216@TK2MSFTNGP09.phx.gbl...
> Hello!
>
> We have attached our 500GB SQL Server 2000 databases on 2005 server.
> The process took literally took 10 seconds. I was wondering if databases
> should undergo low level conversion when moved to 2005 environment in
> order to take full advantage of new features. Will simply attaching the
> databases do the job?
> We are planning to switch databases to 9.0 compatibility mode. I am aware
> certain features have been deprecated. Besides that I am concerned we
> won't be able to take full advantage of new 2005 features unless we do low
> level conversion. If this is the case, is there a way to initiate this
> process after attaching the database ?
>
> Any help is greatly appreciated,
> Igor
>
| |
| imarchenko 2006-02-11, 3:23 am |
| Andrew,
Thanks a lot!
"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:O1f2TcqLGHA.1760@TK2MSFTNGP10.phx.gbl...
> There really is no low level conversion to take place. Most of the
> changes are meta data and with the system and resource databases. It is
> highly recommended that you run sp_updatestats after you attach it or
> better yet after you set the mode to 9.0. Once you do that you will have
> full access to the 2005 feature set.
>
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "imarchenko" < igormarchenko@hotmai
l.com> wrote in message
> news:OMvyLypLGHA.2216@TK2MSFTNGP09.phx.gbl...
>
>
|
|
|
|