Friday, November 27, 2009

Bulk Copy

  1. Copy the data from the following tables of Source MSSQL DB Server
    1. Packages
    2. Package Version
    3. Package_Version_Linage
    4. Application_Groups
    5. Applications
    6. Application_publish_TOS
  2. If package is present in destination server then do not copy but get the package_id which will be added in applications table
  3. Import the details of package in the following flow
    1. Packages
    2. Package Version
    3. Package_Version_Linage
    4. Application_Groups
    5. Applications
    6. Application_publish_TOS

No comments: