Hi Drew, In http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/SetupActions/ , we have "*SetupAction.cs* " and "*SetupActions.csproj ". *
The code, "SetupActions.csproj" seems to be compiling "SetupAction.cs" along with other files. And "SetupActions.cs" is the one that is creating the database and populating them with initial values. So,I infer that we have to run "SetupActions.csproj". Am I correct? Or do we have to run "SetupActions.cs"? Regards, Ranjitha On Thu, Apr 2, 2009 at 10:27 PM, Drew Baird (Volt) <[email protected]>wrote: > Hi Ranjitha, > > You should set this to whatever 'instance' you want to Use to use. On my > system I use ./MSSQLSERVER, Often if you only have one instance on your > MSSQL installation can simply use "." I have three different flavors of > MSSQL running on my machine. The readme says "dbserver is set to > ".\MSQLServer " If you use SQLExpress it will be different." I will update > the readme to be more clear on this. > > Use whatever instance you want as long as it is installed. Of course you > want to be consistent. > > From MSDN: "The default installation of SQL Server 2005 Express Edition > uses an instance name of SQLEXPRESS." So if that is your case then > substitute SQLEXPRESS. > > Hope This helps. > Here is more on MSSQL instances. > > http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/68a3c394-b120-48ce-9f50-819a5dd4c129/ > > Best, > Drew > > > > > -----Original Message----- > From: Ranjitha V [mailto:[email protected]] > Sent: Thursday, April 02, 2009 8:08 AM > To: [email protected] > Subject: Re: How to create and populate DB > > Hi Drew, > > You have mentioned this in your first reply to Harold. > > c. dbserver is set to ".\MSQLServer " If you use SQLExpress or *another > MSSQL Instance* it will be different. > > I have posted this question once before. My server is set to SQLEXPRESS and > not to > MSSQLSERVER (as required). This is also mentioned in the wiki > > > http://cwiki.apache.org/confluence/display/STONEHENGE/Stonehenge+PHP+and+WSAS+Stocktrader+Installation+Guide > > > My question is simple. Can I continue with creation and population of > database with the SQLEXPRESS running. > Or is it imperative that I need to have the MSSQLSERVER running. If > possible, can you clarify the difference between > the two? > > Regards, > Ranjitha > > > On Thu, Apr 2, 2009 at 7:18 PM, Drew Baird (Volt) <[email protected] > >wrote: > > > HI Vineet, > > It is hard to tell what you need because of the way the replies are > > interwoven. > > I think you said "> There are a number of "SetupActions" in the link. > > Can pls tell me specifically which one??. > > > > The Link: > > > http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/SetupActions/ > > > > This is a C# solution and project. When the C# program is compiled it > will > > run the script in setupActions.cs. If you don't want to use dotnet/C# you > > can read the code and see what it does. Here is where the paths are > defined. > > string CREATE_LOADACCOUNTPROFILEXML = > > @"Setup\DATALOAD\CreateInsertXMLAccountProfileProc.sql"; > > string CREATE_LOADACCOUNTXML = > > @"Setup\DATALOAD\CreateInsertXMLAccountProc.sql"; > > string CREATE_LOADHOLDINGXML = > > @"Setup\DATALOAD\CreateInsertXMLHoldingProc.sql"; > > string CREATE_LOADORDERSXML = > > @"Setup\DATALOAD\CreateInsertXMLOrdersProc.sql"; > > string CREATE_LOADQUOTEXML = > > @"Setup\DATALOAD\CreateInsertXMLQuoteProc.sql"; > > > > So it looks like 5 scripts above physically exist in : > > > http://svn.apache.org/viewvc/incubator/stonehenge/trunk/stocktrader/dotnet/setup_utilities/DataLoad/ > > > > Hope this helps. You really need to read and understand the rest of the > > program to understand parameters and how to run the scripts manually. > > > > HTH > > Drew > > <Rest of mail snipped for clarity> >
