Feature Request: Export into separate files

[DaveSanders]

Is your feature request related to a problem? Please describe. I'm exporting / importing a large database worth of data, using the Postgres SQL method. When exporting multiple tables, I only have the option to export them to one large sql file. I can do this manually by going through the process for each individual table, but its very time consuming.

Describe the solution you'd like I'd like the option to be able to export each table into its own file, resulting in a folder with a set of scripts for the database.

Describe alternatives you've considered Only alternative I can think of is to do it manually.

Environment (please complete the following information):

• Device: Mac
• OS: 13.1.1
• SQLPro app Version: SQLPro Sutdio 2023.35
  • Installation source: App Store
  • Target database server Postgres (but this should apply to all exports)

[hankinsoft]

Working on this for the next build. You can now check 'Create a file for each entry'. I hope to have it available late next week.

[DaveSanders]

Wow, thanks! Great to hear!

Dave

On Fri, May 12, 2023 at 7:48 AM Kyle Hankinson @.***> wrote:

Working on this for the next build. You can now check 'Create a file for each entry'. I hope to have it available late next week. [image: Screenshot 2023-05-12 at 8 47 44 AM] https://user-images.githubusercontent.com/3160528/237962103-fc7d05c6-f14b-4613-a146-d98f8868ec61.png

— Reply to this email directly, view it on GitHub https://github.com/hankinsoft/SQLPro/issues/899#issuecomment-1545618773, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAF64SBBKMDVXRTW3W5SH3XFYPSLANCNFSM6AAAAAAXPLGYN4 . You are receiving this because you authored the thread.Message ID: @.***>

[hankinsoft]

SQLPro Studio 2023.41 is now available on the App Store and should have this available. Please give it a try if you get the chance.

[DaveSanders]

Tried it out this morning, and it looks like it's working well. Thank you!

Minor, minor visual bug - the message "Exporting object X of X" might be using a zero index instead of a 1 index? It says here that it's exporting object 9, but it's really working on exporting object 10 in this screenshot. Otherwise, it looks good!

[image: image.png]

-- Dave Sanders, Founding Partner Avenue 80

On Mon, May 15, 2023 at 8:35 AM Kyle Hankinson @.***> wrote:

SQLPro Studio 2023.41 is now available on the App Store and should have this available. Please give it a try if you get the chance.

— Reply to this email directly, view it on GitHub https://github.com/hankinsoft/SQLPro/issues/899#issuecomment-1547782211, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAF64R6SSO7MPJFFV2BBI3XGIPK5ANCNFSM6AAAAAAXPLGYN4 . You are receiving this because you authored the thread.Message ID: @.***>

[hankinsoft]

Minor, minor visual bug - the message "Exporting object X of X" might be using a zero index instead of a 1 index? It says here that it's exporting object 9, but it's really working on exporting object 10 in this screenshot. Otherwise, it looks good!

Thanks for that. I've got this fixed up for the next build.