[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 453
  • Last Modified:

1.2 million inserts trough odbc

What is the fastest way to insert 1.2 million records using odbc.

dbf -> Change values -> mssql

0
dgb
Asked:
dgb
1 Solution
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Use DTS import wizard...
0
 
dgbAuthor Commented:
I can't the "change values" is something i have to do in vb
0
 
LowfatspreadCommented:
>"change values"

what is the process that you're trying to achieve...?

what proportion of the database/table does the 1.2m rows consume?
are you afffecting indexes with your changes?
are you changing foreign keys?

0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
dgbAuthor Commented:
Dont know what you mean by this.
>>what proportion of the database/table does the 1.2m rows consume?

I removed all the foreign keys and the only index is the unique key

What i change is not that important, i just want to insert 1 million records using odbc.
Is there a quick way to go about this, maybe changing some settings.
Locking the database or . . .

0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<I can't the "change values" is something i have to do in vb>>Then you can build a package in DTS designer wichi allows to run TSQL and VB scripting in undifferiated manner...(even though TSQL is more efficient)
0
 
dgbAuthor Commented:
Is there no way to do it using odbc
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<Is there no way to do it using odbc>>Yes there are ways but they are not the fastest...If you want ot do this through VB, you may consider calling the BULK INSERT statement in TSQL from VB using ODBC or any provider (better use other provider, ODBC is underoptimized for this kind of operation)...

Check this link for usage

http://www.transactsql.com/html/BULK%20INSERT.html

Hope this helps...
0
 
dgbAuthor Commented:
will check it out thanks for now
0
 
YZlatCommented:
This question has been classified as abandoned as it has no comments in the last 21 days.  I will make a recommendation to the moderators on its resolution in approximately 4 days.  I would appreciate any comments by the experts that would help me in making a recommendation.

It is assumed that any participant not responding to this request is no longer interested in its final disposition.

If the asker does not know how to close the question, the options are here:
http://www.experts-exchange.com/help.jsp#hs5

YZlat
EE Cleanup Volunteer
0
 
dgbAuthor Commented:
Racimo :
Thanks.
i still have not had the time to look into it but thats my problem.

0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now