{"id":6014,"date":"2018-11-28T08:50:37","date_gmt":"2018-11-28T08:50:37","guid":{"rendered":"https:\/\/dbtut.com\/?p=6014"},"modified":"2018-11-28T08:50:37","modified_gmt":"2018-11-28T08:50:37","slug":"how-to-import-export-from-sql-server-database-to-sql-server-database","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/","title":{"rendered":"How To Import\/Export from SQL Server Database to SQL Server Database"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>When we need to transfer data from SQL Server or transfer data to SQL Server, we can use the import export methods in SQL Server. The most needed operations are listed below;<\/p>\n<p>In this article, I will describe the import export operations from SQL Server database to SQL Server database.<\/p>\n<p>Let&#8217;s talk about the subject by making an example.<\/p>\n<p>Let&#8217;s assume that we have to transfer the Person.Adress table from the AdventureWorks2014 database to a database named Test.<\/p>\n<p>Right-click on the AdventureWorks2014 database and click Tasks-&gt; Export Data. In the next screen, click the box next to &#8220;Do not show this starting page again&#8221; and click Next.<\/p>\n<p>We select &#8220;Microsoft OLE DB Provider for SQL Server&#8221; from the screen as follows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png\" width=\"589\" height=\"284\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After making our selection, a screen appears as follows. This screen is our Data Source. That is, the screen to select the database that contains the table to be transferred.<\/p>\n<p>As we right-click Export on AdventureWorks2014, it brought AdventureWorks2014 directly to the Database section as follows. Continue by clicking Next.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/447-1.png\" width=\"591\" height=\"381\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Since we are going to transfer data from SQL Server to SQL Server, we select the Microsoft OLE DB Provider for SQL Server from the next screen.<\/p>\n<p>In the Server Name section, we write the instance name that we want to transfer the data to. If you do not know the name exactly, you can select it by clicking on the down arrow to the right but it will keep you waiting a bit. So writing a name is a faster solution.<\/p>\n<p>Then select Windows or SQL Server Authentication from the Authentication section. I mentioned the details of Authentication types in my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/09\/how-to-install-sql-server\/\" target=\"_blank\" rel=\"noopener\">How To Install SQL Server<\/a>&#8220;.<\/p>\n<p>After determining the Authentication method, we write the database name that we will transfer to the Database part. If you do not know the name exactly, you can select it by clicking on the down arrow to the right but it will keep you waiting a bit. So writing a name is a faster solution.<\/p>\n<p>In our example, we will transfer to another database on the same instance, so we will see a screen like below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/898.png\" width=\"625\" height=\"639\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Click Next to proceed. On the next screen, we proceed by selecting &#8220;Copy data from one or more tables or views&#8221;.<\/p>\n<p>You can also transfer data with your own query by selecting &#8220;write a query to specify the data transfer&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/646.png\" width=\"626\" height=\"308\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>In the next screen, we select the table we will transfer.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/619-2.png\" width=\"587\" height=\"592\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>You can make some settings by clicking &#8220;Edit Mappings&#8221;. The following screen shows the details of the settings you can make.<\/p>\n<p>The Create Destination Table has been selected.<\/p>\n<p>If you have the same table in the target, you can select Drop and recreate to.<\/p>\n<p>If you need to do Identity Insert, you must also select this option. In the article &#8220;Identity Insert&#8221;, I explained what this option means.<\/p>\n<p>You can change the data types and sizes on the target when you transfer the Table. But you need to pay attention to the type mismatch. If you convert a column with the varchar data type to an int type, you may encounter problems during the transfer.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/979.png\" width=\"617\" height=\"499\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>We click ok without making any changes, and then click next amd next to complete the transfer.<\/p>\n<p>In this example, we export from the database we selected with Task-&gt; Export method.<\/p>\n<p>Instead of exporting from the AdventureWorks2014 database, we could achieve the same result in the same way as right-clicking on the Test database and clicking Task-&gt; Import.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6014\" class=\"pvc_stats all  \" data-element-id=\"6014\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; When we need to transfer data from SQL Server or transfer data to SQL Server, we can use the import export methods in SQL Server. The most needed operations are listed below; In this article, I will describe the import export operations from SQL Server database to SQL Server database. Let&#8217;s talk about the &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6014\" class=\"pvc_stats all  \" data-element-id=\"6014\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6014","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Import\/Export from SQL Server Database to SQL Server Database - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Import\/Export from SQL Server Database to SQL Server Database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Import\/Export from SQL Server Database to SQL Server Database - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Import\/Export from SQL Server Database to SQL Server Database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-28T08:50:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Import\/Export from SQL Server Database to SQL Server Database\",\"datePublished\":\"2018-11-28T08:50:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/\"},\"wordCount\":605,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/\",\"name\":\"How To Import\/Export from SQL Server Database to SQL Server Database - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png\",\"datePublished\":\"2018-11-28T08:50:37+00:00\",\"description\":\"How To Import\/Export from SQL Server Database to SQL Server Database\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png\",\"width\":859,\"height\":414},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Import\/Export from SQL Server Database to SQL Server Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Import\/Export from SQL Server Database to SQL Server Database - Database Tutorials","description":"How To Import\/Export from SQL Server Database to SQL Server Database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/","og_locale":"en_US","og_type":"article","og_title":"How To Import\/Export from SQL Server Database to SQL Server Database - Database Tutorials","og_description":"How To Import\/Export from SQL Server Database to SQL Server Database","og_url":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/","og_site_name":"Database Tutorials","article_published_time":"2018-11-28T08:50:37+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Import\/Export from SQL Server Database to SQL Server Database","datePublished":"2018-11-28T08:50:37+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/"},"wordCount":605,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/","url":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/","name":"How To Import\/Export from SQL Server Database to SQL Server Database - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png","datePublished":"2018-11-28T08:50:37+00:00","description":"How To Import\/Export from SQL Server Database to SQL Server Database","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/641.png","width":859,"height":414},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/28\/how-to-import-export-from-sql-server-database-to-sql-server-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Import\/Export from SQL Server Database to SQL Server Database"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6014"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6014\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}