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:
- Make sure your version of I/NET supports Full SQL (check ReadMeSeven.txt file located on the Install CD)
- Backup all controllers (HVAC and Security) to database
- Backup MSDE database using DBCreate (Start, Programs, I/NET, DbCreate Utility)
- If running I/NET as a service, unregserver to stop the service (Running I/NET Seven as a service on Windows)
- If applicable, demote Equalized Clients(EQ) to StandAlone then demote FileMaster(FM) to Standalone
- Using Microsoft SQL Management Studio Express create an instance database for INETSeven which I have explained how to do in step 7
- In SQL Management Studio Express right click on Databases and select New Database and be sure to name specifically INETdb
- 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
- Create a blank I/NET SQL database with proper login credentials
- Still from DBCreate Utility, restore the database from previous step which is a good backup
- Re-install I/NET over the top of the existing install so that the StandAlone will use this instance of SQL
- Have the proper security key information
- When the install gets to the SQL, select the instance from the SQL database created in step 9
- Complete the installation
- Suggested reboot if necessary and start I/NET
- 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
