Remote connection management Import and Export SQL database

1. First Install SQL Server database software on your local computer

2. Click Start Menu => program => Microsoft SQL Server => Enterprise Manager => Microsoft SQL servers => SQL Server group => create SQL Server Registration (right-click) => enter the database server IP address (by adding) => select the SQL Server login information allocated to me by the system administrator => enter the correct account password =>...

3. After the connection is successful, find the database to which you belong and manage it.

4. Create an SQL statement database structure

Generate an SQL script file for the local database structure, and connect to a remote server to create a database structure.

5. Import and export your local data to the server and import the data on the server to the local machine.

 

Note:
If an error occurs during the second login ------ ("timeout expired" occurs when you log on to the database server ")

Install the following solution:

Modify the C: Window/ssystem32/Drivers/etc/hosts file on your local computer and add a line as follows:
-----------------------------------------------------------------
#102.54.94.97 rhino.acme.com # source server
#38.25.63.10 x.acme.com # X client host

127.0.0.1 localhost
Database Server IP Address
-----------------------------------------------------------------

SQL Database Import and Export

1. perform the same operations as remotely connecting to a database locally, for example:

 

 

 

2. Right-click your database name and click "all tasks" and "export data", for example:

 

3. Click "Next"

 

4. Click "Next"

 

5. Enter the Server IP address, click "use SQL Server Authentication", enter the user name and password, select the database, and click "Next"

 

6. Click "Next"

 

7. Click the name of the table to be exported and click "Next"

 

8. Click "Next"

 

9. Click "Next"

 

 

10. data exported successfully