Upgrading Landing Pad (LPAD SQL VERSION) to the latest data definition

Owned by Fabio Scopel (Unlicensed)
Last updated: Sept 08, 2014
3 min read

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.