Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 @ 5:21 PM
Points: 13,618, Visits: 34,771
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
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, July 30, 2015 4:59 PM
Points: 229, Visits: 840
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