|
Home > Archive > MS SQL Server Tools > November 2005 > Conversion of Beta 2 Databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Conversion of Beta 2 Databases
|
|
| SQL Scott 2005-11-23, 11:23 am |
| How do I convert a Beta2 database to the RTM version?
| |
| David Gugick 2005-11-23, 1:24 pm |
| 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
| |
| Erland Sommarskog 2005-11-26, 8:39 pm |
| 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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
| |
| SQL Scott 2005-11-28, 9:23 am |
| I'll plan to script out the database and export the data using the Beta 2
tools.
Thanks for your response!
|
|
|
|
|