How to save only the tel and address and put in another PC without the transaction?
Can you explain better I am not sure what your asking. Telephone and address of what? And what are we putting into another PC and where and why?
I want to save only the database of telephone and address and put it in another PC without all transaction .
Do you want to keep your products as well? If so, there is a task/script that will delete all transactions.
Otherwise, you need to Export the Entities table from the DB, and import that same table into the DB on the other computer.
OK i am going to attempt to read between the lines here because your still not providing much information at all. I am going to assume you mean you want to save the telphone numbers and addresses of your customers and transfer those customers with thier telephone numbers and addresses to that pc…are you saying another pc with Samba or just a txt file or something?
1 Like
another pc with sambapos 0 transaction.
Ok so just backup the database and restore it to the new pc then go to database tools and clear all transactions. If you do not have database tools here is the script. You can run it in MSSMS. I highly recommend you getting Database Tools module its well worth it.
DELETE FROM [TicketEntities]
GO
DELETE FROM [Tickets]
GO
DELETE FROM [AccountTransactionDocuments]
GO
DELETE FROM [AccountTransactions]
GO
DELETE FROM [AccountTransactionValues]
GO
DELETE FROM [Calculations]
GO
DELETE FROM [CostItems]
GO
DELETE FROM [InventoryTransactionDocuments]
GO
DELETE FROM [InventoryTransactions]
GO
DELETE FROM [Orders]
GO
DELETE FROM [PaidItems]
GO
DELETE FROM [PeriodicConsumptionItems]
GO
DELETE FROM [PeriodicConsumptions]
GO
DELETE FROM [ProductTimerValues]
GO
DELETE FROM [Payments]
GO
DELETE FROM [WarehouseConsumptions]
GO
DELETE FROM [WorkPeriods]
GO
DELETE FROM [EntityStateLogs]
GO
UPDATE [Numerators] SET Number = 0
GO
UPDATE [EntityStateValues] SET EntityStates = '[{"S":"Available","SN":"Status"}]' Where EntityStates like '%Status%'
GO
Or if you do not want products etc transferred then you would need to just copy the Entities tables from database like @QMcKay recommended
Or you could simply look at them from pc a and then manually create them in pc b. I am not a fan of that method 
PS. your still not giving us much info to go on. We are still having to guess at what you are meaning or wanting. We are having to prod the info out of you. If you could give us more detailed information to work with we might be able to give you a better answer.
1 Like
You means using SQL Server Management Studio? and use this script?
If you own Database Tools module you can use that to run it. If you do not have that module then yes MSSMS = Microsoft SQL Server Management Studio.
PS. To use that script you have to select the database you want it ran on because it does not have it defined.
You are right , copy the database and clear all transaction is much easier…but i don´t have database tools.
Database Tools includes this script and will run it for you from within SambaPOS but you can easily just select your database in MSSMS and run it there by pasting that in a query and executing it with F5
i don´t know how to buy the database tools, i am from argentina.
They accept PayPal but its www.sambamarket.com you go there and register an account then login and purchase it… when you start sambapos go to Manage > Samba Market then upper right corner login with the account you just made and choose install and activate.
this database tools will work for later version od sambapos?
Yes. it will work. But just to be sure we are talking about sambapos 4? If your using sambapos 2 or 3 then no they will not work.
i taking about next version v5, do you think this will work?
Yes it works I use it everyday with v5. It will be built into v5. Database Tools and Database Backup were the two best investments i made. I use both daily.