Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 4 of 4 total |
convert tables to database |
Sat, Nov 7 2015 5:12 AM | Permanent Link |
Salvatore Panaro Panaro | I always used the DBISAM with direct access to the tables , I would like to convert them for database client / server can someone help me with this process ? thank you |
Sat, Nov 7 2015 10:09 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Salvatore
Check out the "Configuring and Starting the Server" section in the pdf manual When you have the server operating its just a matter of dropping a session component on to your app and setting the various remote properties for it. Essentially that alters your application to use c/s. However, if you want to do it fully it probably will need some work converting parts of the application to use queries rather than tables. Roy Lambert |
Sat, Nov 7 2015 11:53 AM | Permanent Link |
Raul Team Elevate | On 11/7/2015 5:12 AM, Salvatore Panaro Panaro wrote:
> I always used the DBISAM with direct access to the tables , I would like to convert them for database client / server can someone help me with this process ? thank you Just to add few thing to what Roy said : - You do not need to convert or change the data in any way - the exact same tables continue to work - You will need to run dbsrvr (server part of C/S) and then use server admin tool to create a database (it's basically a reference to folder) and any users you want (you need 1 user to start off - you could use admin account but i suggest start with separate user account from beginning - often people use single built-in user for dbsrvr login and then manage application users themselves in their app) - at this point you should be able to use dbsys to open remote table or remote query to test all of this out (in terms of getting access to data etc) - rest is really just about using "remote" session in your app and also any design changes Roy mentioned (optimizing data access might be needed) but we've found C/S model to be way superior for multiple user scenarios (especially since file share access in modern windows os's seems to have deteriorated quite a bit) - i don't think there is a nice "walk-thru" in manual for setting this up but i'd start with architecture section : http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphiwin32&version=10S&topic=DBISAM_Architecture Other useful ones : "Configuring and Starting the Server" - for now the relevant parts are in "Default Login Information" section and after for now "Server Administration" is of interest but this is actually what the srvadmin utility does for you (docs are useful to understand command and/or if you were to write your own admin tool) "Customizing the Engine" is useful if you need triggers and server side processing. Raul |
Sun, Nov 8 2015 4:28 PM | Permanent Link |
Salvatore Panaro Panaro | Raul wrote:
On 11/7/2015 5:12 AM, Salvatore Panaro Panaro wrote: > I always used the DBISAM with direct access to the tables , I would like to convert them for database client / server can someone help me with this process ? thank you Just to add few thing to what Roy said : - You do not need to convert or change the data in any way - the exact same tables continue to work - You will need to run dbsrvr (server part of C/S) and then use server admin tool to create a database (it's basically a reference to folder) and any users you want (you need 1 user to start off - you could use admin account but i suggest start with separate user account from beginning - often people use single built-in user for dbsrvr login and then manage application users themselves in their app) - at this point you should be able to use dbsys to open remote table or remote query to test all of this out (in terms of getting access to data etc) - rest is really just about using "remote" session in your app and also any design changes Roy mentioned (optimizing data access might be needed) but we've found C/S model to be way superior for multiple user scenarios (especially since file share access in modern windows os's seems to have deteriorated quite a bit) - i don't think there is a nice "walk-thru" in manual for setting this up but i'd start with architecture section : http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphiwin32&version=10S&topic=DBISAM_Architecture Other useful ones : "Configuring and Starting the Server" - for now the relevant parts are in "Default Login Information" section and after for now "Server Administration" is of interest but this is actually what the srvadmin utility does for you (docs are useful to understand command and/or if you were to write your own admin tool) "Customizing the Engine" is useful if you need triggers and server side processing. Raul Thank you for the help I'll do what they said. |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |