|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Conversion of Beta 2 DatabasesSQL Scott wrote:
> How do I convert a Beta2 database to the RTM version? Assuming the internal database design has not changed (I don't know that it has), you could either do a detach / attach or a backup and restore of the user database. TO be safe, you might want to export the DDL for the database and create the database schema separately from exporting the data. SQL Scott (SQL Sc***@discussions.microsoft.com) writes:
> How do I convert a Beta2 database to the RTM version? If memory serves, the April CTP was the last CTP that was able to read theformat of Beta 2. So you would have to install the April CTP to attach the databases there, and then move the databases from the April CTP to the RTM version. Since the April CTP is no longer available for download, this is not really a workable way. It may be better to script the database (using the Beta 2 tools) and bulk load the data. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |
|||||||||||||||||||||||