PowerDesigner16导出Sql修复
来源:互联网 发布:大尺度 豆瓣 知乎 编辑:程序博客网 时间:2024/04/27 19:11
最近在对公司的系统做重构,用了pd16,导出到sqlserver2008时,出了一些问题,以前碰到过解决了,但再次碰到时,还是要查阅资料,所以这次把解决办法分享出来。
一,在数据库中创建SysProperties视图
if exists (select 1 from sysobjects where name = 'sysproperties'and xtype = 'V')
begin
DROP VIEW sysproperties
end
GO
CREATE VIEW sysproperties
AS
SELECT A.name As TableName,
A.id As TableID,B.Name As ColName,B.colid As ColID,
B.xtype As ColType,C.name As PropName,C.Value As PropValue
FROM sysobjects As A INNER JOIN syscolumns As B ON A.id = B.id
INNER JOIN sys.extended_properties As C ON C.major_id = A.id
AND ( minor_id = B.colid)
二,修改Table TableComment模板 路径是 Database -> Edit Current DBMS 窗体 General 选项卡 下 Script -> Objects -> Table -> TableComment
[if exists (select 1
from sys.extended_properties
where major_id = object_id('[%QUALIFIER%]%TABLE%')
and minor_id = 0 and name = 'MS_Description')
begin
[%OWNER%?[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%
]
end
][%OWNER%?[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%
:select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%
]
三,修改Column ColumnComment模板 路径是 Database -> Edit Current DBMS 窗体 General 选项卡 下 Script -> Objects -> Column -> ColumnComment
[if exists (select 1
from sysproperties
where TableID = object_id('[%QUALIFIER%]%TABLE%')
and ColName = %.q:COLUMN% AND PropName='MS_Description')
begin
[%OWNER%?[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
:declare @CurrentUser sysname
select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_dropextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
]
end
][%OWNER%?[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]%.q:OWNER%, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
:select @CurrentUser = user_name()
[.O:[execute ][exec ]]sp_addextendedproperty [%R%?[N]]'MS_Description',
[%R%?[N]]%.q:COMMENT%,
[%R%?[N]]'user', [%R%?[N]]@CurrentUser, [%R%?[N]]'table', [%R%?[N]]%.q:TABLE%, [%R%?[N]]'column', [%R%?[N]]%.q:COLUMN%
]
- PowerDesigner16导出Sql修复
- PowerDesigner16.5详细操作【导出SQL语句】
- PowerDesigner16 设置导出sql文件的编码
- PowerDesigner16.5导出SQL语句时如何将name列复制到comment注释里面
- PowerDesigner16.5--->SQL生成PDM
- PowerDesigner16(PDM)pd生成数据库sql脚本
- powerdesigner16.5逆向工程,从远程oracle11g数据库导出PDM
- 【数据库SQL】修复数据库BCP修复(导出导入的做法)
- 将.sql文件导入powerdesigner16.5的实现方法详解
- powerdesigner16.5
- PowerDesigner16 破解
- PowerDesigner16安装
- PowerDesigner16 用例图
- PowerDesigner16 状态图
- sql数据库修复技术
- sql数据库修复技术
- SQL数据库修复命令
- SQL数据库置疑修复
- F5方案
- js 除法进一位
- Java之BufferedImage简谈
- 使用 AngularJS & NodeJS 实现基于 token 的认证应用
- 使用命令行清理Mac 释放磁盘空间
- PowerDesigner16导出Sql修复
- 选择结构的程序设计
- IPC
- Ubuntu14.04 桌面特效
- Hadoop 列式存储引擎
- IOS发布App到APP Store的流程(亲测流程)
- 汇编基础知识
- 9447 ctf writeup
- 实现简单的滑动悬停效果