LAS

 

There's a special version of the setup that installs SQL2012, however, if you upgrade a site that used to have SQL2005 it will continue using SQL2005.

This is controlled by a settings file named ConnectionStrings.config. In there you can change which SQL instance it connects to. You'll also have to migrate the database, please see the below for that.

A perhaps easier solution is to uninstall LAS, delete the ConnectionStrings.config and install the SQL 2012 version from scratch and then simply uninstall SQL2005. You'll loose all data of course...

 


Migration of Database from SQL2005 to SQL2012Manual migrationCurrently manual migration is the only available option.Migration consists of 3 main steps:Create backup at the old serverMove the backup file to a location that is accessible to the new serverRestore the backup at the new serverTo create the backup, connect to the old server and issue following command:

BACKUP DATABASE BXOLAS TO DISK = N'Before Migration From SQL2005.bak' WITH INIT


It will create backup in the default backup directory. You can quickly check path to the directory with this:

EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory'


The backup file needs to be moved to a place where it can be accessed by the new server. Recommended location is the default backup directoryof the new server. Obtain its path with the same SQL query that you used at the old server (make sure that you execute the query against rightserver). Copy or move the file to the new path and make sure that it is readable by the account that the SQL2012 runs as.Before you can restore the file, you need to obtain path to the data directory of the new SQL Server (it is the default directory in which the SQLServer stores its databases.) First, get the root directory with:

EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\Setup', N'SQLDataRoot'


Data directory is named "Data" and is stored directly in the root directory.Now you have everything you need to restore the database. Below you have SQL statement that performs the restore. Before you execute it,replace ${DataDirectory} placeholder with real path.

ESTORE DATABASE BXOLAS FROM DISK = N'Before Migration From SQL2005.bak' WITH REPLACE,   

MOVE N'BXOLAS' TO N'${DataDirectory}\BXOLAS.mdf',  

MOVE N'BXOLAS_log' TO N'${DataDirectory}\BXOLAS_log.ldf'


Finally, unlock SQL 2012 features with:

ALTER DATABASE BXOLAS SET COMPATIBILITY_LEVEL = 110


The new database is ready to use. Remember to ensure that LAS Server has correct connection string. You can also take the old database offline to ensure that no application will connect to it by mistake.

 

 

A Lot More to LAS

LAS Communication devices can interface with a wide range of applications and platforms.  LAS interface solutions connect almost any system. LAS will work across many industries including Health, Education, Hospitality, Retail and many more. There is a lot of information within our website so please explore the site fully, but be sure to call us to discuss your needs so that we can show you how LAS may be the perfect solution for your market sector.

LAS Community Support

LAS projects often see us working with great people providing care to those who need it most.  It is our privilege to support Youngcare as our chosen charity.  To find out how you can help too, visit the Youngcare website.

Young Care Logo