µ±Ç°Î»ÖãºÊ×Ò³ > UMLʵÑéÖ¸µ¼ - ͼÎÄ
ͼ6-2 Ñ¡ÔñDataModeler/New/Schema
´Ëʱ˫»÷<
ͼ6-3 ÔÚDatabaseÖÐÑ¡ÔñTestDB
4£®ÓÒ¼üµ¥»÷LogicalÊÓͼ£»
5£®Ñ¡ÔñNew/Package´´½¨°üDemo£»
6£®ÔÚDemoÖд´½¨Á½¸öÀ࣬TeacherºÍStudent¡£ÆäÖÐTeacherÀà°üº¬name£¬telephone£¬age
ÊôÐÔ(Attributes)£¬ÆäÖÐnameºÍtelephoneΪstringÀàÐÍ£¬ageΪInteger¡£Student°üº¬name£¬sex£¬classÊôÐÔ£¬¾ùΪstringÀàÐÍ£»
×¢Ò⣺±ØÐëÔÚÁ½¸öÀàµÄClass Specificationµ¯³ö¿òÖеÄDetailÑ¡ÏîÖÐÑ¡ÖÐPersisten£¬¼´×ª»»
Ϊ³Ö¾ÃÀà¡££¨Èçͼ£¬Ë«»÷Ààͼ±ãµ¯³öClass Specification¿ò£©£»
ͼ6-4 ת»»Îª³Ö¾ÃÀà
7£®ÓÒ¼üµ¥»÷°üDemo£¬Ñ¡ÔñDataModeler/Transform to DataModel¡£»
8£®ÔÚµ¯³ö¿òÖеÄDestination SchemaÖÐÑ¡ÖÐS_1,ÔÚTarget DatabaseÖÐÑ¡ÖÐTestDB£¬µ¥»÷
OK£» ÕâʱÔÚSchemasϵÄ<
ͼ6-5 Éú³ÉÁ½¸ö±í
9£®ÔÚSQL Server2000Öд´½¨Ò»¸öеÄÊý¾Ý¿â£¬ÃüÃûΪTestDB£¬´ý»á½«»á½«ÉÏÃæÉú³ÉµÄ
Á½¸ö±íµ¼Èëµ½¸ÃÊý¾Ý¿âÖУ»
10£®ÓÒ¼üµ¥»÷<
11£®ÔÚµ¯³ö¿òÖе¥»÷Á½´Înextºó£¬ÔÚгöÏֵĶԻ°¿òÖÐÑ¡ÖÐExcute£¬È»ºóµ¥»÷Test
Connection£¬Èç¹ûµ¯³ö³É¹¦±êÖ¾ÔòÁ¬½Ó¿ÉÓã¨Èçͼ6-6£©£»
ͼ9-6 Test Connection²âÊԳɹ¦
12£®ÔÚUser Name£¬PassWordÖÐÌîÈëÄãµÄSQL ServerµÄÓû§ÃûºÍÃÜÂ루һ°ãΪadminºÍ
admin£©£¬ÔÚServerÖÐÌîÈë¡°.¡±£¬ÔÚDatabaseÖÐÑ¡Ôñ¸Õ¸Õ½¨Á¢µÄTestDB£¬µ¥»÷Next£>Finish,±ãÍê³ÉÁËÕýÏò¹¤³Ì£»
ÕâʱÔÚSQL ServerÖеÄTestDBÊý¾Ý¿âÖÐÉú³ÉÁËÁ½¸ö±í£¬¿É²é¿´Í¼(6-7)¡£
ͼ6-7 Êý¾Ý¿âÖеÄÁ½¸ö±í
¹²·ÖÏí92ƪÏà¹ØÎĵµ