Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Extend tdbc::odbc interface to add BCP commands for SQL Server schema builds #594

Open
sm-shaw opened this issue Sep 11, 2023 · 0 comments
Labels
build enhancement New feature or request help wanted Extra attention is needed

Comments

@sm-shaw
Copy link
Contributor

sm-shaw commented Sep 11, 2023

Pull Requests #587 #592 have added bcp based loads for the SQL Server TPROC-C schema, significantly improving build times. Issue #593 proposes the same update for the TPROC-H schema.

Currently, this feature uses the external bcp command called via exec. It should be possible to extend the tdbc::odbc interface to add the bcp_init, bind and sendrow commands and call these directly from ODBC rather than using the external bcp command

https://learn.microsoft.com/en-us/sql/relational-databases/native-client-odbc-extensions-bulk-copy-functions/bcp-init?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/relational-databases/native-client-odbc-extensions-bulk-copy-functions/bcp-bind?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/relational-databases/native-client-odbc-extensions-bulk-copy-functions/bcp-sendrow?view=sql-server-ver16

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
build enhancement New feature or request help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

1 participant