Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Export Rss

   Items 1 to 7 of 7   
 

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,079 reads

Export data from MySQL to SQL Server

Many people want to create a customized migration process using SQL Server Integration Services (SSIS), but it is hard to start working with heterogeneous databases like MySQL, Postgres, DB2, etc. Check out this tip to learn about how to import data from heterogeneous databases like MySQL to SQL Server.  Read more...
By Additional Articles 2012/04/20 | Source: MSSQLTips.com | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 2,786 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 | 7,693 reads

XLSExport: A CLR procedure to export proc results to Excel

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.  Read more...
By Bret Lowery 2011/06/23 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 8,698 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,430 reads

Simple way to export SQL Server data to Text Files

With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.  Read more...
By Additional Articles 2008/12/05 | Source: MSSQLTips.com | Category: export
Rating:  Rate this |   Briefcase | 8,808 reads

Exporting and Versioning Lookup Data: A Real-World Use of the CLR

The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.  Read more...
By Solomon Rutzky 2008/06/24 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 5,106 reads
   Items 1 to 7 of 7   
 
Tags
bcp (4)    
import (3)    
sqlclr (3)    
c# (2)    
backup / restore (1)    
bulkcopy (1)    
bulkimport (1)    
common language runtime (clr) (1)    
copy (1)    
disaster recovery (dr) (1)    
dml (1)    
excel (1)    
extract, transform, load (etl) (1)    
inserts (1)    
integration services (ssis) (1)    
json (1)    
move data (1)    
mysql (1)    
row constructors (1)    
rows (1)    
sql server 2005 (1)    
vbscript (1)    
xml (1)    
xp_cmdshell (1)    
xportxml (1)