# How to transfer data from sambapos4.SDF File to SQL Express 2012 database? **URL:** \ **Category:** V4 Question\ **Created:** [March 27, 2014, 11:52pm UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872 "2014-03-27T23:52:42Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\ **Post date:** [March 27, 2014, 11:52pm UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872/1 "2014-03-27T23:52:42Z")
Can anyone post a tutorial that explains How to transfer data from sambapos4.SDF File to SQL Express 2012 database??? I tried this [How to migrate from SQL Compact Edition (sdf file) to SQL Server 2012 Express](http://forum.sambapos.com/t/how-to-migrate-from-sql-compact-edition-sdf-file-to-sql-server-2012-express/752) but does not work for me Thanks. ---
**Author:** ![morshed1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/8c91f0/32.png) [@morshed1](https://forum.sambapos.com/u/morshed1)\ **Post date:** [March 28, 2014, 8:37am UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872/2 "2014-03-28T08:37:54Z")
Can you provide more detail of the issue you are having… If the steps have been followed correctly from below then it should work… [How to migrate from SQL Compact Edition (sdf file) to SQL Server 2012 Express](http://forum.sambapos.com/t/how-to-migrate-from-sql-compact-edition-sdf-file-to-sql-server-2012-express/752) ---
**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\ **Post date:** [March 28, 2014, 1:25pm UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872/3 "2014-03-28T13:25:03Z")
hi @morshed​1 Thanks for the reference. first i was Unable to create the migration file Second i cant find SQL Server Management Studio Express on my pc What am I doing wrong??? ---
**Author:** ![morshed1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/8c91f0/32.png) [@morshed1](https://forum.sambapos.com/u/morshed1)\ **Post date:** [March 28, 2014, 2:30pm UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872/4 "2014-03-28T14:30:16Z")
@pizzaeilat4 if you don’t have SQL server management studio express on your computer then it mean its not configured on you system. Below link shows how to configure. [http://www.sambapos.org/en/content/installing-sql-express-2012-sambapos-v3](http://www.sambapos.org/en/content/installing-sql-express-2012-sambapos-v3) if you can also provide a screen capture how you are creating the migration file. ---
**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\ **Post date:** [March 28, 2014, 2:31pm UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872/5 "2014-03-28T14:31:53Z")
![](https://forum.sambapos.com/uploads/default/original/3X/8/e/8e3f7be70b683f6d8fdb80bbee7d73b3e0f8a778.png) ---
**Author:** ![morshed1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/8c91f0/32.png) [@morshed1](https://forum.sambapos.com/u/morshed1)\ **Post date:** [March 28, 2014, 3:33pm UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872/6 "2014-03-28T15:33:23Z")
From the screen capture I can see you have created the Migrate.slq file. if the file has been created correctly then it would output the file as per below. ![](https://forum.sambapos.com/uploads/default/original/3X/1/b/1b38252eb837194a47d4d64869d09ec194768a10.jpeg) then you should have You will need to configure SQL on your systems as per below [http://www.sambapos.org/en/content/installing-sql-express-2012-sambapos-v31](http://www.sambapos.org/en/content/installing-sql-express-2012-sambapos-v31) then follow the steps for [Restoring the database to SQL Server] ---
**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\ **Post date:** [March 28, 2014, 3:41pm UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872/7 "2014-03-28T15:41:02Z")
Okay I finished all What is the Data source path I need to put in local settings??? ---
**Author:** ![morshed1](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/8c91f0/32.png) [@morshed1](https://forum.sambapos.com/u/morshed1)\ **Post date:** [March 28, 2014, 4:16pm UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872/8 "2014-03-28T16:16:39Z")
Data source=[Computer name]\SAMBAPOS4; User Id=sa; Password=sambapos [Computer name] : same name as your computer , to see the computer name go to Control Panel\System and Security\System Computer name: Under Computer name, domain, and workgroup settings, you can find your computer name, Following details needs to be same as configured during SQL configuration. SAMBAPOS4; User Id=sa; Password=sambapos You can also refer to the guide john has created. > [@SambaPOS Server, Workstation & RDP Setup Guide](http://forum.sambapos.com/t/sambapos-server-workstation-rdp-setup-guide/798): > > This guide I wrote a while ago is based on SambaPOS V3.0.24, but is applicable to V4. It is still in draft, but covers Server setup Terminal setup RDP setup Printer setup [SambaPOS Server Setup Guide (DRAFT) v2.pdf](https://forum.sambapos.com/uploads/default/original/3X/6/1/61066c803bd064c4de33e7e8ad38865f03f9305e.pdf) (5.1 MB) ---
**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\ **Post date:** [March 28, 2014, 4:27pm UTC](https://forum.sambapos.com/t/how-to-transfer-data-from-sambapos4-sdf-file-to-sql-express-2012-database/872/9 "2014-03-28T16:27:06Z")
Thank you works great