DEMO - Database Migration Script -- Page 1 -- Database Information

Created by. Jesse Spangenberger<flamus_diu@yahoo.com>

Download!

DEMO! This is a setup demo of how each screen looks. This WILL NOT perform any database calls of any type. ALL database funcitons have been disabled for security reasons. Hitting Continue/Submit will take transfer you to each page to take a look at the layout. Please download the work script and test it out on your own web server.

This script was created to simplify movement of data from one database to another database or from one table to another table in or not in the same database.

The Script is broken into three pages. The description of the pages are as follows:

  • Page 1 : Gathers database information for logging onto all databases and gathering the table names to move the information.
  • Page 2 : Creates the field maps. The field maps tells the script which field information in the source table matches the field in the destination table IF the field names are not the same.
  • Page 3 : Migrates the information and displays the results in table format for the records carried over.

    • Three things are needed for this script to work properly:

    1. Need to know all database names and login formation for both databases.
    2. Need to know the table names for all tables need to move information to and from.
    3. Need to know the field names in each table that are different in each table pair.

    TIP: Use a database user with all privileges to BOTH databases. Not required but helpful.

    Database Host
    Source Database Information
    Database Name:
    User (to connect to Database above):
    Password:
    Destination Database Information

    The username/password below does not need to be field out if it is the same as the username/password for the source database.
    Database Name:
    User (to connect to Database above):
    Password:
    Table Information

    Put the table names in each box next to its corrsponding number. Notice that all the fields in the source table will be put into the destination table. The Destination table can have more fields then the source table.

    # Source Table Destination Table
    1:
    2:
    3: