Link to home
Create AccountLog in
Avatar of garyinmiami2003
garyinmiami2003Flag for United States of America

asked on

BCP Utility invoked from VB.net app

I need to select recently changed data in several tables from one database into another database.

I planned to do this the following way:

Use the audit table to ilocate the keys for data changed in the last 24 hours and use in  bulk copy selects to join and output to a offline file

Then in the import database to updates to the database from the offline file(s)

My question is How to programitically use the bcp command from the vb.net program.
Can you provide both an export and import example?
Thanks


Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account