谁有PowerDesigner.v12.5注册码啊
PowerDesigner到期了怎么办啊？
我按网上说的下了破解补丁，可覆盖文件后进不去程序怎么去PD菜单选？
已经重装过了，一进文件就要注册码，知道的指点下？
[解决办法]
我一直用的这个，有点问题一并给你吧。当时可找不到哪里的问题；
http://xiaofengtoo.javaeye.com/blog/216465
Power Designer 12.5下载、破解与汉化
关键字: power designer
下载地址：
http://download.sybase.com/eval/PowerDesigner/powerdesigner125_eval.exe
破解补丁：
http://media-001.yo2cdn.com/wp-content/uploads/235/23551/2008/05/e7a0b4e8a7a3.rar
破解方法：
下载 PowerDesigner12.5 后有一个 license.lic 和 pdflm12.dll 两个文件，license.lic 是用于破解序号的，pdflm12.dll 是用于替换原来安装后的文件，破解首先用 pdflm12.dll 替换安装要目录的 pdflm12.dll 文件，然后在PD的菜单中找到 Tools ==>> License Parameters ==>> 选第一个，然后先load找到 下载的 license.lic 文件，重启即破解完成。
===============================================================
如何在PowerDesigner里面去掉统计信息 pd
创建时间：2009年5月8日(星期五) 上午10:36 | 分类：未分类 | 字数：2266 | 发送到我的Qzone | 另存为... | 打印
>如何在PowerDesigner里面去掉统计信息
> 最新使用PowerDesigner对SQL Server 2000数据库作反向工程、以比较数据库和PDM的差异的时候，经常
>
> 会从数据库中Reverse出来一些名称以“_WA_Sys”开头的索引，这些索引并不是我们做数据库设计的时候
>
> 加的，而且从企业管理器中也看不到这些索引。
> 但是，使用“select * from sysindexes where name like '_WA_Sys%'”语句，直接查询sysindexes系
>
> 统表却能够查询出来。
> 后经查询相关技术文档得知，名称以“_WA_Sys”开头的索引，其实并不是真正的索引、也不具备索引的
>
> 功能，它是SQL Server查询优化器自动创建的统计信息（statistics）。
> 可是我们在PowerDesigner里面并不需要这些统计信息，如何才能使PD在Reverse的时候过滤掉这些统计呢
>
> ？
> 在PowerDesigner里面依次点击Tools-Resources-DBMS，打开“List of DBMS”窗口，从中选择Microsoft
>
> SQL Server 2000，再点击窗口上方的第一个按钮“Property”，现在我们来编辑PD的Reverse行为——
> 从左侧的TreeView中依次展开Script\Objects\Index，点击SqlListQuery，在右面的Value大编辑框里我
>
> 们可以看到如下SQL语句：
> {OWNER ID, TABLE ID, INDEX ID, CLUSTER ID, UNIQUE ID, CIDXLIST ...}
>
> select
> u.name,
> o.name,
> i.name,
> case(i.status & 16) when 16 then 'clustered' else '' end,
> case(i.status & 2) when 2 then 'unique' else '' end,
> case(k.keyno) when 1 then '' else ', ' end + c.name + case (Indexkey_Property(k.id,
>
> k.indid, k.keyno, 'IsDescending')) when 1 then ' desc' else ' asc' end
> from
> sysusers u
> join sysobjects o on (o.uid = u.uid)
> join sysindexes i on (i.id = o.id)
> join sysindexkeys k on (k.id = i.id and k.indid = i.indid)
> join syscolumns c on (c.id = k.id and c.colid = k.colid)
> where i.indid between 1 and 254
> [ and o.name = %.q:TABLE%]
> [ and u.name = %.q:SCHEMA%]
> order by
> 1, 2, 3, k.keyno
>
> 好的，看到了吗？在where i.indid between 1 and 254的下方加一句：
>
> and i.name not like '%_WA_Sys%' --过滤掉SQL Server自动创建的统计信息
>
> 就ＯＫ了。
>
> 加完之后就是现在这个样子：
> {OWNER ID, TABLE ID, INDEX ID, CLUSTER ID, UNIQUE ID, CIDXLIST ...}
>
> select
> u.name,
> o.name,
> i.name,
> case(i.status & 16) when 16 then 'clustered' else '' end,
> case(i.status & 2) when 2 then 'unique' else '' end,
> case(k.keyno) when 1 then '' else ', ' end + c.name + case (Indexkey_Property(k.id,
>
> k.indid, k.keyno, 'IsDescending')) when 1 then ' desc' else ' asc' end
> from
> sysusers u
> join sysobjects o on (o.uid = u.uid)
> join sysindexes i on (i.id = o.id)
> join sysindexkeys k on (k.id = i.id and k.indid = i.indid)
> join syscolumns c on (c.id = k.id and c.colid = k.colid)
> where i.indid between 1 and 254
> and i.name not like '%_WA_Sys%' --过滤掉SQL Server自动创建的统计信息
> [ and o.name = %.q:TABLE%]
> [ and u.name = %.q:SCHEMA%]
> order by
> 1, 2, 3, k.keyno
========================================================
ia CR 365309, support was added for RowGuidCol for MS SQL Server 2000.
When reverse engineering via ODBC, the metadata for this object is not reverse engineered. However, they are reversed via script.
Upon inspection of the XDB, this column is not being retrieved as part of the SqlListQuery for the column object.
Customer has provided the following query to reverse engineer these values:
{OWNER, TABLE, S, COLUMN, DTTPCODE, LENGTH, SIZE, PREC, COMPUTE, NOTNULL, IDENTITY, DOMAIN, DEFAULT, ExtIdentitySeedInc, COMMENT, ExtCollation, ExtIdtNotForReplication, ExtDeftConstName, ExtRowGuidCol}
select
u.name,
o.name,
c.colid,
c.name,
case when (s.usertype < 100) then s.name else x.name end,
c.prec,
c.length,
c.scale,
z.text,
case (c.status & 8) when 8 then 'NULL' else 'NOTNULL' end,
case (c.status & 128) when 128 then 'identity' else '' end,
case when (s.usertype < 100) then '' else s.name end,
case (v.text) when '('''')' then '~''''~' else v.text end,
case (c.status& 128) when 128 then
convert(varchar(10), ident_seed(u.name + '.' + o.name))
+ ', '
+ convert(varchar(10), ident_incr(u.name + '.' + o.name))
else '' end,
convert(varchar, p.value),
c.collation,
case (c.colstat & 9) when 9 then 'true' else 'false' end,
case (d.status & 6) when 2 then d.name else '' end,
case (COLUMNPROPERTY ( o.id , c.name , 'IsRowGuidCol')) when 1 then 'true' else 'false' end as ExtRowGuidCol
from
dbo.sysusers u
join dbo.sysobjects o on (o.uid = u.uid and o.type in ('U', 'S', 'V'))
join dbo.syscolumns c on (c.id = o.id)
left outer join dbo.systypes s on (c.usertype = s.usertype and s.xtype = c.xtype and c.usertype >= 0)
left outer join dbo.systypes x on (s.usertype > 100 and s.xtype = x.xtype and x.usertype not in (0, 18, 80) and x.usertype < 100)
left outer join dbo.syscomments z on (z.id = o.id and z.number = c.colid)
left outer join dbo.sysobjects d on (d.id = c.cdefault and d.category <> 0)
left outer join dbo.syscomments v on (v.id = d.id)
left outer join dbo.sysproperties p on (p.id = o.id and p.smallid = c.colid)
where 1 = 1
[ and u.name = %.q:OWNER%]
[ and o.name=%.q:TABLE%]
order by 1, 2, 3
To reproduce:
Generate the following table to the database and then reverse via ODBC:
create table MyUniqueTable (
UniqueColumn UNIQUEIDENTIFIER RowGuidCol null default NEWID(),
Characters VARCHAR(10) null
)
go
1/31/2006
This issue has been resolved in the PowerDesigner/PowerAMC 12.0.0 release.
