I have a small app developed whcih I now want to deploy to another inhouse machine, just to see what's involved

I gather that I must copy the Microfour assemblies, my Business Object Assmbly and the .exe but am unsure where to locate the Microfour assemblies. Are there any other files that I need to copy ?

I see there are Startaframe files in a folder called c:\windows\assembly (but these do not have a .DLL extension). There are also Strataframe files in a folder called: c:\ProgramFiles\CommonFiles\Microfour\Strataframe (which do have a .DLL extension). Is one of these folders the correct place to get the Microfour assembly that I need to distribute with the App ?

At this stage I want to just copy the required files to the other machine.( if thats possible)  I realise on a live install this may not be the way to go ,but at this stage, I want to do all this stuff manually, more to get an understanding of what goes on under the hood

I have copied the app to another pc (happens to be a server) and have run it from the server.

It asked me for the server name and database name and I input the details and it works fine from new machine(i.e server)

Hoever , if I set up a mapping on my development machine to the server folder , run the app from the server, it points back to the database on my development machine , rather than the server sql server

Where/how  do I change the connection string so that I can run the app thats sitting on the server now,  from my pc,  but look at the sql server database thats on the server.Is this held in a table somewhere that I can amend or do I have to manage this programatically

An MSM file is a pre-built collection or installation that can be added wholesale to an MSI installation. I will admit though, it is generally better to add the files individually as MSM add-ins can cause issues in certain environments.







You will want to look at the documentation regarding the Connection String Manager as you can call the ConnectionManager.ShowAvailableConnectionString() to add new connection strings for an application allowing you to swap between development and production. This ties into the Connections.dat and the AppKeys.dat. All of this is in the docs and will provide more detail than I can supply here.

Ok . I have read docs and done some experimenting with ShowAvailableConnectionStrings() and SetConnections() and can change from one database to another on a form, by selecting a different Application Tilte. I still am a little bit hazy and would appreciate some guidance.

I am just starting to design the tables that go into the databases and an option is to end up with 3 different databases in the same Sql Server which will be used throughout the application. Fot the one application title, I have not been able to set up more than one database using ShowAvailableConnectionStrings.If I edit the the Application Settings, I seem to be just able to insert ONE database, whereas my application will be using 3. I can 'Select' just One application setting . In that my application is using 3 Databses, I would have epected to be able to 'Select' 3 items. Is it possible to do this or maybe I am barking up the wrong tree ?

Also, is there a way to easily change from Production to Live if I have 3 databases in the one application. I have manged to do this ok with one database by using ShowAvailableConnectionStrings()