How can we help you today?

Start a new topic
Discussions Royal TS (for Windows) Ideas

SQL Client Plugin

It would be great to have a plugin that allows SQL connection to a database resource. Ideally with script output and gridview output options too.

Something like Oracle's SQL Developer embedded.

 

1 person likes this idea
10 CommentsSorted by Oldest First

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

Ok i will try and update with my findings

 

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

https://github.com/dbeaver/dbeaver/wiki/Command-Line#connection-parameters

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

Login or Signup to post a comment
More topics in Ideas
See all 562 topics