1 Reply by GiGL

  • GiGL
  • Member
  • Offline
  • Registered: 19-07-2011
  • Posts: 5

Re: migrate R6 to sql server 2008

Hi all,

I'm looking to upgrade from sql server 2000 to 2008 and understand from Sally Rankin that Recorder 6 will not install onto this version. Is it ok, though, to migrate an existing R6 database? Will that work ok?

Matt

2 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: migrate R6 to sql server 2008

I installed the 32-bit SQL Server 2008 R2 Express on a new laptop recently and then tried a standalone installation of Recorder 6 but it failed with an Invalid class string error (see http://forums.nbn.org.uk/viewtopic.php?pid=8641#p8641 ). However, after downloading Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC) from http://www.microsoft.com/download/en/confirmation.aspx?id=16177 and installing SQL-DMO only (the second of 4 options) Recorder 6 installed successfully.

Note that a forum post by John van Breda http://forums.nbn.org.uk/viewtopic.php?pid=7112#p7112 says that if the 64 bit version of SQL Server 2008 Express is used it isn’t detected by the Recorder 6 installation.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

3 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: migrate R6 to sql server 2008

There are a number of users  on SQL Server  2008  and I use it myself.   You can either install as Sally suggests, but mosts users will have installed 2008 and then attached the database from  the previous version.

Mike Weideli

MikeWeideli's Website