| | 1 | [[TracNav(TracNav/ISO15926HowTo)]] |
| | 2 | |
| | 3 | = Creating Practice Scripts for the Database = |
| | 4 | |
| | 5 | Status of this document: Working Draft |
| | 6 | |
| | 7 | This document is open for feedback, please post questions and comments in the forum at the bottom of this page. You will [WikiStart#Contactpoints need a login] to post in the forum. |
| | 8 | |
| | 9 | ---- |
| | 10 | |
| | 11 | [[PageOutline(2-4,Contents,inline)]] |
| | 12 | |
| | 13 | |
| | 14 | ---- |
| | 15 | |
| | 16 | == Practice Files == |
| | 17 | |
| | 18 | The first step is to get a description of the database columns involved in the exchange. In our example, we will assume that a database administrator in each of the three organizations gives you a SQL script that will create the tables at that organization, and another script to load a couple rows of sample data. |
| | 19 | |
| | 20 | We prefer scripts that create the tables, rather than CSV file or spreadsheet, because the column names are sometimes ambiguous and the data types and sizes give valuable clues. We want sample data for the same reason; when the column names are ambiguous, looking at some sample data will give a clue. We prefer the data dumps in the form of scripts that will create the data rows because we invariably need to create and delete test data many times. |
| | 21 | |
| | 22 | Assumption: That you know enough of SQL databases to read the scripts and data dumps. This will be necessary in the real world because you may have to build the database loading scripts from a printed data dump if the database cannot generate it for you. |
| | 23 | |
| | 24 | You will only need to download one set of files. We have provided the files in three forms, for Oracle, SQL Server, and SQL Server 2005 Express, because that is the systems the authors of this page used. |
| | 25 | |
| | 26 | '''3D design system database''' |
| | 27 | * attachment:3D_CreateTables_Ora.sql |
| | 28 | * attachment:3D_LoadTables_Ora.sql |
| | 29 | * attachment:3D_CreateTables_SS.sql |
| | 30 | * attachment:3D_LoadTables_SS.sql |
| | 31 | * attachment:3D_CreateTables_2K5.sql |
| | 32 | * attachment:3D_LoadTables_2K5.sql |
| | 33 | |
| | 34 | '''Owner Line List database''' |
| | 35 | * attachment:LL_CreateTables_Ora.sql |
| | 36 | * attachment:LL_LoadTables_Ora.sql |
| | 37 | * attachment:LL_CreateTables_SS.sql |
| | 38 | * attachment:LL_LoadTables_SS.sql |
| | 39 | * attachment:LL_CreateTables_2K5.sql |
| | 40 | * attachment:LL_LoadTables_2K5.sql |
| | 41 | |
| | 42 | '''Constructor Material Control database''' |
| | 43 | * attachment:MM_CreateTables_Ora.sql |
| | 44 | * attachment:MM_LoadTables_Ora.sql |
| | 45 | * attachment:MM_CreateTables_SS.sql |
| | 46 | * attachment:MM_LoadTables_SS.sql |
| | 47 | * attachment:MM_CreateTables_2K5.sql |
| | 48 | * attachment:MM_LoadTables_2K5.sql |
| | 49 | |
| | 50 | ---- |
| | 51 | |
| | 52 | == Back == |
| | 53 | |
| | 54 | * [wiki:ISO15926HowTo_Tutorial Back to Tutorials] |
| | 55 | |
| | 56 | |
| | 57 | |
| | 58 | ---- |
| | 59 | [[ViewTopic([Enter forum topic])]] |
