SQL 2005 CTP up to RTM

I am installing SQL 2005 Developer Edition Sept CTP on the server which will
hold production databases once the RTM is released. Come November, do I need
to backup the databases, uninstall CTP, install RTM version then restore the
databases I was told to basically expect our production deployment before
November. The developers basically are using the new features of Reporting
Analysis, SQL Server etc. I have mixed feelings about how to handle these
type of deployments.
Also, can someone point me to the newsgroup pertaining SQL2005.
I need some expert opinion on how to handle these.

Thanks,
Lito

Answer this question

SQL 2005 CTP up to RTM

brian7339

Steven,

I don't see this information in any Microsoft documentation. In fact, from
what I see, I would not advise anyone to install the September CTP expecting
a smooth upgrade to the November release. In particular, if the original
poster installs Visual Studio 2005 beta along with the September CTP (to allow
sp debugging or CLR development in the IDE, for example), it _will_ be necessary
to uninstall the SQL Server CTP for an upgrade to RTM, according to the
Readme for VS2005 setup:
http://support.microsoft.com/default.aspx scid=kb;en-us;908452

Section 1.2 of that article says pre-RTM versions of Visual Studio 2005 must
be uninstalled before RTM is installed; the same section lists .NET Framework 2.0
Beta as one of the 20-odd items to uninstall; and Section 1.3.15 of the same
article says "You must uninstall SQL Server 2005 and MSDN Library before
uninstalling .NET Framework 2.0" (In fact, as I read the KB article, despite
all the advice, upgrading from pre-RTM to RTM Visual Studio 2005 is not
even an officially supported upgrade path.)

It's still possible that the SQL Server September CTP can be upgraded
to RTM so long as no pre-release of VS2005 was installed as well, but
as I said, I don't see any documentation to support such a claim.
Can you point to some official documentation or give the basis for what
you posted 

SK

Steven Twitchell@discussions.microsoft.com wrote:

> You will be able to upgrade from the September CTP to RTM. It would be
> a good idea to back up your databases files and logs before you upgrade.
> Uninstalling the CTP is not required.
> 
> 
>

kpb24
Steven.. just making sure.. I have to uninstall and install clean, regardless of VS 2005 installation

Is there an easy way of saving the databases, so they don't need to be laded from scratch

Thanks.. Dave
Clint Anderson
I would back up the databases and transaction logs just to make sure I have a good backup in case anything goes wrong.

After you've backed up the database you can detach your database, uninstall the CTP server and tools, install the RTM server and tools, then attach your database. This can save you a little time restoring a backup, but is otherwise equivalent.
Neo_xx
Unfortunately, NNTP User is correct, you will have to uninstall the September CTP before installing the RTM SQL Server 2005 build.

I was under the impression that upgrades from the September CTP were going to be supported (and so were the other engineers I checked with before I posted), but the RTM ReadmeSQL2005 file contradicts this. The documentation is pretty much never wrong about this sort of thing, so I'll have to beg your pardon for my error.
alex1990

You will be able to upgrade from the September CTP to RTM. It would be a good idea to back up your databases files and logs before you upgrade. Uninstalling the CTP is not required.
SQL 2005 CTP up to RTM

Answer this question