By using this site, you acknowledge that you have read and understand our Cookie policy, Privacy policy and Terms .

首先,必须知道数据库服务器的地址(IP),连接用户名和密码、

其次,可以按照下面几种方式进行:

一,数据库》》任务》》备份   从备份的地址上下载下来

二,如果不能访问备份的地址,或者没有权限浏览服务器的目录的权限,可以选择这样一种方式:

1,在本地MSSQL企业管器里新注册远程数据库

2, 选中所有远程数据库的用户表,右键 所有任务 生成SQL脚本 并在选项里选中 编写主键 外键 ......

3,在本地新建一数据库,在新建数据库中执行新生成的SQL脚本,注意脚本中的Use [数据库的名称] 和你的是否一致,以及是否存在?

4, 然后在新建数据库中点 右键 所有任务 导入数据,先填源数据库,也就是远程数据库,后填目的数据库,也就是新数据库 最后确定。在导入的时候注意,View即虚拟表不用选择否则会出错

同时有一点需要提醒大家的,双向导入导出的两个数据库的排序规则需一致,否则会出现数据表里边的数据乱码的现象

info Last modified by Raymond at 6 years ago * This page is subject to Site terms.

More from Kontext

visibility 13649
thumb_up 0
access_time 6 years ago

SQL Server Compact 4.0 (CE 4.0) is a free SQL Server embedded database ideal for building standalone and occasionally connected applications for mobile devices, desktops, Web clients and others. In one of my projects, I used it as the database for logging errors, which assumes the errors will onl...

open_in_new View open_in_new SQL Server

visibility 684
thumb_up 0
access_time 6 years ago

SQL Server provides a batch of great features to build robust, high-performance and scalable data solutions. ...

open_in_new View open_in_new SQL Server

visibility 1143
thumb_up 0
access_time 6 years ago

Serial: An Introduction to SQL Server Features Case Scenario In the previous articles of this serial, I’ve introduced how to use SQL Server as database for online transaction proces...

open_in_new View open_in_new SQL Server

visibility 4114
thumb_up 0
access_time 6 years ago

Serial: An Introduction to SQL Server Features Case Scenario For this ETL project, the requirements are listed below: Sales data will be pushed to specified shared fold...

open_in_new View open_in_new SQL Server

info About author

Kontext dark theme mode

Dark theme mode

Dark theme mode is available on Kontext.

Learn more arrow_forward
Kontext Column

Kontext Column

Created for everyone to publish data, programming and cloud related articles. Follow three steps to create your columns.

Learn more arrow_forward
info Follow us on Twitter to get the latest article updates. Follow us