Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread convert tables to database
Sat, Nov 7 2015 5:12 AMPermanent 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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 AMPermanent Link

Raul

Team Elevate 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 PMPermanent 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.
Image