Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Amirthalingam
Starting Member
7 Posts |
 Posted - 2011-04-18 : 00:30:52
|
| Bulk Insert concept |
|
|
Amirthalingam
Starting Member
7 Posts |
Posted - 2011-04-18 : 00:32:20
|
| Is it possible to insert 1 crore records from one sqlserver to another sql server using sqlbulkcopy within a minute |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2011-04-18 : 01:08:57
|
1 crore = 10 million? that's a lot for less than 1 minute. depends on how many bytes per row though, and whether you have lots of indexes on the destination table.
elsasoft.org |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2011-04-18 : 15:55:10
|
and how many cores available to do the task.
btw, this post is not related to HA.
Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
SqlBulkCopy