|
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.
|