November 2, 2009 at 10:22 pm
I am going to do a lot of bulk inserts (like BCP). Currently I have to decide between SQL Server 2005 and DB2 Server. Assuming that there are 2 servers with the exact same configuration (same CPU type,same RAM and same Hard disk etc.. ).
If I am doing a Bulk Insert of 10 million records into a table in SQL 2005 and into a table in DB2 version 9 (the table structure is the same in both the databases ) , I would like to know where is the bulk insert (or BCP) going to take place faster. Is DB2 faster or SQL server 2005 faster.
Thanks in Advance.
November 4, 2009 at 4:12 am
You will have to build the two environments and try out your queries.
If you are going to make a purchasing decision as a result of the tests you should make sure both database systems are properly tuned. It would be worthwhile to get someone who knows SQL Server to set up the SQL Server environment, and get someone who knows DB2 to set up the DB2 environment.
This should include getting the latest fixes applied as well as memory, etc tuning. You should probably be looking at SQL 2008 SP1 + latest CU and DB2 9.7 plus latest FP. If you only tune one of the systems your results will be biased and you could end up buying the most expensive system.
The tests you make should reflect your planned workload. There is little point in testing how quickly you can load 100,000,000 records if you are never going to do this in your live system. Also, get your SQL optimised for the database system, or insist on just using ANSI standard SQL, otherwise your results will be biased.
If you do all of this, please post your results. Probably a lot of us would be interested.
On the other hand if all you want is an answer for a tutorial, just flip a coin.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
November 4, 2009 at 9:01 am
If I am doing a Bulk Insert of 10 million records into a table in SQL 2005 and into a table in DB2 version 9 (the table structure is the same in both the databases ) , I would like to know where is the bulk insert (or BCP) going to take place faster. Is DB2 faster or SQL server 2005 faster.
Moving data from DB2 to SQL Server and back is an automated task with DTS in SQL Server 7.0 and now SSIS, you should know Microsoft made changes in SQL Server 2005 that requires admin permissions in both DB2 and SQL Server to create the automation with the agent. In software you have to use the right tool for the task because this could be affected by duration, the automation since SQL Server 7.0 can run for five hours a day five days a week. There are about 10,000 banks in the US most of them run bank at home with SQL Server and most deposits are in DB2 AS400.
Kind regards,
Gift Peddie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply