Upgrading Landing Pad (LPAD SQL VERSION) to the latest data definition
The newest version of LP uses a LPAD database attached to SQL server and the older version uses a LPAD.MDB (access database file)
Get a hold of the latest lpaddata.mdb and the latest database.updater.exe
Both found at northstarenterprise.com -> Downloads -> Northstar Enterpsie Portal
Enterprise Portal Release Downloads
UPGRADING THE LATEST VERSION OF LANDING PAD
The table definitions for both Northstar Desktop and the Northstar database are in the LPAD database, table [dbo].[tblGetDataTableDefs]
Before upgrading let's make a backup copy of it
If [dbo].[tblGetDataTableDefsBACKUP] DOES NOT EXIST run the following SQL statement
--This will copy all data into a backup table named tblGetDataTableDefsBACKUP
SELECT * INTO tblGetDataTableDefsBACKUP FROM tblGetDataTableDefs
If [dbo].[tblGetDataTableDefsBACKUP] EXISTS run the following SQL statement
--This delete all data from tblGetDataTableDefsBACKUP and reinsert it
DELETE tblGetDataTableDefsBACKUP
INSERT INTO tblGetDataTableDefsBACKUP SELECT * FROM tblGetDataTableDefs
To make sure the data got copied over correctly both statements and make sure the number of records is the same
SELECT COUNT(*) as [Rows] FROM tblGetDataTableDefsBACKUP
SELECT COUNT(*) as [Rows] FROM tblGetDataTableDefs
If the number of records is the same in both tables let's delete the data in the original table
--MAKE SURE THE ROW COUNT IS THE SAME BEFORE RUNNING THE FOLLOWING STATEMENT
--Remove the - - before running the statement below
--DELETE tblGetDataTableDefs
If anything goes wrong from this point on you can always put the data back from the backup table
Prerequisite: The backup table has the data from the original table
DELETE tblGetDataTableDefs
INSERT INTO tblGetDataTableDefs SELECT * FROM tblGetDataTableDefsBACKUP
Now let's pull in the latest table definition data from LPADDATA.MDB using the IMPORT DATA feature in SQL SERVER
Right click the LPAD Database to start the process and chose Tasks -> Import Data...
You may or may not get this Welcome form... moving on.
The Datasource is the LATEST LPADDATA.MDB that you downloaded from the northstarenterprise web site
Choose Microsoft Access and find the LATEST LAPADDATA.MDB
The next screen shots are very self describing.
--->
Only choose "tblGetDataTableDefs"
--->
ALMOST DONE!!!
Time to run the LATEST Northstar.DatabaseUpdater.exe (Probably downloaded from the northstarenterprise web site)
Browse to the Portal web.config file - The updater will use the connection string information there.
Click Update
That's it.