{"id":15732,"date":"2018-07-27T15:47:36","date_gmt":"2018-07-27T15:47:36","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=15732"},"modified":"2019-05-08T14:13:08","modified_gmt":"2019-05-08T14:13:08","slug":"2-1-3-b-transferring-data-from-local-db-to-sql-database","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/2-1-3-b-transferring-data-from-local-db-to-sql-database\/","title":{"rendered":"2.1.3.b. Transferring Data from Local DB to SQL Database"},"content":{"rendered":"

1. Checking Local DB Version<\/strong><\/span><\/p>\n

On you computer, Start > Control Panel > Programs and Features ><\/strong>\u00a0from the list, find out\u00a0Microsoft SQL Server Local DB<\/strong> version number.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

2. Determining\u00a0Connection String According to Local DB Version<\/strong><\/span><\/p>\n

LocalDB String Phrase for SQL Server 2012 : (LocalDB)\\v11.0<\/p>\n

LocalDB String Phrase for SQL Server 2014 : (LocalDB)\\MSSQLLocalDB<\/p>\n

Start the SQL Management Studio, write necessary phrase into Server field according to your need and Login via Windows Authentication.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

3. Getting Data from Local DB<\/strong><\/span><\/p>\n

After you logged in, find your Local DB. Usually its named as SAMBAPOS;<\/p>\n

\"\"<\/p>\n

Right click on SAMBAPOS5, in the menu; Tasks > Generate Scripts<\/p>\n

\"\"<\/p>\n

Click on Next in the window.<\/p>\n

\"\"<\/p>\n

In the New Window select Script Entire Database, click on Next, determine the path to save the Script and then click on Advanced.<\/p>\n

\"\"<\/p>\n

Select the\u00a0 SQL Version on your computer for Script For SQL Version;<\/p>\n

\"\"<\/p>\n

Click on Types Of Data To Script, select Schema and Data, click on Ok and Next;<\/p>\n

\"\"<\/p>\n

In the window, click on Next again;<\/p>\n

\"\"<\/p>\n

After completing the process, click on Finish button;<\/p>\n

\"\"<\/p>\n

 <\/p>\n

4. Transferring Data from Local DB to SQL<\/strong><\/span><\/p>\n

Login to SQL Management Studio and run the Script which you have created at the step 3;<\/p>\n

\"\"<\/p>\n

When you run the Script, if there is a database which has same name with marked in red box, you will get the below error message.<\/p>\n

\"\"<\/p>\n

In this case, change the database name and click on CTRL+F buttons, write current name of your database into the first line, new name of your database into second line of the box on right top corner and then select\u00a0Replace All<\/strong>;<\/p>\n

\"\"<\/p>\n

After completing necessary editings, when you click on\u00a0Execute<\/strong> button, a screen will be occured like below;<\/p>\n

\"\"<\/p>\n

5. Connecting New Database that Created on SQL and SambaPOS<\/strong><\/span><\/p>\n

Login to SambaPOS;<\/p>\n

Main Menu > Manage > Settings > Local Settings > Database ><\/strong>\u00a0here click on Edit Connection,<\/strong> enter necessary information and then click on Apply <\/strong>button;<\/p>\n

\"\"<\/p>\n

 <\/p>\n

In the newly created Database, all the information from\u00a0Local DB,\u00a0<\/strong>will be transferred\u00a0to\u00a0SQL Database.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

1. Checking Local DB Version On you computer, Start > Control Panel > Programs and Features >\u00a0from the list, find out\u00a0Microsoft SQL Server Local DB version number.   2. Determining\u00a0Connection String According to Local DB Version LocalDB String Phrase for SQL Server 2012 : (LocalDB)\\v11.0 LocalDB String Phrase for SQL Server 2014 : (LocalDB)\\MSSQLLocalDB Start […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-15732","post","type-post","status-publish","format-standard","hentry","category-2-1-system-setup"],"_links":{"self":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/15732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/comments?post=15732"}],"version-history":[{"count":11,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/15732\/revisions"}],"predecessor-version":[{"id":18397,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/15732\/revisions\/18397"}],"wp:attachment":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/media?parent=15732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/categories?post=15732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/tags?post=15732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}