Moving Database and Sambapos licence to another Pc

[muthoga]

Last night we experienced a terrible power surge,this affected our server.I am told that the motherboard need to be replaced,however this is not readily available in the market.
We have opted to buy a new pc(server),i need to move the previous database hosted on the old pc to the new pc. I dont want to loose my Sambapos licence,i have read through the forum but i haven’t seen a defined way to do this.
i know many have experienced this kind of situation so kindly let me know how you handled it,thanks

Moving hardware

Hi all, My hardware is failing and I need to move my SambaPOS v4 data over to a new machine but I have no idea where to start! I currently have a Windows 7 embedded OS on hardware that is so old it needs replacing. I have bought a new Windows 7 Pro machine but need help to move all my data to the new machine. I have read that I just need to reinstall SambaPOS v4 on to the new machine and then move the .sdf data. The post that suggests the move: https://sambapos.org/en/content/how-migrate-d…

Can I To Move Database Backup License to another pc

Hi, i have change my PC and install samba v4 as installed in my old PC but after new installation i cant install Database Backup. In my old PC i purchased the license of Database Backup. so i want to know can i move my license to my new pc.

[RickH]

You just need to clear your licence key, install samba on new server and copy database and then when you run samba login to your account and activate the licence

[RickH]

Go to cp.sambapos.com and login and clear your licence

[muthoga]

Thankyou so much sir let me see how this will work

[muthoga]

How do i resolve this error,it occurs while backing up my database

[RickH]

Change the location of your backup folder your trying to save in a location the system doesn’t have access to

Just try saving in a folder directly in C:

For example C:\Samba Backups

[muthoga]

yes i have done that,now i have restored my database.
The only thing that am not able to do is to connect to the database via samba pos string in sambapos

This is my string Data Source=POSSERVER\SAMBAPOS5; User Id=sa; Password=sambapos;

[JTRTech]

No Database= part? Sql insyance can contain multiple databases, you should specify a database name.

[muthoga]

The database name is SAMBAPOS5 as shown on the string above.Their is no need to specify more than that especially if you are only hosting only one database in your server.
All in all i managed,i had to install the same SQL installed in the previous server,then i cleared the keys as per RickH advice and activated the licence on the new machine.
Customer email has to remain the same on both scenarios

[JTRTech]

@muthoga

The database name is SAMBAPOS5 as shown on the string above.

FYI ‘SAMBAPOS5’ in the above is the SQL instance name, not the database name.

[muthoga]

Thanks for collection,JTR Tech,so how do i get to know the database name,in all my setup i have never specified database name in the Data string

[JTRTech]

As I said before typically you would specify a database name in a connection string when using SQL.
If it works without then fair enough however I have only ever specified one.

Full string from my biggest most custom setup at hotel in town here is;

Data Source=localhost\SAMBAPOS; User Id=sa; Password=*******; Database=RAH-5.2.18;

This is obviously from the server machine hosting the SQL, hence the localhost for hostname.
Host-names can also be changed to IP addresses when using static IPs on the network.

At my local pub as a while back they were having DNS issues on their lan I changed all there stings to;

Data Source=192.168.1.101\SAMBAPOS; User Id=sa; Password=*******; Database=SambaPOS;

[muthoga]

Thanks JTR Tech ,that is well understood now,am glad of your assistance man.