sybase导出DDL语句以及ddlgen的描述.doc

《sybase导出DDL语句以及ddlgen的描述.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、sybase导出DDL语句以及ddlgen的描述工具路径：%sybase%/ASEP/bin注：%sybase%为客户端安装目录语法：ddlgen-Uusername-Ppassword-Sserver–Ddbname–Tobject_type–Nobject_name-T 数据库对象类型-N 对象名称（必须同-T 一起使用,缺省 –N%）例：导出test库中所有对象的ddl语句ddlgen-Uusername-Ppassword-Sserver–Dtest导出test库中test用户下所有以t开头的用户表的ddl语句ddlgen-Utest-Ppassword–Sapp77-Dtest

2、-TU-Nt%ddlgenDescriptionAJava-basedtoolthatgeneratesdefinitionsfor server-anddatabase-levelobjectsinAdaptiveServer. ddlgen supportsAdaptiveServer version11.9.2andlater.Thecommand-lineversionof ddlgen islocatedin $SYBASE/ASEP/bin (%SYBASE%ASEPbin in Windows).Syntaxddlgen-Ulogin-Ppassword-S[serve

3、r 

4、 host_name : port_number][-I interfaces_file][-Tobject_type][-Nobject_name][-Ddbname][-Xextended_object_type][-Ooutput_file][-Eerror_file][-Lprogress_log_file][-Jclient_charset]-F[%

5、SGM

6、GRP

7、USR

8、R

9、D

10、UDD

11、U

12、V

13、P

14、XP

15、I

16、RI

17、KC

18、TR

19、PC]Orddlgen-vParameters-U loginspecifiesaloginname,andiscase-sensitive.-

20、P passwordspecifiesyourpassword.-S[server 

21、 host_name : port_number]specifiesthenameoftheAdaptiveServer. ddlgen looksthisnameupintheinterfacesfileor LDAP configurationfile.Ifyouspecify:·-S[host_name:port_number]–ddlgen usesthe host_name and port_number provided,andneitherinterfacesnor LDAP config

22、urationfilesarereadorparsed.·-S[server]-I – ddlgen parsestheinterfacesfilespecifiedattheuserlocationfortheservername(seethe -I parameterdescriptionformoreinformation).·-S[server] –withoutspecifyinganinterfacesfile, ddlgen doesthefollowing:a.ddlgen firsttriestoreadthe LDAP configurationfilefromthe

23、standardlocationb.Ifthe LDAP filedoesnotexist,orexistsbutdoesnotcontainanAdaptiveServerentry,thentheinterfacesfileisparsedatitsstandardlocationfortheservernamec.Ifthe LDAP fileexists,then ddlgen usesittosearchtheservername.Theinterfacesfileisnotparsed,andthe LDAP configurationfileisparsed.Youmust

24、usethe -S optionbecause ddlgen doesnotconnecttoadefaultserver.-Ispecifiestheinterfacesfilename,andcorrespondsto $SYBASE/interfaces for UNIX,and %SYBASE%inisql.ini for Windows.Usethisoptionalparameterwith -S.-Tobject_