hi, I have V5 with SQL CE installed on Win7 64x. I have been trialling out the software and have been building up the menu. I am now ready to purchase the license and go live. I have been reading the forums and now would like to use the app using windows tablet using Remote Desktop protocol.
But there is a problem…
Originally when I installed Sambpos I didn’t set a database i.e. SDF so I am assuming its been setup as “Text File Database”
I have setup the app on another laptop with SQL Database but now I would like to migrate “Text File Database” to SQL DB. If this possible? I cant find anything on the forum.
You say CE but pretty sure samba v5 does not support CE.
Double click on the top left samba icon when logged in as an admin and pasted a screenshot of the title bar. It shows the database type in use.
I have located the MDF file under USER folder. I am assuming this has all my data and config setting? How can I convert or migrate the data to SQL using SSMS? Thanks
I have managed to resolve the issue. Previously I installed SQL 2012 and various issue with conversion and then missing prices. All issue were resolved by installing 2014 SQL from Microsoft and then attached the MDF file to in SQL Mgmt Studio. Thanks for you help, QMcKay.