• 欢迎访问金笔头博客,这是一个菜鸟(伪)程序员的自留地,欢迎访问我的github:点击进入

PowerDesigner16.5连接SQLSERVER2012导出表结构

SQLServer eason 3922次浏览 8个评论 扫描二维码

工具和环境:

Win7 X64 bit
SqlServer2012 64bit
PowerDesigner 16.5
 
1.选中Workspace右键单击,依次选择New,Physical Data Model
PowerDesigner16.5连接SQLSERVER2012导出表结构
2.保持默认,选择OK即可
PowerDesigner16.5连接SQLSERVER2012导出表结构
3.在ODBC Machine Data Source选项卡中选择Add Data Source
PowerDesigner16.5连接SQLSERVER2012导出表结构
4.选择“用户数据源”
PowerDesigner16.5连接SQLSERVER2012导出表结构
5.选择驱动程序为SQL Server,下一步
PowerDesigner16.5连接SQLSERVER2012导出表结构
6.选择服务器为本机安装的SQL Server,名称和描述随便填
PowerDesigner16.5连接SQLSERVER2012导出表结构
7.选择“使用用户输入登录ID和密码的SQL Server验证(S)”,勾选“连接SQL Sever以获得其他配置选项的默认设置”,下一步
PowerDesigner16.5连接SQLSERVER2012导出表结构
8.更改默认数据库,下一步
PowerDesigner16.5连接SQLSERVER2012导出表结构
9.完成
PowerDesigner16.5连接SQLSERVER2012导出表结构
10.测试数据源
PowerDesigner16.5连接SQLSERVER2012导出表结构
11.测试成功!
PowerDesigner16.5连接SQLSERVER2012导出表结构
12.此时应该能看到之前我们新建的用户数据源,此处为SQLSERVER2012,选中该数据源,点击如图绿色小三角图标可以测试能否连接成功
PowerDesigner16.5连接SQLSERVER2012导出表结构
PowerDesigner16.5连接SQLSERVER2012导出表结构
PowerDesigner16.5连接SQLSERVER2012导出表结构
13.依次点击File,Reverse Engineer,Database
PowerDesigner16.5连接SQLSERVER2012导出表结构
14.输入物理数据模型名称,确定
PowerDesigner16.5连接SQLSERVER2012导出表结构
15.勾选Using a data source,选中我们之前新建的SQLSERVER2012
PowerDesigner16.5连接SQLSERVER2012导出表结构
PowerDesigner16.5连接SQLSERVER2012导出表结构
PowerDesigner16.5连接SQLSERVER2012导出表结构
16.选择要导出的数据库和表,点击OK
PowerDesigner16.5连接SQLSERVER2012导出表结构
PowerDesigner16.5连接SQLSERVER2012导出表结构
17.导出后的物理数据模型和表结构如下
PowerDesigner16.5连接SQLSERVER2012导出表结构
PowerDesigner16.5连接SQLSERVER2012导出表结构
18.That’s all !

 


金笔头博客, 版权所有丨如未注明 , 均为原创, 转载请注明PowerDesigner16.5连接SQLSERVER2012导出表结构
喜欢 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址
(8)个小伙伴在吐槽
  1. Really appreciate you sharing this post.Really looking forward to read more. Much obliged.
    Rent a party bus2016-02-07 20:25 Reply Windows XP | Firefox 3.5.3
  2. AvAxQW Wow, amazing blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your website is wonderful, as well as the content!
    fiverr seo2016-02-04 13:14 Reply Windows XP | Internet Explorer 6.0
  3. OkPTyK Really enjoyed this blog post.Much thanks again. Awesome.
    fiverr crorkservice2016-02-04 11:54 Reply Windows XP | Internet Explorer 6.0
  4. f4Mgnl There as definately a lot to find out about this subject. I like all of the points you made.
    crorkservice2016-02-04 11:11 Reply Windows XP | Internet Explorer 6.0
  5. TxLZlU Wonderful blog! I found it while searching on Yahoo
    crorkservice fiverr2016-02-04 08:04 Reply Windows XP | Internet Explorer 6.0
  6. Fh0z7m You have observed very interesting details! ps nice site.
    fiverr crorkservice2016-02-04 07:36 Reply Windows XP | Internet Explorer 6.0
  7. cd1T3j You, my friend, ROCK! I found just the info I already searched everywhere and just could not find it. What an ideal web-site.
    crorkservice2016-02-04 07:33 Reply Windows XP | Internet Explorer 6.0
  8. Thank you ever so for you post.Much thanks again. Cool.
    drunk fuck2016-02-02 03:55 Reply Windows 7 | Firefox 3.5.3