<div>
Edited text of question<br />

</div>


<div>
Although the answer didn't really help me, since you have responded first and gave me some direction on the problem I would like to award these points to you.<br />
<br />
Thanks for your help.<br />

</div>


Although the answer didn't really help me, since you have responded first and gave me some direction on the problem I would like to award these points to you.

Thanks for your help.


<div>
<div class="content wysiwyg-content">
Background:<br />
I am converting a huge DBase db into SQL. &nbsp;What I have done is extracted data from DBase into non-delimited files and BCPed the data into a SQL db - HMS(Note that this db has the same table structure as the one in DBase). &nbsp;I have a db in SQL - RxOne where some of the table structures match with the DBase db. &nbsp;The aim is to get the data from HMS to RxOne(both the dbs are on the same server) in the right order i.e maintaining the FK relationships etc. &nbsp;So here is what I am doing.<br />
<br />
1. Read data from HMS using Stored Procedures<br />
2. Map the fields in VB<br />
3. Insert data into RxOne using Stored Procedures<br />
<br />
Now to do this for 20000 records it takes about 70 minutes. &nbsp;The other thing I have tried is export into a tab delimited file so that I can BCP from there, this takes about 60 mins.<br />
<br />
Question:<br />
I have a few million records to convert, does anyone know how to speed up this process?
</div>
</div>


Background:
I am converting a huge DBase db into SQL.  What I have done is extracted data from DBase into non-delimited files and BCPed the data into a SQL db - HMS(Note that this db has the same table structure as the one in DBase).  I have a db in SQL - RxOne where some of the table structures match with the DBase db.  The aim is to get the data from HMS to RxOne(both the dbs are on the same server) in the right order i.e maintaining the FK relationships etc.  So here is what I am doing.

1. Read data from HMS using Stored Procedures
2. Map the fields in VB
3. Insert data into RxOne using Stored Procedures

Now to do this for 20000 records it takes about 70 minutes.  The other thing I have tried is export into a tab delimited file so that I can BCP from there, this takes about 60 mins.

Question:
I have a few million records to convert, does anyone know how to speed up this process?

SQL to SQL Data transfer speed

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.