I/NET MSDE to Full SQL

[Product_Support]

Issue

MSDE to Full SQL

Product Line

TAC INET

Environment

I/NET Seven site

Cause

Need to Move db from MSDE to Full SQL

Resolution

Below are the steps to move from your MSDE to a full SQL instance:

1. Make sure your version of I/NET supports Full SQL (check ReadMeSeven.txt file located on the Install CD)
2. Backup all controllers (HVAC and Security) to database
3. Backup MSDE database using DBCreate (Start, Programs, I/NET, DbCreate Utility)
4. If running I/NET as a service, unregserver to stop the service (Running I/NET Seven as a service on Windows)
5. If applicable, demote Equalized Clients(EQ) to StandAlone then demote FileMaster(FM) to Standalone
6. Using Microsoft SQL Management Studio Express create an instance database for INETSeven which I have explained how to do in step 7
7. In SQL Management Studio Express right click on Databases and select New Database and be sure to name specifically INETdb
8. Using I/NET DbCreate Utility when the login screen appears, connect to the SQL Server (Computer Name Required) you want to use which has full SQL
9. Create a blank I/NET SQL database with proper login credentials
10. Still from DBCreate Utility, restore the database from previous step which is a good backup
11. Re-install I/NET over the top of the existing install so that the StandAlone will use this instance of SQL
12. Have the proper security key information
13. When the install gets to the SQL, select the instance from the SQL database created in step 9
14. Complete the installation
15. Suggested reboot if necessary and start I/NET
16. Restore SAV files (which is the database, see How to upgrade bin and SAV files in I/NET controllers) to the controllers in the I/NET network so everything is in sync with the db