Samba Data2.sdf convert to SambaPOS4

[moezmalibhai]

Hi Guys,

I have SAMBAPOS V2 Setup which has a SambaData2.sdf file. I have installed Samba POS 4, i need help how to convert the file to support the new Samba 4

[Jesse]

Hello @moezmalibhai,

Take a look here:

SQL Express 2014 Installation - SambaPOS4 Database Setup - [BONUS] How to Convert from CE to SQL Express

Microsoft SQL Express 2014 SQL Express 2014 Download Link Versions Available Express 32BIT WoW64\SQLEXPR32_x86_ENU.exe Express 32BIT\SQLEXPR_x86_ENU.exe Express 64BIT\SQLEXPR_x64_ENU.exe ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe LocalDB 32BIT\SqlLocalDB.msi LocalDB 64BIT\SqlLocalDB.msi - MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe - MgmtS…

First part explains setting up SQL Express 2014 the second part of the tutorial explains how to convert the .sdf file to SQL scripts that can be imported with MSSMS.

You might not like this part but honestly if upgrading from v2 you should probably just start a fresh v4 database and manually rebuild your setup into v4 by looking at your v2 setup and rebuilding it into v4.