On Thu, Apr 2, 2009 at 1:56 PM, Vineet ghatge <[email protected]> wrote:
> > > 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, > > There are a number of "SetupActions" in the link.Can pls tell me > specifically which one??. > > with regard, > > vineet ghatge h > > > >> 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 >> > > >
