Help Center > > User Guide> Microsoft SQL Server Database Management (Standard Edition)> Import and Export> Import

Import

Updated at:Mar 20, 2020 GMT+08:00

Operation Description

This topic describes how to import data into a table for backup or data migration. The table structure to be imported must be the same as that of the target table. If you import the .csv file, the data type of the target table must be the same. Only one file can be imported at a time. The maximum file size supported is 10 GB.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. On the top menu bar, choose Import Export > Import.
  2. Import the data. DAS allows you to import a file from a local path or an OBS bucket.

    • Import the file from a local path.

    In the upper left corner, click Create Task. On the displayed page, select an import type, select Upload File for File Source, set the attachment storage, and upload the file. Then, select the destination database, charset, and option, and enter the remarks.

    Files in DAS are stored in OBS buckets for security.

    • To protect data privacy, you need to provide your own OBS storage to receive the files to be uploaded. Then, DAS automatically connects to OBS and reads data in memory. During that process, your data will not be stored on any storage medium of DAS.
    • If you select Delete the uploaded file when import completed, the file you uploaded will be automatically deleted from the OBS bucket after being imported to the destination database.
    • Import the file from an OBS bucket.

      In the upper left corner, click Create Task. On the displayed page, select an import type, select Choose From OBS for File Source, and select a file from the bucket. Then, select the destination database, charset, and option, and enter the remarks.

    When the file is imported from an OBS bucket, the file will not be deleted after the import succeeds.

  3. After the setting is complete, click Create. The original data may be overwritten after data import. Therefore, confirm the information before you click OK.
  4. View the task progress in the task list or check task details.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel