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. 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
