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
Ïà¹ØÎĵµ£º
ͨ³££¬ÄãÐèÒª»ñµÃµ±Ç°ÈÕÆÚºÍ¼ÆËãһЩÆäËûµÄÈÕÆÚ£¬ÀýÈ磬ÄãµÄ³ÌÐò¿ÉÄÜÐèÒªÅжÏÒ»¸öÔµĵÚÒ»Ìì»òÕß×îºóÒ»Ìì¡£ÄãÃǴ󲿷ÖÈË´ó¸Å¶¼ÖªµÀÔõÑù°ÑÈÕÆÚ½øÐзָÄê¡¢Ô¡¢Èյȣ©£¬È»ºó½ö½öÓ÷ָî³öÀ´µÄÄê¡¢Ô¡¢ÈյȷÅÔÚ¼¸¸öº¯ÊýÖмÆËã³ö×Ô¼ºËùÐèÒªµÄÈÕÆÚ£¡ÔÚÕâÆªÎÄÕÂÀÎÒ½«¸æËßÄãÈçºÎʹÓÃDATEADDºÍ DATEDIFFº¯ÊýÀ´¼ÆËã³öÔÚÄãµÄ³ÌÐò ......
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)
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Óï¾ä
¼ì²éϵͳµÄI/OÎÊÌâ
vmstateÄܼì²éÕû¸öϵͳµÄiostat£¨IO statistics£©
²é¿´¸ÃSQLµÄresponse time(db block gets/consistent gets/physical reads/sorts (disk)) ......
--> Title : SQL ServerÊÓͼÖг£見ÏÞÖÆÌõ¼þ
--> Author : wufeng4552
--> Date : 2010-03-01
(1): ÊÓͼÊý¾Ý¸ü¸ÄµÄ³£見ÏÞ¶¨
µ±Óû§¸üÐÂÊÓͼÖеÄÊý¾Ýʱ,Æäʵ¸ü¸ÄµÄÊÇÆä¶ÔÓ¦µÄÊý¾Ý±íµÄÊý¾Ý.ÎÞÂÛÊǶÔÊÓͼÖеÄÊý¾Ý½øÐиü¸Ä,»¹ÊÇÔÚÊÓͼÖвåÈë»òÕßɾ³ýÊý¾Ý,¶¼ÊÇÀàËÆµÄµÀÀí.µ«ÊÇ,² ......