USE THOSE UTILITIES ON BOTH MySQL amd MSSQL

SQL2access.asp
==============

 A backup utility for Rapid Classified v3.1 MySQL/MSSQL

NOTE: This utility is not intended for a huge SQL (hundreds of Megs) database. It is best to ensure your SQL is backed by your host.

 I. Allows to backup your SQL tables into Access database:

	1. If you do not have control over SQL management console and at risk of loosing data
	in case of SQL crash. Your host normally should backup data on all servers.
	But you never know! So use this tool to create a local backup of an SQL.

	2. If you would like to move Rapid Classified v3.1 MySQL/MSSQL to Access. (Not that is happened often, but still..)
 
 II. How does the SQL2access.asp work:

	This utility does not use any third party components (DTS or like).
	It simply copycat all table fields values from SQL to an empty tables in Access.
	Note: you should use an enclosed "cldb.mdb" as a destination.
	

 III. How to use:

	1. Drop SQL2access.asp into your RC location on server.
	2. Drop enclosed "Conversion_Tools/cldb.mdb" into database folder (the "dbFolder" location specified in config.asp)
	The enclosed "Conversion_Tools/cldb.mdb" is an RC Access database with empty tables.
	3. Run SQL2access.asp from your browser. Depending on your SQL database size it might take some time to backup.
	Note: If you backup your SQL into Access .mdb which was previously used for backup, all data in .mdb will be erased.
		In other words a new backup overrides old data stored in cldb.mdb
	4. Once finished copy backed up cldb.mdb to your local hard drive. 

	Backup as often as you'd like, but make sure to use an enclosed blank
	cldb.mdb for each backup.


access2SQL.asp
==============

 A restore utility for Rapid Classified v3.1 MySQL/MSSQL

	!!WARNING!! - Watch out for this one! This utility will effectively clear your SQL database. So run it only after
	you installed a fresh copy of RC, after the SQL crash or during migration from Access version.


 I. Allows to restore your backed up Access tables into MySQL/MSSQL database:
	
	1. If your SQL crashed, it was not backup by your host and you previously created a backup with SQL2access.asp

	2. You would like to move Rapid Classified v3.1 from Access to MySQL/MSSQL.

 II. How does the access2SQL work:

	See SQL2access.asp above

 III. How to use:

	BEFORE RESTORING OR MIGRATING DATA FROM ACCESS MAKE SURE TO RUN "COMPACT AND REPAIR DATABASE..."

	1. Run setup and install a fresh copy of an RC v3.1 configured as MySQL/MSSQL on your server (create tables if necessary during setup).
	2. Drop access2SQL.asp into your RC location on server.
	3. Drop backed up (or one used in Access version) "cldb.mdb" into database folder (the "dbFolder" location specified in config.asp)
	4. Run access2SQL.asp form you browser. Depending on your Access database size it might take some time to restore.
	Note: All data in SQL database will be erased and data from cldb.mdb will be migrated into SQL.
	5. Logon to Admin page and press "Reset Server Cache" to populate cache with the new settings from restored database.


================================================================================================

The above utilities are intended for use with Rapid Classified v3.1 only.
Provided "AS IS" without warranties. Use it on your own risk. There is no support for this RC extra.