Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

How much faster is bulk insert? Expand / Collapse
Author
Message
Posted Tuesday, May 21, 2013 11:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:37 PM
Points: 1, Visits: 2
Bueno, luego de leerlo todo, trataré de seguir las mejores técnicas en el plan de réplica de datos desde una base de datos DB2 a otra SQL Server 2012, luego les contaré al final del proyecto cuales fueron los caminos elegidos y por que.

Best Regards, MauricioP.
Post #1455131
Posted Tuesday, May 21, 2013 11:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:53 PM
Points: 14,325, Visits: 37,415
Google Translate (5/21/2013)
Well, after reading it all, try to follow the best techniques on data replication scheme from a DB2 database to another SQL Server 2012, then I will tell you at the end of the project which were the paths chosen and why.

Best Regards, MauricioP.


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1455144
Posted Wednesday, July 15, 2015 10:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 19, 2016 3:20 PM
Points: 232, Visits: 871
mike gercevich (11/15/2005)


SQL Server Magazine did a comparisopn showdown a few years ago... the article can be found here:

<A href="http://www.windowsitpro.com/SQLServer/Articles/ArticleID/19760/pg/2/2.html">http://www.windowsitpro.com/SQLServer/Articles/ArticleID/19760/pg/2/2.html</A>

-Mike Gercevich


The article has moved here: http://sqlmag.com/t-sql/showdown-bcp-vs-dts
Post #1703123
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse