I have an existing database in SQL 2000 with tables, stored procedures, UDT's
triggers relations indexes, packages, logins, users etc. I want to port the
existing database in SQL 2000 to SQL 2005 beta version. What is the best
feature available to do the same in the best way, so that the database can be
totally replicated from 2000 to 2005

In BOL (2005) there is a section under

Contents | SQL Server 2005 Books Online | Installing SQL Server |
Upgrading to SQL Server 2005

There are ways to migrate listed here.


Allan



"Subi" <Subi (AT) discussions (DOT) microsoft.com> wrote