Administrator Help - RC v3.3
Search for:  by:     Edit Help
 Chapter - 12.3 Moving from Access to SQL

Make sure to follow First Time Configuration in chapter 12.0

You may move from MS Access database to SQL (MySQL or MSSQL). Follow steps below:

  • Make sure the site configured to run with MS Access is operational and functional.

  • Create a database at your hosting, gather database name, SQL server hostname, SQL user name and password.

  • Upload setup pages - !setup.asp and !setup_database.asp to the site and navigate to !setup.asp page in a browser. Follow screens and then go back to the site. You would have a new site configured with SQL with the default data. Delete uploaded setup pages.

  • If you installed any plug-ins while running MS Access, which required database update (such as Ads Import Tools or Authorize.net), then you would need to repeat the first installation step for each plug-in. That is uploading and running database update page. See each installed plug-in manual for that.
    Note: If you missed this step and restored data from MS Access to SQL without updating database, then you would certainly get numerous errors on pages when software would try to access non-existed tables or fields. You may reinstall plug-ins AFTER the restore but in this case, you would loose data configured for those plug-ins, which was stored in MS Access. In which case there would be a need to run the restore again.

  • Go to Global Manager admin page and click Access-2-SQL. Type the password, click "Convert MS Access to SQL" button. When restore is complete click Back to Site link to return to the default page and make sure the site is operational. Note: use only Back to Site link to return to the site and not a back browser button. The link first leads to the cache reset page (which is essential after restore) and then to the default page.

All data is now replicated/restored from MS Access to currently configured SQL and the site should look like as you had it with MS Access before the rollout. You may now remove or backup to your local computer current cldb.mdb in db folder.

©2003-2010  Rapid Classified v3.3  GA Soft