1. NiceLabel Help Center
  2. Wissensbasis
  3. Wie man

[en] Backup your local SQL database on Loftware Cloud

Die offizielle Übersetzung liegt noch nicht vor.

[en] Problem

[en] You migrated your labeling solution to Loftware Cloud, and you would also like to back up your existing SQL database to the SQL Azure database on . SQL Azure database has some limitations regarding user rights, so the standard SQL backup procedure won't work.

[en] Solution

[en] Generate scripts to create a backup of your local SQL database. Then, execute the scripts in the Azure SQL Database to restore your local database.

[en] To backup your database:

  1. [en] Open SQL Server Management Studio (SSMS) and connect to your SQL Server instance.

  2. [en] Expand the Databases node in Object Explorer.

  3. [en] Right-click your database, hover over Tasks, and click Generate Scripts....

    39_SQL_backup1.png

  4. [en] The  Generate Scripts window opens. Click Choose Objects, then select the database objects you want to backup.

    42_SQL_backup4.png

  5. [en] Click Next. The Set Scripting Options window opens. Click Advanced.

    43_SQL_backup4.png

  6. [en] The Advanced Scripting options window opens. Click Types of data to script, then select Schema and data in a drop-down menu.

    44_SQL_backup5.png

    [en] Click OK.

  7. [en] In the Set Scripting Options window, select Save as script file, define file path, then click Next.

    46_SQL_backup6.png

    Anmerkung

    [en] If you back up a big database, select the One script file per object option. SSMS will generate a separate export file for each table in your database.

    48_SQL_backup8.png

  8. [en] The Summary window opens. Verify your settings, then click Next.

  9. [en] In the Save Scripts window, verify that all actions were successfully executed, then click Finish.

[en] Your backup scripts are now generated and saved as .sql files.

[en] To restore your backup scripts in the Azure SQL database:

  1. [en] Open SQL Server Management Studio (SSMS) and connect to your Azure SQL database.

  2. [en] Click File > Open > File... and navigate to your backup .sql files on your local disc.

  3. [en] Select your backup .sql file, then click Execute.

  4. [en] If you created backup files for each table, repeat steps 2-3.

[en] Your local SQL database is now restored on Azure SQL database.