Board index » delphi » Copying Huge Data one DB to another (MS SQL Server)
Gürcan YÜCEL
Delphi Developer |
Copying Huge Data one DB to another (MS SQL Server)2005-06-24 10:37:59 PM delphi194 Hi, I hat to copy data from one table to another database table that runs on the same machine. 1.Database A contains table A. 2.Table A has 2 million rows. 3.There are image and text fields. 4.Total table size approximately 55GB. 5.I created a database B in the same server and Table B in DB B. 6.I had to copy all table to Table B. 7.Table A runs on IDE disk which is size 150GB. 8.Table B runs on SCSI RAID 5 which is size 75GB. what is the fastest way to copt table data? My Test Results; 1.I copy with primary index range, (10.000 at a time) . I will take 10 days. 2.I copy the data with insert into, log file exceed the size limit (75GB total) 3.I copy the data one by one. Up to one level, its fast. in about 100.000 record, memory sucs. SQL server uses 1.8 GB memory. Than slow downs. The server has 2 CPUs and 2GB memory. Any idea? |