Skip to content

Migration Procedure from Pleasanter's Database (SQL Server) to Different Environments

Cautions

  1. This procedure assumes Windows Server 2019 OS and SQL Server DB environment.

Backup data from the source of migration

  1. Log in to the source environment.
  2. Launch SQL Server Management Studio and log in.
  3. Right-click "Database" → "Implem.Pleasanter" and select "Task" → "Export Data-tier Application".
  4. Click the "Browse" button under "Save to Local Disk", enter a file name, and click "Next".
  5. Click "Finish".
  6. Once the export is complete, verify that a file with a bacpac extension has been created.

Migrate data to the destination

  1. Log in to the destination environment.
  2. Copy the bacpac file from the source computer to the destination computer.
  3. Install Pleasanter in the destination environment.
  4. Installation procedure is here.
  5. Launch SQL Server Management Studio and log in.
  6. Right-click "Database" → "Implem.Pleasanter" and click "Delete".
  7. A dialog will appear, so confirm that the "Connection" field shows the target server.
  8. Be cautious as performing this operation in the wrong environment may result in unintended data loss.
  9. Check "Close existing connections" and click "OK".
  10. Right-click "Database" and click "Import Data-tier Application".
  11. Click the "Browse" button for "Import from Local Disk" and select the bacpac file.
  12. Click the "Next" button.
  13. Specify "Implem.Pleasanter" in "New Database Name" and click "Next".
  14. Click "Finish".
  15. Once the data migration is complete, use a tool like WinMerge to check the differences between the source and destination Parameters.
  16. Merge the source Parameters settings into the destination Parameters and restart IIS.
  17. For customers who have subscribed to Enterprise Edition, please migrate the license file as well.
  18. Log in to Pleasanter and confirm that the data has been migrated.