# Ive just upgraded and lost data

**URL:** <https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510>\
**Category:** V4 Question\
**Created:** [September 10, 2014, 5:30pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510 "2014-09-10T17:30:08Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 10, 2014, 5:30pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/1 "2014-09-10T17:30:09Z")

</div>

Hi

I just upgraded version 4 to the latest version and selected to install SQLCE. Now all my data has disappeared. Is there a way to go backwards and retrieve the data and then import it into SQLCE or even just get the data back?

Thanks

Simon

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 10, 2014, 5:31pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/2 "2014-09-10T17:31:36Z")

</div>

IF you were using SQLEXPRESS. CE is limited functionality compared to SQLEXPRESS. What were you using before you tried this?

I highly recommend you NOT use CE.

Your data disappeared because you originally set it up to run on a method other than CE. So it has now created a new CE file to run from. You simply just need to connect it to your previous data. If we knew what you were using before it would help.

---

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 10, 2014, 5:35pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/3 "2014-09-10T17:35:24Z")

</div>

The previous data was whatever the default setup is without using SQLCE. Im not sure what type of database that is.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 10, 2014, 5:38pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/4 "2014-09-10T17:38:34Z")

</div>

I am not too familiar with the structure of the LocalSQL install. But I will recommend you follow this tutorial (Much more robust setup):

> [@SambaPOS Database Configuration](https://forum.sambapos.com/t/sambapos-database-configuration/356/1):
>
> In this tutorial I want give some details about database configuration.

---

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 10, 2014, 5:41pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/5 "2014-09-10T17:41:44Z")

</div>

what is the default database as I need to restore my data

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 10, 2014, 5:45pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/6 "2014-09-10T17:45:54Z")

</div>

Default is SQL Server LocalDB

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [September 10, 2014, 11:25pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/7 "2014-09-10T23:25:31Z")

</div>

Uninstall SQL Server CE and it should work fine.

---

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 11, 2014, 9:11am UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/8 "2014-09-11T09:11:12Z")

</div>

I have uninstalled and reinstalled and on installation selected LocalDb. Now I get the error message on loading:  
Cannot open database “SambaPOS4” requested by the login  
the login failed.

I just need to get back to where I was yesterday with my menus and entities all showing!

I really appreciate your help.

---

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 11, 2014, 9:53am UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/9 "2014-09-11T09:53:43Z")

</div>

OK, Ive uninstalled Express. Now it loads but the data is missing. Please can you tell me how to get my old data?

Thanks

---

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 11, 2014, 10:03am UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/10 "2014-09-11T10:03:23Z")

</div>

I think what I am looking for is a copy of my original SambaPOS4.txt file that was in My Documents. Does the software overwrite this without warning?

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [September 11, 2014, 4:12pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/11 "2014-09-11T16:12:04Z")

</div>

@eltonbean

- Uninstall SQLCE.(not express, SQLCE)
- Leave connection string blank.

---

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 12, 2014, 7:26am UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/12 "2014-09-12T07:26:31Z")

</div>

I can find and mdf and an ldf file. These may or may not be my data as I thought my data was in a txt file. Anyway, Ive decided to reload all the products, entities and menus and have install SQL Server 2014 Express and toolkit.  
What is the string to connect to sqlserver 2014?

---

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 12, 2014, 12:57pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/13 "2014-09-12T12:57:54Z")

</div>

@Jesse @enme  
We are opening in 3 hours for a busy night. Please can you help me retrieve my data. I have teamviewer if you would like to log in to the laptop?

---

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 12, 2014, 3:05pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/14 "2014-09-12T15:05:14Z")

</div>

Help! Ive installed express 2012, express 2014. Ive tried a new installation. I don’t want to run without a database.  
I have a 7MB .mdf file but cannot seem to attach that. Any help would be gratefully received.

Thanks

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 12, 2014, 3:27pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/15 "2014-09-12T15:27:44Z")

</div>

i can help you. If your original data was in a txt file then that means you were in test mode and you never really had any data. I do not know what mode you were using SambaPOS in originally and you seem to be confused on how you were running it as well.

I can help you with team viewer if you wish.

You only need 2014 you do not need both.

PM me if you want me to assist you with teamviewer.

---

<div class="post-metadata">

**Author:** ![eltonbean](https://forum.sambapos.com/user_avatar/forum.sambapos.com/eltonbean/32/39093_2.png) [@eltonbean](https://forum.sambapos.com/u/eltonbean)\
**Post date:** [September 12, 2014, 4:07pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/16 "2014-09-12T16:07:21Z")

</div>

ok thats great , let me set up team viewer. I can chat on this while you log in to the PC laptop

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [September 12, 2014, 4:08pm UTC](https://forum.sambapos.com/t/ive-just-upgraded-and-lost-data/2510/17 "2014-09-12T16:08:40Z")

</div>

Ok I am fixing a bottle for my daughter I will check for your PM in just few minutes.
