Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

SQL ServerÖÐcaseµÄÓ÷¨

µÚÒ»ÖÖÓ÷¨£º
SELECT (CASE type WHEN 'u' THEN 'Óû§±í' WHEN 's' THEN 'ϵͳ±í' ELSE 'ÆäËû' END) AS TABLEKIND,* from SYSOBJECTS
µÚ¶þÖÐÓ÷¨£º
SELECT (CASE WHEN crdate<'2006-01-01' THEN 'early' WHEN crdate<'2009-01-01' THEN 'nearly' ELSE 'now' END) AS PERIOD,* from SYSOBJECTS ......

How do I release sql express database?


Questions
I have a simple app that
uses an SQL Express 2005 database. When the user closes the app, I want
to give the option to back up the database by making a copy in another
directory. However, when I try to do it, I get "The process cannot
access the file '...\Pricing.MDF' because i ......

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

--> Title  : SQL ServerÊÓͼÖг£見ÏÞÖÆÌõ¼þ
--> Author : wufeng4552
--> Date   : 2010-03-01
(1): ÊÓͼÊý¾Ý¸ü¸ÄµÄ³£見ÏÞ¶¨
µ±Óû§¸üÐÂÊÓͼÖеÄÊý¾Ýʱ,Æäʵ¸ü¸ÄµÄÊÇÆä¶ÔÓ¦µÄÊý¾Ý±íµÄÊý¾Ý.ÎÞÂÛÊǶÔÊÓͼÖеÄÊý¾Ý½øÐиü¸Ä,»¹ÊÇÔÚÊÓͼÖвåÈë»òÕßɾ³ýÊý¾Ý,¶¼ÊÇÀàËÆµÄµÀÀí.µ«ÊÇ,² ......

(Microsoft SQL Server£¬´íÎó: 3219)

MSSQL»¹Ô­Êý¾Ý¿âʧ°Ü£¬ÌáʾÈçÏ£º »¹Ô­¶ÔÓë·þÎñÆ÷ ʧ°Ü¡£(Microsoft.SqlServer.Smo) ÆäËüÐÅÏ¢£º ©§ ©»¡úÖ´ÐÐTransact-SQLÓï¾ä»òÅú´¦Àíʱ·¢ÉúÒì³£¡££¨Microsoft.SqlServer.ConnectionsInfo£© ©§ ©»¡ú²»ÄÜÑ¡ÔñÎļþ»òÎļþ×é¡°¡­¡­¡±ÓÃÓڴ˲Ù×÷¡£ RESTORE DATABASE ÕýÔÚÒì³£ÖÕÖ¹¡££¨Microsoft SQL Server, ´íÎó£º3219£© ³öÏÖ´Ë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ