Could someone convert my sdf database to bak on server 2014?

Version 4 V4 Question
1

Im useless with sql servers if someone could convert my database for me id greatly appreciate it :slight_smile:

2

I think SambaPOS can do this automatically with the option checked to auto migrate. I am not 100% clear on how, I would need to look it up. But it makes sense to me if you enter the connection string to your server it will migrate it if you have that checked.

3e6cfd22e3e8a80b.png1107×559 28.5 KB

Maybe someone with more experience in this can chime in.

3

cheers ill have a go at it

4

yea think ill need it this is what happens when i try your suggestion, thanks for the help anyway :smile:

ff6145b14d7402ac.png1366×768 122 KB

5

that means your database is a newer version than your current SambaPOS installed.

6

The SambaPOS you used with the sdf needs to be the same version your using with the SQL server

7

its my old database before i upgraded to 2014 and installed yours to play with, when i was just using compact edition

i dont know how to use my old compact edition in server 2014 instead

8

Just install the latest version of SambaPOS and set it to use your old .sdf database… load sambaPOS let it update that to the new version

THen just change the connection string to your SQL server. Shut it down and restart It should convert it. Might want to delete the database off the server that your using now if thats not the one you plan to use or it will default to trying to connect to it. Or just rename it if you dont want to delete it

9

ive just updated to latest version of samba and your database now doesnt open i get the following error

7b8d2ac4b1799851.png1366×768 54.6 KB

10

Your not wanting to use mine I thought? That happens if it was not the FIRST database it connected to after updating. You need to delete my database using management console…then reinstall sambapos… connect sambapos to your sdf database and load it up. Change the connect string to connect to the server… then restart sambapos.

11

Check your PM i just sent you the converted DB.

12

I think I was wrong about the auto migrate I am not sure what that does I need to look into that more. It probably has something to do with localsql

13

Yes what we call migration is updating database to latest version.

What this setting does is it automatically updates a sdf to latest version when you type a sdf name in connection string area and click :heavy_check_mark: Very handy while testing different sdf files but might not be very useful as it used to be as we are using SQL Local DB instead of SQL CE.

1 Like