Conversion of Beta 2 Databases

How do I convert a Beta2 database to the RTM version?
SQL 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.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||SQL Scott (SQL Scott@.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 the
format 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, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||I'll plan to script out the database and export the data using the Beta 2
tools.
Thanks for your response!