English Boards > Support

database locations

(1/4) > >>

jenem:
Hi All,

I wonder if someone can give me some advice on resetting test receipts.
I downloaded emres's script and it seemed to run ok. when I checked sambapos there were still some data there.
Do different sambapos databases exist for different  users ?
ie in my case two. admin and user

Should the script be run as admin

I run as a limited user most times and sometime switch to admin for some tasks.



Edgar

JohnS:
Edgar,


--- Quote from: jenem on February 06, 2012, 04:58:43 am ---I wonder if someone can give me some advice on resetting test receipts.
I downloaded emres's script and it seemed to run ok. when I checked sambapos there were still some data there.

--- End quote ---
Which script?


--- Quote from: jenem on February 06, 2012, 04:58:43 am ---Do different sambapos databases exist for different  users ?
ie in my case two. admin and user

--- End quote ---
No.

What SQL Server are you using?

jenem:
Hi John,

I checked,  SQLCE databases are stored under each user. I have two.

Script used found here

http://forum2.sambapos.org/index.php/topic,60.msg251.html#msg251

Edgar

Addition screenshot

JohnS:
SQLCE databases are not designed for multiple computer/user use. Due to its structure, it is only suited to a single user.
SQL Express handles multiple users across multiple computers - a real networked solution.

If you log into your computer under two different logins, then yes you will have two SQLCE databases.

I re-wrote a SQL Express script based on Emre's dtran script, and it works well. The script removes all transactional data, leaving all products, actions, rules, menus, etc.

If you think you will need multiple concurrent access to the database, then install SQL Express 2008. This is a good guide http://doc.sambapos.org/doku.php/tr/dbase/sql_server_2008_express_edition_nasil_kurulur

jenem:
Hi John,

At the moment I am still waiting for the go ahead from my brother and I'm not sure what he wants he only needs one user access.

I may install onto a server at home for practice.

I wonder if I can manually remove transaction data prior to installation on my brothers setup or would I use emre's script?

Edgar

Navigation

[0] Message Index

[#] Next page