1. ERDC Knowledge Core
  2. Engineer Research and Development Center (ERDC)
  3. Information Technology Laboratory (ITL) - (1986 - present)
  4. Publication
  5. Special Report
Please use this identifier to cite or link to this item: https://hdl.handle.net/11681/34153
Full metadata record
DC FieldValueLanguage
dc.contributor.authorSantiago Lugo, Abdías I.-
dc.contributor.authorMixon, Katherine E.-
dc.contributor.authorBednar, Amy E.-
dc.contributor.authorWhite, Barry C.-
dc.date.accessioned2019-09-23T14:41:16Z-
dc.date.available2019-09-23T14:41:16Z-
dc.date.issued2019-09-
dc.identifier.govdocERDC/ITL SR-19-17-
dc.identifier.urihttps://hdl.handle.net/11681/34153-
dc.identifier.urihttp://dx.doi.org/10.21079/11681/34153-
dc.descriptionSpecial Report-
dc.description.abstractThe Planning Logistics Analysis Network System (PLANS) team needed a repeatable process for setting up an accessible local database for development using the .mdf database file format on developers’ machines. Online sources for this procedure are available, but they must be adapted due to security restrictions imposed by the Engineer Research and Development Center-Defense Research and Engineering Network (ERDC-DREN). Access to the server’s database is restricted, requiring copies of the database files to be handled directly, rather than through web-based database calls. This special report provides step-by-step instructions for setting up a local development database using the .mdf database file format on computers on the ERDC-DREN networken_US
dc.description.sponsorshipUnited States. Army. Corps of Engineers.en_US
dc.description.tableofcontentsAbstract ..................................................................................................................................................... ii Figures ..................................................................................................................................................... iv Preface ...................................................................................................................................................... v Acronyms and Abbreviations .................................................................................................................. vi 1 Introduction ...................................................................................................................................... 1 1.1 Background ..................................................................................................................... 1 1.2 Objectives ........................................................................................................................ 1 1.3 Approach ......................................................................................................................... 1 1.4 Scope ............................................................................................................................... 2 2 Installing SQL Server Software ....................................................................................................... 3 2.1 Step 1: download SQL server ......................................................................................... 3 2.2 Step 2: install and setup SQL Server ............................................................................. 3 3 Installing SQL Server Management Studio (SSMS) ....................................................................... 6 3.1 Step 1: download SQL Server Management Studio (SSMS) ........................................ 6 3.2 Step 2: install SMSS ....................................................................................................... 6 4 Setting Up a Database Using the Structured Query Language Command Prompt (SQLCMD) ............... 7 4.1 Step 1: administrator command prompt (CMD) ............................................................ 7 4.2 Step 2: SQLCMD prompt ................................................................................................ 7 4.3 Step 3: verify server version ........................................................................................... 8 4.4 Step 4: create new database ......................................................................................... 8 4.5 Step 5: verify new database ........................................................................................... 9 4.6 Step 6: exit SQLCMD ....................................................................................................... 9 5 Viewing the Database in Microsoft SQL Server Management Studio ........................................ 10 5.1 Step 1: server name ..................................................................................................... 10 5.2 Step 2: verify database ................................................................................................. 10 5.3 Step 3: verify database permissions ........................................................................... 10 6 Accessing the Database from Visual Studio ................................................................................ 11 6.1 Step 1: create new connection .................................................................................... 11 6.2 Step 2: choose data source ......................................................................................... 11 6.3 Step 3: server information ........................................................................................... 11 6.4 Step 4: add connection string ...................................................................................... 12 7 Conclusion...................................................................................................................................... 14 References............................................................................................................................................. 15 Report Documentation Page-
dc.format.extent24 pages / 1.730 Mb-
dc.format.mediumPDF-
dc.language.isoen_USen_US
dc.publisherInformation Technology Laboratory (U.S.)en_US
dc.publisherEngineer Research and Development Center (U.S.)-
dc.relation.ispartofseriesSpecial Report (Engineer Research and Development Center (U.S.)) ; no. ERDC/ITL SR-19-17-
dc.rightsApproved for Public Release; Distribution is Unlimited-
dc.sourceThis Digital Resource was created in Microsoft Word and Adobe Acrobat-
dc.subjectElectronic information resourcesen_US
dc.subjectDatabase managementen_US
dc.subjectDatabasesen_US
dc.titleSetting up a local database from an existing .mdf fileen_US
dc.typeReporten_US
Appears in Collections:Special Report

Files in This Item:
File Description SizeFormat 
ERDC-ITL SR-19-17.pdf1.77 MBAdobe PDFThumbnail
View/Open
Show simple item record