2 SQL Express to SQL Server Database Migration
SQL Express to SQL Server Database Migration Goliath Performance Monitor v11.5 (v11.5) March 2015 www.goliathtechnologies.com Legal Notices SQL Express to SQL Server Database Migration Guide for Goliath Performance Monitor v11.5 Copyright © 2014 Goliath Technologies Inc. All rights reserved. www.goliathtechnologies.com Goliath Technologies believes the information in this publication is accurate as of its publication date. The information is subject to change without notice. THE INFORMATION IN THIS PUBLICATION IS PROVIDED “AS IS.” GOLIATH TECHNOLOGIES MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND WITH RESPECT TO THE INFORMATION IN THIS PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Use, copying, and distribution of any Goliath Technologies software described in this publication requires an applicable software license. Linux is a registered trademark of Linus Torvalds. Windows is a registered trademark of Microsoft Corporation. VMware, ESX, ESXi, vCenter, and vSphere are either trademarks or registered trademarks of VMware Corporation. Citrix, Xen, XenServer, and XenCenter are either trademarks or registered trademarks of Citrix Systems Inc. All other trademarks and copyrights referred to are the property of their respective owners. 2 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 Table of Contents I. Overview ................................................................................................................................................ 4 II. Prepare the Database Files .................................................................................................................... 4 III. Stopping the MonitorIT Service ............................................................................................................. 4 IV. Detaching the old database ................................................................................................................... 6 V. Configure the new SQL Server ............................................................................................................... 7 Attach the new database............................................................................................................... 7 Create the Database DSNs ............................................................................................................. 9 VII. Configure the MonitorIT Windows Service for Remote SQL Databases ......................................... 12 3 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 I. Overview This migration document will cover the process of migrating from the embedded SQL Express 2005 Database to a new local or remote SQL Server Database. II. Prepare the Database Files Prior to setting up the new server you will need to ensure that the original Goliath Performance Monitor SQL Database file is ready to be moved and the new SQL Server is up and running. 1. Stop the MonitorIT service 2. Detach the database and copy it from its current location, to the new SQL Server directory 3. Management Studio is available to connect to the new SQL Server to facilitate setting up the database. III. Stopping the MonitorIT Service In this section you will learn how to stop the MonitorIT service. 1. Log into the server running SQL Express 2. Open Windows Services by going to ‘Control Panel > System and Security > Administrative Tools’ and double clicking ‘Services’ 4 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 3. The ‘Services’ window will appear, locate and select ‘MonitorIT Server Service’ from the list 4. Click ‘Stop the service’ to the right NOTE: A ‘Service Control’ window with a progress bar with appear displaying the progress of the service being stopped. Once finished it will disappear. 5 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 IV. Backing up the old database Now that the service is stopped we can bring the old SQL Express database to the new SQL Server 1. Open SQL Server Management Studio and Navigate to the ‘MonitorIT’ database 2. Right click the database, and go to ‘Tasks’ and then click ‘Backup’ 3. A ‘Backup Database’ window will appear, click the ‘Add’ button at the bottom to choose the backup destination 6 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 4. A pop up will appear to choose the file name location, once finished select ‘OK’ 5. Then selection ‘OK’ on the ‘Backup Database’ window and the database will begin to back up. Note: The backup process can take anywhere from 5 to 20 minutes to back up depending on the size of the database. V. Configure the new SQL Server In this section we will cover the steps necessary to attach your Goliath Performance Monitor SQL Express Database to the new SQL Server Database. Attach the new database 1. Open SQL Server Management Studio on the new SQL Server 2. Right click on Databases and choose ‘Restore Database..’ 7 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 3. The ‘Restore Database’ window will appear, use the drop down menus to select the database you backed up. 4. Once the database is selected click the ‘Verify Backup Media Button’ 5. Select OK to complete attaching the database. 8 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 VI. Connect Goliath Performance Monitor to your SQL Database In this section we will cover the steps necessary to complete the final steps in the migration process by creating the necessary DSNs and appropriately modifying the windows service. NOTE: If Goliath Performance Monitor will be located on a different server, check the security properties for this database. There should be a Windows User with DBO rights to the database. This information will be needed for this section if applicable. Create the Database DSNs This section will cover the process for creating a connection to the database you have just attached to SQL. 1. Log into your Goliath Performance Monitor Server 2. Go to ‘Control Panel\System and Security\Administrative Tools’ and double click ‘Data Sources (ODBC)(32-bit)’ 3. Once open, go to the System DSN tab: Note: If you have an existing DSN for ‘BreakoutRPM’ name, select ‘configure’ and rename it to ‘BreakoutRPM.Old’ 9 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 4. Next click ‘Add’ and scroll through the list to select the driver type: a. For local SQL Server instances: choose ‘SQL Server Native Client’ b. For remote SQL Server instances: choose ‘SQL Server’ 5. Name the connection with the information listed below, when finished click ‘Next’ a. Define the Name as ‘BreakoutRPM’ b. Define Description as ‘Primary GPM Database’ c. For ‘Server’ use the dropdown menu to pick the appropriate server name Note: For the SQL Server, be sure to pick the choice with the name in the correct format of the server 10 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 name/instance name of the new database from the dropdown menu. 6. Keep the default settings to use the Integrated Windows authentication to connect to the database and select ‘Next’ 7. Check the box next to ‘Change the default database to’ and select ‘MonitorIT’ from the dropdown menu. Click ‘Next’ 8. Keep the defaults for the additional options and click ‘Finish 9. Select the ‘Test Data Source’ button to validate the connection. Click ‘OK’ to close all windows a. If your SQL Server is local, go to Windows Services and restart the MonitorIT Server Service (Steps to do this are in Section III) and then once it is finished, restart MonitorIT server. b. If your SQL Server is remote go on to the next section for one last step 11 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015 VII. Configure the MonitorIT Windows Service for Remote SQL Databases When connecting to a remote SQL Server, it is necessary to modify the MonitorIT Server Windows Service with the appropriate logon rights to access the database. 1. Open Windows Services: ‘Control Panel > System and Security > Administrative Tools > Services’ 2. Find the ‘MonitorIT Server Service’ in the list, right mouse click, and choose ‘Properties’ 3. Go to the ‘Log on’ tab 4. Specify a Windows account that has DBO rights to the MonitorIT database you attached on the SQL Server (we recommend using the ‘Browse’ function to ensure the account gets validated). 5. Click ‘Apply’ and then ‘OK’ to close the window 6. Select ‘Start Service’ and then ‘Restart the Service’. 7. Once that is done, restart the Monitor IT server 8. When the server is back up and running you have completed the configuration! 12 SQL Express to SQL Server Database Migration Copyright © 2015 Goliath Technologies v11.5 - March 2015
© Copyright 2024