Skip to main content

Installation and Setup

Migrate Data from old Database to V1 Database

MSSQL

All these steps are performed using Microsoft SQL Server Management Studio

To backup the old database, follow these steps:

  1. Right-click the target database.
  2. Select Tasks > Generate Scripts....
  3. Select all tables except the table DB.
  4. Click the Advanced button.
  5. Under General, select a value for Types of data to script. You can select Data only.
  6. Click Next until the wizard is complete.
❗
Check that all data is present in the script.

The old database can then be deleted/renamed.

💡
To be on the safe side, create a backup so the data isn't lost in case something goes wrong.

Next, you can create a new database in G-FrameManager (the specified user must have permission to create the database), or you can create the database using Microsoft SQL Server Management Studio and then have the database structure created in G-FrameManager.

Once the database has been completely created, you can run the backup script you created in Microsoft SQL Server Management Studio (you may need to adjust the database in the script: USE [YOUR_DATABASENAME]).

For all other databases please contact Support