Hi Dan,
thanks for the feedback. We will look into that. I know we already mentioned this to you but for the record, we do have a PowerShell connection type which can render basically any output as text or even in a grid:
https://content.royalapplications.com/Help/RoyalTS/V4/index.html?reference_powershellconnection.htm
It's quite easy to create a PowerShell script which connects to a database and executes a query:
https://docs.microsoft.com/en-us/sql/powershell/invoke-sqlcmd-cmdlet
Or using some .net SQL client object:
https://blog.jourdant.me/post/simple-sql-in-powershell
Regards,
Stefan
Thank you, i agree that for just running command with no other "feedback" that would work fine. I would also like a grid view to show SELECT results too so that would be a lot trickier,
You can use a grid view to output the select results using the PowerShell connection type. Once it is shown in the grid, you can do all sorts of stuff, like sorting, filtering, etc.
cheers,
Stefan
Also make sure you check out this blog post:
http://blog.royalapplications.com/2015/06/16/new-feature-powershell-connection/
Should you have any questions, let me know.
Regards,
Stefan
It has been 5 years since this was file. Any update on if you plan on adding a sql client connection? My team has converted to using Royal for 90% of all their tasks. The only piece of software that we have to use outside of Royal is pgadmin since all of our data is in postgresql databases. Any chance some sort of connection to a postgresql database could be added?
Hi Chris,
there are no short- to mid-term plans to integrate something like this natively into Royal TS. Did you check out the external application connection type in Royal TS for Windows?
https://docs.royalapps.com/r2021/royalts/reference/connections/external-app.html
Not all apps can be embedded and some apps may have some side effects when embedded but I think it's worth a shot.
Regards,
Stefan
Those instructions are for TS, what about TSX?
Hi Chris,
this is the forum for Royal TS for Windows. I kindly ask you to post your suggestion in the macOS forums:
https://support.royalapps.com/support/discussions/forums/17000122803
Thank you,
Stefan
Dan Johns
Something like Oracle's SQL Developer embedded.
1 person likes this idea