Hi Harold, This may not directly answer the question about "What is the purpose of:"...
I believe you can ignore them until you need to interop with the dotnet. Those 'config' scripts are used by the MSDN StockTrader setup MSI. I have pretty much ignored them. There was a config service in the MSDN version that was NOT contributed. I will be looking at the detail and see if they are needed in the next few days. You can use the MSI from the StockTrader at the Microsoft site (if you want ) to setup the Database . At this point I am not sure it has the last three tables I need to interop the WSF/PHP stack with the dotnet stack. But I am personally working that issue. Thanks! Drew -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Thursday, March 19, 2009 10:50 AM To: [email protected] Subject: DB table creation and population Hello all: Question: Is it possible to create and populate all the tables of the stocktrader demo without running any of the Java, PHP or .NET code? If so, then please supply step-by-step instructions. The following is what we have guessed so far by looking at the code and docs. There are 5 tables with specific fields as documented in: contrib/stocktrader/documents/BusinessServiceFunctionality.doc The script: contrib/stocktrader/dotnet/Setup/DataLoad/createdb.sql seems to create those 5 tables. The scripts: contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLAccountProc.sql contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLAccountProfileProc.sql contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLHoldingProc.sql contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLOrdersProc.sql contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLQuoteProc.sql and the data files: contrib/stocktrader/dotnet/Setup/StockTraderDB/Account.xml contrib/stocktrader/dotnet/Setup/StockTraderDB/AccountProfile.xml contrib/stocktrader/dotnet/Setup/StockTraderDB/Holding.xml contrib/stocktrader/dotnet/Setup/StockTraderDB/Orders.xml contrib/stocktrader/dotnet/Setup/StockTraderDB/Quote.xml seem to initialize the tables with pseudo data. Is that correct? Is it possible to run the above independent of the services? Is the above all that is necessary to start running the WSAS and PHP versions as shown in: http://cwiki.apache.org/confluence/display/STONEHENGE/Stonehenge+PHP+and+WSAS+Stocktrader+Installation+Guide What is the purpose of: contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLConfigurationKeysProc.sql contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLConnectedConfigServicesProc.sql contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLConnectedServicesProc.sql contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLHostedServicesProc.sql contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLServiceHostsProc.sql contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLUserProc.sql Can we safely ignore them if we are not running the .NET version? We want to get the database tables created and populated and them build a Metro-based services and clients (and perhaps install/run the WSAS/PHP versions). But there just isn't enough documentation to understand how to proceed. Thanks, Harold
