Import local ms SQL Server data to a remote server

This demo guides the customer to import local ms SQL Server data Remote Server for the customer's website.
First, log on to the remote database server:
1. Right-click the database to which you want to import data and select "import data" under "all tasks"

2. Go to the DTs import/export wizard and click "Next" to continue

3. Select a data source, enter the name, user name, password, and source database of the database where the data source is located, and click "Next ".

 

4. Select the target database, enter the name, user name, password, and target database of the target database, and click "Next ".

5. Select "copy objects and data between SQL Server databases" and click "Next" to continue

6. disable the security measure option

7. Set the scheduling mode. Generally, select "Run now" and click "Next" to continue.

8. Click "finish" to execute

9. Data Import completed