Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

PowerDesignerÉú³ÉSQL ERͼ ˵Ã÷Îĵµ

Ò»¡¢PowerDesignerÉú³ÉsqlÎÊÌâ
Éú³ÉsqlµÄ·½·¨ÊÇ Database -->Generate Database (Ctrl + G ) µ«ÊÇÌáʾ Could not load VBScript engine.
Check VBScript installation. Generation aborted due to errors detected during the verification of the model. ¼ì²éÁ˺þà ·¢ÏÖ½«check model È¥µô¾Í¿ÉÒÔÁË£¡ÆäÖУ¬ one file onÊÇ·ñÐèÒª°´ÕÕ±íÉú³ÉÐí¶à¸ösql£¨Ä¬ÈÏÑ¡ÉÏ£¬¼´²»ÐèÒª£©
odbc generation    sqlÖ±½ÓÉú³Éµ½Êý¾Ý¿âÖÐ
Automatic archive   Éú³ÉsqlͬʱÉú³ÉapmÎļþ¡£ ¶þ¡¢Power designer, ·´Ïò¹¤³ÌÉú³ÉERͼ
1. In PowerDesigner, choose File | Reverse Engineer | Database.... The New Physical Data Model Dialog box, shown next, appears.DBMSҪѡ³ÉOracle 10G, È»ºóµã"OK"
2.ÔÚ³öÀ´µÄdatabase reverse engineering´°¿ÚÀï, µãÉÏ"Using script files", ÔÙµãÄǸö"н¨"µÄͼ±ê, »á³öÀ´¸öÑ¡ÔñÎļþµÄ¶Ô»°¿ò,Ñ¡Ôñscript fileµÄλÖÃ.then press "OK".
3. Éú³ÉER diagram Èý¡¢ÀûÓÃPowerDesignerµ¼³öÊý¾Ý¿âERͼ¡¢PDMͼ ±¾ÎÄÔÚÒÔÏÂÁ½ÖÖʱ»úϽÏΪÓÐÓ㺠1¡¢Êý¾Ý¿â˵Ã÷ÎĵµÓëʵ¼ÊÊý¾Ý¿âµÄ½á¹¹Í¬²½Ê±¡£
2¡¢¸ù¾ÝÏÖÓÐÊý¾Ý¿â½á¹¹Éú³ÉÆä˵Ã÷ÎĵµÊ±¡£ ÎÒÆ½Ê±ÊÇÕâÑùÀ´Éú³É¡°Êý¾Ý¿â˵Ã÷Îĵµ¡±µÄ£º ·½·¨Ò»(SQL Server 2000ʱÊÇÕâÑù×öµÄ) ʹÓÃÕâ¸öÈí¼þ"SchemaToDoc With Table Annotator v2.8.8"£¬ÔÚÍøÉϺÜÈÝÒ×ÕÒµ½ËüµÄ×¢²á»ú£¬ËùÒÔÓÃÆðÀ´ºÜ·½±ã£¬¶øÇÒËüÉú³ÉµÄÊý¾Ý¿â˵Ã÷ÎĵµÒ²ºÜרҵ¡£ µ«Òź¶µÄÊÇ£¬ÎÒÈ´ÎÞ·¨ÓÃËüÁ¬½Óµ½sql 2005»òoracle 10g£»
ÆäÆóÒµ°æ"SchemaToDocEnterpriseInstall.exe"µ¹ÊÇ¿ÉÒÔ˳ÀûÁ¬½Óµ½SQL Server 2005ºÍoracle 10g, µ«ÓÉÓÚûÓÐ×¢²áÂ룬ÿ´ÎÖ»Äܵ¼³ö3¸ö¶ÔÏó£¨ÕâÀïµÄ¶ÔÏó°üÀ¨stored procdure, view, table, functionµÈ)¡­¡­ ·½·¨¶þ ͨ¹ýPowerDesigner´ÓÏÖÓÐÊý¾Ý¿âµ¼³öPDM£¨Physical Data Model£©Í¼£¬È»ºó½èÖúÁíÒ»¸öС¹¤¾ßPdmReader£¨¿É´Óhttp://www.pdmreader.com/ÏÂÔØ£©À´·ÖÎöPDMͼ£¬È»ºóÉú³É˵Ã÷Îĵµ¡£ ÏÂÃæËµÒ»Ï¾ßÌå²½Ö裺 µÚÒ»²¿·Ö£ºÍ¨¹ýPowerDesignerÉú³ÉPDMͼ¡£ 1¡¢´ò¿ªPowerDesigner£¬Ñ¡Ôñ¡°Îļþ¡±²Ëµ¥Öеġ°Reverse Engineer¡± £¬ÔÙÑ¡Ôñ¡°DataBase¡±£»
2¡¢ÔÚµ¯³öµÄ¶Ô»°¿òÖÐÊäÈ뽫Ҫ´´½¨µÄPDMÎļþµÄÃû×Ö£¬²¢ÔÚDBMSÑ¡ÏîÖÐÑ¡Ôñ½«ÒªÁ¬½ÓµÄÊý¾Ý¿âµÄÀàÐͺóµã»÷OK£» 3¡¢ÔÚDatabase Reverse Engineering Options»­ÃæµÄselection±êÇ©ÏÂÑ¡Ôñ¡°Using a data


Ïà¹ØÎĵµ£º

MS SQL ServerÈÕÆÚ¼ÆËã

ͨ³££¬ÄãÐèÒª»ñµÃµ±Ç°ÈÕÆÚºÍ¼ÆËãһЩÆäËûµÄÈÕÆÚ£¬ÀýÈ磬ÄãµÄ³ÌÐò¿ÉÄÜÐèÒªÅжÏÒ»¸öÔµĵÚÒ»Ìì»òÕß×îºóÒ»Ìì¡£ÄãÃǴ󲿷ÖÈË´ó¸Å¶¼ÖªµÀÔõÑù°ÑÈÕÆÚ½øÐзָÄê¡¢Ô¡¢Èյȣ©£¬È»ºó½ö½öÓ÷ָî³öÀ´µÄÄê¡¢Ô¡¢ÈյȷÅÔÚ¼¸¸öº¯ÊýÖмÆËã³ö×Ô¼ºËùÐèÒªµÄÈÕÆÚ£¡ÔÚÕâÆªÎÄÕÂÀÎÒ½«¸æËßÄãÈçºÎʹÓÃDATEADDºÍ DATEDIFFº¯ÊýÀ´¼ÆËã³öÔÚÄãµÄ³ÌÐò ......

SQL Server 2005 ¾µÏñ¹¦ÄÜʵÏÖ

SQL Server 2005 ¾µÏñ¹¦ÄÜʵÏÖ
1. Ö÷»ú¡¢¾µÏñ·Ö±ðMASTER KEY¡£
Ö÷»úÖ´ÐУº 
USE master;  
  
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password';  
  
CREATE CERTIFICATE HOST_A_cert WITH  ......

Using Oracle Trace Analyzer (trcanlzr.sql)


Using Oracle Trace Analyzer (trcanlzr.sql)
Dave Moore:  Author of Oracle Utilities
Oracle has provided another utility initially designed for performance tuning Oracle Applications.  Trace Analyzer is provided in the form of a PL/SQL package (TRCA$ ).  The Trace Analyzer utility i ......

SQLµ÷Õû×î¹Ø×¢µÄÊÇʲô£¿

µ÷ÕûµÄÄ¿µÄ¾ÍÊÇΪÁËÏûºÄ×îСµÄ×ÊÔ´À´Íê³É¹¦ÄÜ£¬Í¨¹ý²é¿´Ö´Ðмƻ®ºÍ¸÷ÖÖͳ¼ÆÐÅÏ¢À´·Ö±æµ÷ÕûºóµÄsql¶Ô×ÊÔ´µÄºÄ·ÑÇé¿ö£¬À´ÕÒ³öÒ»¸ö³É±¾×îСµÄsqlÓï¾ä
¼ì²éϵͳµÄI/OÎÊÌâ
vmstateÄܼì²éÕû¸öϵͳµÄiostat£¨IO statistics£©
²é¿´¸ÃSQLµÄresponse time(db block gets/consistent gets/physical reads/sorts (disk)) ......

SQL ServerÊÓͼÖг£見ÏÞÖÆÌõ¼þ

--> Title  : SQL ServerÊÓͼÖг£見ÏÞÖÆÌõ¼þ
--> Author : wufeng4552
--> Date   : 2010-03-01
(1): ÊÓͼÊý¾Ý¸ü¸ÄµÄ³£見ÏÞ¶¨
µ±Óû§¸üÐÂÊÓͼÖеÄÊý¾Ýʱ,Æäʵ¸ü¸ÄµÄÊÇÆä¶ÔÓ¦µÄÊý¾Ý±íµÄÊý¾Ý.ÎÞÂÛÊǶÔÊÓͼÖеÄÊý¾Ý½øÐиü¸Ä,»¹ÊÇÔÚÊÓͼÖвåÈë»òÕßɾ³ýÊý¾Ý,¶¼ÊÇÀàËÆµÄµÀÀí.µ«ÊÇ,² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ