On Wed, Apr 1, 2009 at 9:14 PM, Drew Baird (Volt) <[email protected]>wrote:
> Hi Harold, > One way to do this is use the "setupActions" [1], a C# program from the > dotnet tree that will setup run the scripts in the correct order to create > the database. Hi Drew, > Then all you need to do is run the two scripts in the phpStockTrader to > create the additional config system. This is in described in the file [2]. > There is document will be improved soon. One edit between the * * that I > intend to add in the next few days. > > > Seed the database and create accounts > a. In the directory: C:\StockTraderDemo\Setup\SetupActions \bin\debug > b. Edit the SetupActions.exe.config file to set the right "dbPassword" > for the sa account. > c. dbserver is set to ".\MSQLServer " If you use SQLExpress or > *another MSSQL Instance* it will be different. > d. From a console run SetupActions.exe (with elevated privilege - i.e. > run as admin) > > > > Hope this helps > Drew > [1] > http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/SetupActions/ > [2] > http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/ReadMe.mht?view=markup > > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Wednesday, April 01, 2009 8:00 AM > To: [email protected] > Subject: How to create and populate DB > > Hello all, > > The Metro interns' current plan is: > > 1. create and populate tables in MSSQL > (independent of any .NET, PHP or Java StockTrader versions) > > 2. OPTIONAL: Install and run Java/PHP versions > (this depends on if there is a detailed and known accurate guide) > > 3. OPTIONAL: Install and run .NET version > (this depends on a detailed and accurate guide) > > 4. Create Metro-based stocktrader from existing WSDLs > > --------- > > We need help on #1 since neither the interns nor myself know SQL (or > MSSQL in particular). > > It seems that we first need to create the DB tables by running: > > contrib/stocktrader/dotnet/Setup/DataLoad/createdb.sql > > Followed up with populating those tables by running: > > contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLAccountProc.sql > ... > > which uses initial data from: > > contrib/stocktrader/dotnet/Setup/StockTraderDB/Account.xml ... > > Could someone let us know how to do this, either from the command line > (preferred) or a GUI tool? > > In particular, it's not clear how the connection is made between > DataLoad/CreateInsertXML*.sql and the corresponding data files > StockTraderDB/*.xml > > Thanks, > Harold >
