SQL Server 2012 Data Integration Recipes

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You...

Πλήρης περιγραφή

Λεπτομέρειες βιβλιογραφικής εγγραφής
Κύριος συγγραφέας: Aspin, Adam (Συγγραφέας)
Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
Γλώσσα:English
Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2012.
Θέματα:
Διαθέσιμο Online:Full Text via HEAL-Link
LEADER 03136nam a22004095i 4500
001 978-1-4302-4792-0
003 DE-He213
005 20150716154131.0
007 cr nn 008mamaa
008 130125s2012 xxu| s |||| 0|eng d
020 |a 9781430247920  |9 978-1-4302-4792-0 
024 7 |a 10.1007/978-1-4302-4792-0  |2 doi 
040 |d GrThAP 
050 4 |a QA76.9.D3 
072 7 |a UN  |2 bicssc 
072 7 |a UMT  |2 bicssc 
072 7 |a COM021000  |2 bisacsh 
082 0 4 |a 005.74  |2 23 
100 1 |a Aspin, Adam.  |e author. 
245 1 0 |a SQL Server 2012 Data Integration Recipes  |h [electronic resource] /  |c by Adam Aspin. 
264 1 |a Berkeley, CA :  |b Apress :  |b Imprint: Apress,  |c 2012. 
300 |a LII, 1056 p.  |b online resource. 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file  |b PDF  |2 rda 
520 |a SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more. What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs. Provides practical and proven solutions towards creating resilient ETL environments Clearly answers the tough questions which professionals ask Goes beyond the tools to a thorough discussion of the underlying techniques Covers the gamut of data integration, beyond just SSIS Includes example databases and files to allow readers to test the recipes. 
650 0 |a Computer science. 
650 0 |a Database management. 
650 1 4 |a Computer Science. 
650 2 4 |a Database Management. 
710 2 |a SpringerLink (Online service) 
773 0 |t Springer eBooks 
776 0 8 |i Printed edition:  |z 9781430247913 
856 4 0 |u http://dx.doi.org/10.1007/978-1-4302-4792-0  |z Full Text via HEAL-Link 
912 |a ZDB-2-CWD 
950 |a Professional and Applied Computing (Springer-12059)