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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-10 : 08:15:31
|
| Rohit writes "I am posting this question after waiting for 4 days after posting my question in your Import/Export (DTS) and ReplicationForum, when my question didnt appear on the forum then i decided to ask you.Here is the Question.There are two databases (SQL /Access/Flat Files) whose schemas are entirely different. I need to import data from one database to another. I am using SQL Server 2000 This means that each row of the tables in the source database needs to be parsed before it is moved to the destination database tables But the real problem is that the databases are located on different servers and there are some 2,00,000 records. I have tried breaking up the record in the batch in 3 parts of 50,000 each, however when i try to execute the query on my local server, it took around an hour to complete the process. now you can imagine how much time it is going to take on the production server. this does not seem to me as the reliable solution. This has to be accomplished through a web interface (to be built in C#). Please help me out and provide me a feasible solution." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-05-10 : 09:20:20
|
| Bulk insert into staging table and split the results into the relational table once completed. This will be much faster.. |
 |
|
|
|
|
|
Need To Update 2,00,000 Records At Once !