Created : 15 April 2015
Last Modified : 04 Feb 2021

***********************************************************************************
Contents:

A. SUMMARY
B. FILE STRUCTURE
C. INSTALLATION INSTRUCTION
D. HOW IT WORKS
E. CONFIGURATION SETTINGS
F. DATABASE TABLES MODIFIED
G. LANGUAGE SETTINGS CHANGED
H. CHANGE LOGS
I. TROUBLESHOOTING
J. FAQ
K. COPYRIGHT NOTICE
L. TERMS AND CONDITIONS
***********************************************************************************

A. SUMMARY
==========
This tool can move a single table or some tables or all tables from a VPCART Access/MySQL/SQL Server database to the equivalent Access/MySQL/SQL Server database

***********************************************************************************

B. FILE STRUCTURE
===================

Files included in the zip are:
- $READ_ME_FIRST_copydb900.HTML
- admin/copydb900.asp
- admin/copydb900_setup.asp
- admin/copydb900_setup_config.asp
- admin/copydb900_setup_process.asp
- admin/copydb900alert.asp
- admin/copydb900sub.asp
- admin/images/closealert.jpg
- admin/sqlscripts/copydb900/*

***********************************************************************************

C. INSTALLATION INSTRUCTION
============================

1. Upload the below files to your ADMIN folder. If you have renamed your ADMIN folder, then this must be placed in the renamed folder.
- admin/copydb900.asp
- admin/copydb900_setup.asp
- admin/copydb900_setup_config.asp
- admin/copydb900_setup_process.asp
- admin/copydb900alert.asp
- admin/copydb900sub.asp
- admin/images/closealert.jpg
- admin/sqlscripts/copydb900/*

2. Log into super admin and execute page below:
http://www.yourdomain.com/<your admin folder>/copydb900_setup.asp

Note: Replace the below with your VPCart site
{ www.yourdomain.com } : your site domain
{ your admin folder } : your admin folder

Click Install Now button.

3. After installation completed, you should see message below:
_______________________________________________________
The Database Migration Tool initial setup has now been completed.

Please go to modules configuration page for further setup.
_______________________________________________________

4. Please click the "modules configuration page" link to setup.

- Enable? : Set to Yes to enable Database Migration Tool.
After selecting Yes, click Save button.

- Database Migration Page : Click the Configure link to start using this tool.

***********************************************************************************

D. HOW IT WORKS
===============

At section "Step 1: Select Database Type for Source & Target Database", plese select the Target and the Source database type then click on "Continue" button.

At "Step 2: Enter Database Login Information", please enter all the required database login information then click on "Copy table" button to start.
By default, the target database details are already filled in with the live site database details.
However you can change these on your own liking for the Source and Target db.

To select more than one table, use CTRL + mouse click to select each table you to copy the data.

The tool will DELETE all records in the Target database.
Make sure you already have BACKUP for your live db before getting overwritten.
Then it will copy all records from one or all tables of the Source database tables to the same named Target database tables.

During the process, you will see a "processing" wording appears.

When the process is completed, you will see message "Copying Completed."

IMPORTANT NOTES :
- Both databases (source and target) must be perfectly matched for fields and tables otherwise you will get error during copying data.
Example, if you copy products table from Database A to Database B.
Database A products table have custom field "otherfield1" but Database B does not have the field.
Then you cannot just run this tool as it will not working.
What you need to do is to add any of your custom field(s) into the target database for the related tables.

- For target db using SQL server, please make sure you have permission for the SQL db user to grant for IDENTITY_INSERT.
The minimum permissions needed for the SQL DB user to perform this action is database owner (dbo).
So for target site using SQL DB, please make sure you grant the target SQL DB user for DB_OWNER before you run this tool.
Please contact your database administrator for this.

***********************************************************************************

E. CONFIGURATION SETTINGS
=================

New config:
xcopydb900_enable


F. DATABASE TABLES MODIFIED
===========================

NONE

NONE

2016.04.07 - added 2 new tables : customers_pwd_token and filter_main
2017.07.29 - allow maximum script timeout
2018.04.26 - compatible for VPCart 9.0.
2019.10.05 - Bug fix for db password that contains %
2019.10.07 - Bug Fix: copydb: Better handling on "reserved word" in fieldname
2021.02.04 - Fix for removing unneeded Ms Access system tables from dropdowns list. Remove productvariants table from list as not needed

***********************************************************************************

I. TROUBLESHOOTING
============================

Please submit a ticket to our helpdesk at https://helpdesk.vpcart.com and our support team will assist you.

***********************************************************************************

J. FAQ
============================

NONE

***********************************************************************************
K. COPYRIGHT NOTICE
============================

Copyright (c) 1999-2023 Rocksalt International Pty. Ltd.
All rights reserved.

This software and documentation constitute a published work and
contains valuable trade secrets and proprietary information
belonging to Rocksalt International Pty. Ltd. .
None of the foregoing material may be copied,
duplicated or disclosed without the express written permission
of Rocksalt International Pty. Ltd. .

LICENSEE ACCEPTS VP-ASP Shopping Cart "AS IS" "WITH ALL FAULTS",
Rocksalt International Pty. Ltd. accepts no responsibility for the
operation or performance of the VP-ASP Shopping Cart.
The entire risk of use and consequences of use of the
VP-ASP Shopping Cart falls completely on the Licensee
and Rocksalt International Pty. Ltd. shall not be liable in any respect
for any claims, loss or injury alleged to have resulted
from use of or in reliance on VP-ASP Shopping Cart.

Licensee acknowledges that it has read the foregoing
disclaimers of warranty and limitation of liability
and understands that Licensee assumes
the entire risk of using VP-ASP Shopping Cart.


***********************************************************************************

L. TERMS AND CONDITIONS
============================
ROCKSALT INTERNATIONAL GRANTS TO THE LICENSEE A NON-EXCLUSIVE,
NON-SUB LICENSABLE, NONTRANSFERABLE LICENSE
TO INSTALL AND USE THIS APPLICATION ON A SINGLE DOMAIN FOR
A SINGLE SHOP.

THE CODE IN THE APPLICATION MAY BE MODIFIED FOR USE IN
SETTING UP A SINGLE SHOPPING SITE ON THE WORLD WIDE WEB.

LICENSEE MAY MAKE A COPY OF THE APPLICATION FOR
BACK-UP AND ARCHIVAL PURPOSES, PROVIDED THAT ANY COPY
MUST CONTAIN ALL PROPRIETARY NOTICES INCLUDED
WITH THE APPLICATION.

LICENSEE IS PROHIBITED FROM SELLING OR DISTRIBUTING
THE APPLICATION IN ANY MANNER.

LIMITATION OF LIABILITY.

ROCKSALT INTERNATIONAL AND ITS LICENSORS SHALL
NOT BE LIABLE FOR ANY DAMAGES SUFFERED BY LICENSEE OR ANY
THIRD PARTY AS A RESULT OF USING OR DISTRIBUTING THIS
APPLICATION.

IN NO EVENT WILL ROCKSALT INTERNATIONAL OR ITS LICENSORS
BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA,
OR FOR DIRECT, INDIRECT, SPECIAL,
CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES,
HOWEVER CAUSED AND REGARDLESS OF THE THEORY OF LI
ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE,
EVEN IF ROCKSALT INTERNATIONAL HAS BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.