外文翻译--sql伺候器数据库

《外文翻译--sql伺候器数据库》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、外文原文HaveyoueverhadtodeployaSQLServerdatabasetoacustomer?Ifyouhave,thenyouwillknowthatitiscertainlynotassimpleasdeployinganapplicationthatusesanMSAccessdatabase.WithSQLServerdatabases,youhave3deploymentoptionsthatIknowof:1.Distributeyour.mdfand.ldffilestoyourcusto

2、merandattachthedatabasetotheirSQLServerinstanceusingthesystemstoredproceduresp_attach_db(orsp_attach_single_file_db).ThedownsideisthattheSQLServermustresideonthesamemachineasthesetupapplication,whichisnotalwaysthecase.2.UseEnterpriseManagertogenerateyourdatabases

3、criptsandBCPtoexportallofyourdatatofilesandimportthembackinduringyoursetupprocess.3.ScriptoutyourentiredatabaseincludingSQLInsertstatementsforimportingdataintothedatabase.Withoptions2and3,youcandeployaSQLServerdatabaselocallyorremotely.Thisarticlefocusesonoptionn

4、umber3.BackgroundThereareanumberofcommercialprogramsthatwillscriptoutanentireSQLServerdatabaseforyou,butduetocurrentfinancialreasons,Icouldn'taffordtobuyoneandsoIhadtowritemyownprogramwhichonlytookafewdays.ThesourcecodeforthisarticleusestheSQLDMOlibraryextensivel

5、ytointerrogateaSQLServerdatabase.SQLDMOisaCOMlibraryandisinstalledwithSQLServer7/2000.(Note:thecodeforthisarticlewillonlyworkforSQLServer2000databases).Usingthecode(Seefigure1above)1.Whenyouruntheproject,entertheconnectioninformationforthedatabaseyouwouldliketoge

6、neratescriptsfor.2.Enteranexistingdirectoryfortheoutput.Asubdirectoryforthedatabasewillbeplacedintheoutputdirectory.Underneaththedatabasefolder,thereisanotherfolderwhichisusedtostorealloftheBLOBvaluesas.txtfilesforTextcolumns,or.datfilesforImagecolumns.3.Ifyoudon

7、otwanttogenerateSQLInsertscriptsforthedataintheselecteddatabase,thenclearthisoption.4.Pressthe[Generate]buttontostarttheprocess.Aprogressscreenwillbedisplayed.Pressthe[Cancel]buttonatanytimetocanceltheprocess.1.Afterthegenerationprocesshasfinished,browsetothedata

8、basefolderintheoutputdirectorytoseealistoffiles:osql.exeSQLutilitytosendbatchstatementstoaSQLServerinstancetextcopy.exeUnsupportedSQLutilityusedtocopy'text'and