Transferring schama from evaluation vertion to Liscense version for MSSQl2005

Question

Post reply

Transferring schama from evaluation vertion to Liscense version for MSSQl2005

harshal.patil

SSC Rookie

Points: 38
More actions
January 5, 2009 at 3:11 am

#126241

Hi..
I am Using MSSQL2005 evaluation version before.
In that database Old Instance ,I have 20 databases .
Now I want to Install Liscence version of MSSQL2005 on the same machine So I Installed the Liscence copy on the machine with new Instance name.
Now I want to add all databases to the new Instance.
So I stop all services of the old Instance ,copy all datafiles and logfiles in new folder and attach it tp new server .
Is this procedure is correct ? for attaching the database?
Or how to add all databases to new instance ?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Refer the following link:

http://support.microsoft.com/kb/224071/

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 2

You could have done an inplace migration from Evaluation to Standard/Enterprise Edition using the command line SKUUPGRADE=1 option. The command would be like the following:

start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SAPWD=MySAPassword

SQLACCOUNT=MyDomain\MyServiceAccount SQLPASSWORD=MyServicePassword

AGTACCOUNT=MyDomain\MyServiceAccount AGTPASSWORD=MyServicePassword

SQLBROWSERACCOUNT=MyDomain\MyServiceAccount

SQLBROWSERPASSWORD=MyServicePassword SKUUPGRADE=1

See the BOL Reference:

http://technet.microsoft.com/en-us/library/ms144259.aspx#upgrade

harshal.patil SSC Rookie Points: 38 More actions · Answer 3

This method is not supported as it shows upgradation is blocked

It shows as in GUI

Name: Microsoft SQL Server 2005 (MSSQLSER)

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.