ipplan v6.00-BETA2

NOTE: THERE IS NO UPGRADE PATH FROM v6.00-BETA2 to v6.00-BETA2. 
	you will need to "mysqldump ipplanv6", then drop the
	ipplanv6 database, install BETA2 and install the schema,
	then reload the database dump you took earlier.

To upgrade an older version of ipplan to the current version you will
need to first upgrade your existing version of IPplan to v4.92a by
downloading v4.92a and following the instructions for that version.

Once your current version is up to v4.92a, you will then need to
install a new version of IPplan v6. DO NOT INSTALL IPPLAN v6 OVER
v4.92a! You must install v6 into a different web location and 
database for the migration to work as the upgrade process copies
data from the old database to the new. Your old version of IPplan
is not modified and you can fallback to the old version if things
go wrong.

During the IPplanv6 installation, you must only create the ipplanv6
schema - do not create any users, groups or customers. The newly 
created database must be entirely empty.

Once the old and new versions are successfully installed you can run
the /ipplanv6/contrib/db-migrate.php script. You will need to edit
the db-migrate.php script and modify the below lines to point to
your v4.92a database. You can get the required information from
your ipplan v4.92a config.php file.

//Source DB
$dbf_type = "maxsql";
$dbf_host = "localhost";
$dbf_user = "root";
$dbf_name = "ipplan";
$dbf_password = "ippan99";

Once the upgrade process has completed, point your web browser 
to the new ipplanv6 location and logon with your old user-id's
and passwords.

NOTES FOR ORACLE:

Oracle upgrade only displays the database data as Oracle does not 
have the concept of databases which can have the same table names
etc. Thus 2x concurrent database approach as for mysql, mssql
and postgress is impossible. You will need to dump data, delete
all ipplan v4 tables, install new ipplan v6 tables and then import
the data:

I suggest:
	1) Untar IPplan v6
	2) Configure IPplan v6 config.php to point to your old 
		ipplan v4 database using the lines from your v4
		installation - do not do the ipplan schema install
	3) modify db-migrate.php as above (change $dbf_type etc)
	4) save the db-migrate output to a file
	5) backup your ipplan v4 database
	6) check that you can recover this database again
	7) do point six again as this is your original data!!!
	8) delete all the ipplan tables
	9) complete the schema install for ipplan v6 that was 
		not done in point 2) above
	10) you now have an empty ipplan database into which 
		you can use your oracle tools to import the
		data captured in step 4) above.


Apr 10, 2010
-  ipplan:	upgrade process tested with mysql and mssql.

Apr 4, 2010
-  ipplan:	the upgrade process has only been tested with
		mysql. mssql may work, oracle will NOT work and
		I am not sure about postgress.
