Link static data in sql source control
You can link data that doesn't change very often to SQL Source Control. This lets you commit data changes to source control.
To source-control data:
1.In the Object Explorer, right-click the database or table with data you want to source control and select Other SQL Source Control tasks > Link or unlink static data.
还是先用sql search找到对应的表，然后再邮件选中
2.A dialog box opens with the Link/unlink static data tab selected:
The dialog box shows a list of the tables in the database.
You can only source-control data in tables with a valid primary key (including using only PK capable datatypes). The primary key is used as the comparison key to identify corresponding rows.
3.Select the tables you want to link.
4.Click Save and close.
5.SQL Source Control creates a file for the table's data, but the data itself hasn't been committed yet.
On the Commit tab, select all Static Data changes, type a comment (optional), and click Commit.
The data is committed to source control.
Linking to data affects performance
Committing data can be slow. We recommend you only source-control static data (also known as lookup or reference data). Source-controlling very large static data tables might cause SQL Source Control to time out.
If static data is slowing down performance, on the Setup tab, under Options just for this database, disable checks for changes to static data.
最新文章
- BZOJ 2743 树状数组
- C语言总结（6）
- Hadoop MapReduceV2(Yarn) 框架简介
- RStudio版本号管理 整合Git
- ngrok把本地主机映射到公网域名
- python第三课
- 通过 AJAX 加载的 JavaScript 脚本的调试
- 第三章Android移植平台工具介绍
- 如何在vue中使用ts
- Android Dialog对话框
- 一点理解之 CmBacktrace: ARM Cortex-M 系列 MCU 错误追踪库
- Redis-Sentinel 数据源配置
- 性能监控(2)–linux下的vmstat命令
- 整数划分 NBUT - 1046
- Linux企业运维人员最常用150个命令汇总 [转]
- LightOJ - 1246 Colorful Board（DP+组合数）
- 当超强台风“山竹”即将冲进南海，Power BI 你怎么看？
- input 数字输入控制（含小数）
- SQLAlchemy技术文档（中文版）（全）
- [转] Cacti+Nagios监控平台完美整合