SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Export, import Rss

   Items 1 to 5 of 5   

Azure DWH part 16: BCP to import and export data

In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.  Read more...
By Daniel Calbimonte 2017/09/26 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 384 reads

Exporting Data from JSON to CSV with SSIS

The following tutorial will show how to export JSON data to a CSV file using SSIS  Read more...
Rating: |  Discuss |   Briefcase | 1,264 reads

Generate row constructors for existing data

Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard  Read more...
By Gabe Tower 2013/11/14 | Source: SQLServerCentral.com | Category: rows
Rating: |  Discuss |   Briefcase | 1,155 reads

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.  Read more...
By Bret Lowery 2011/07/18 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 9,835 reads

Export/import relational data across SQL Servers

The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.  Read more...
By Ashish Kumar-1095774 2009/07/03 | Source: SQLServerCentral.com | Category: export
Rating: |  Discuss |   Briefcase | 1,501 reads
   Items 1 to 5 of 5   
bcp (3)    
integration services (ssis) (2)    
json (2)    
azure (1)    
bulkcopy (1)    
bulkimport (1)    
c# (1)    
copy (1)    
data (1)    
dml (1)    
inserts (1)    
move data (1)    
row constructors (1)    
rows (1)    
sql (1)    
sqlclr (1)    
vbscript (1)    
warehouse (1)    
xml (1)    
xportxml (1)