SQL Server--使用SQL Server Import and Export Wizard匯入缺少的Table

Posted by: bart30508 | in SQL Server | 11 months, 1 week ago |

#6 Issue closed: SQL Server-- 使用SQL Server Import and Export Wizard匯入缺少的Table與資料

Labels: SQL Server

MaxwellBest opened issue at 2021-06-17 08:02:

如果兩個Database有Table或View的缺失要同步, 可以操作SQL Server Import and Export Wizard, 方便使用, 無須寫Script.

不過Index仍需要使用Script才能同步就是了...

But anyway, SQL Server Import and Export Wizard使用方法如下:

  1. 點選目標資料庫右鍵->工作->匯入資料 image
  2. 針對來源Database選擇SQL Native Client image

  3. 針對目標Database選擇SQL Native Client image

  4. 選擇指定Table or View (也可以寫SQL) image image

  5. 指定是否需要匯出SSIS封裝->Finish,不匯出立即執行即可 image

  6. 最後等待全部執行success就ok了! image

參考來源:

https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-sql-server-data-source-sql-server-import-and-export-wizard?view=sql-server-ver15

Currently unrated
 or 

Subscribe

* indicates required

Recent Posts

Archive

2022
2021

Categories

Apache 1

Data Science 2

Dbfit 1

Design Pattern 1

Devops 3

DigitalOcean 1

Django 1

English 3

Excel 5

Flask 3

Git 1

HackMD 1

Heroku 1

Html/Css 1

Linux 4

Machine Learning 2

Manufacture 1

Mezzanine 18

Oracle 1

Postgresql 7

PowerBI 4

Powershell 4

Python 21

SEO 2

SQL Server 51

SQLite 1

Windows 1

database 8

work-experience 1

其他 1

自我成長 1

資料工程 1

Tags

SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)

Authors

bart30508 (146)

Feeds

RSS / Atom

SQL Server--使用SQL Server Import and Export Wizard匯入缺少的Table

© COPYRIGHT 2011-2022. Max的文藝復興. ALL RIGHT RESERVED.