Feature: Adjust batch size of inserts when importing data into a table

[Kingston825]

Feature request

Is your feature request related to a problem? Please describe.
Would it be possible to allow us to speciy a batch size value when importing csv files into a table? I have one set of data that imports a few times each year that has so many columns to it that it crashes sqlpro when tring to import. When I use the generate sql feature I see that it imports in batches of 250, when running one of those batches it crashes the program but if I splt the batch into around 125 rows it seems to function fine.

Describe the solution you'd like

I would like to have the option to specify batch size for imports so i can specify a smaller amount for instances where the data being imported is this large.

Product

SQLPro Studio

App version

Build 111127.5

Platform

macOS

Installation source

App Store

[hankinsoft]

That should totally be doable. Could you possibly confirm what database type you are targeting (mysql, mssql, etc) as it's sometimes easier to provide a one off build to confirm functionality.

[Kingston825]

Perfect, thank you. I am using mssql

[hankinsoft]

Could you please try:
https://sqlprostudio.s3.us-east-1.amazonaws.com/mssql/SQLProMSSQL.2026.02.app.zip

And see if that sorts the issue? This is a non-app store version so it will be a seven day trial. If everything is fixed, I will get the App Store version updated which usually takes ~2-3 days.

[Kingston825]

I just tested it, and that worked great. Thank you for doing this. Will this be pushed out to SQL Pro Studio version as well?

[hankinsoft]

I just tested it, and that worked great. Thank you for doing this.

Great, thank you for letting me know.

Will this be pushed out to SQL Pro Studio version as well?

Yep. It's just quickest for me to push out an individual build to a user to get confirmation of fix before submitting App Store versions. I've submitted SQLPro Studio build to apple. It should be available within a day or two, often sooner.

[hankinsoft]

2026.02 has been approved and should now be available on the App Store. If you happen to get the chance, could you consider leave a rating or review on the App Store? As an independent developer, they help me out a ton :)

I'm going to close the issue, but if you find anything not working correctly, please let me know.