Notifications
Clear all
Topic starter
I have experience, but definitely not a guru, with using the Oracle SQL Developer. However, I am now dealing with CPS 12.2 without the Oracle, and I'm not sure which developer tool I should use. Preferably, I'd like something free, since I'm not running really extensive queries. Is there a way to continue to use the Oracle SQL Developer, but get it to connect without the Oracle listener?
Any help would be greatly appreciated.
Robin Tardif
Working with CCRM - Colorado Center for Reproductive Medicine
Posted : April 21, 2017 6:26 am
Do you have Crystal?
Posted : April 21, 2017 6:37 am
for running queries you can use the one that comes with SQL "Microsoft SQL Server Management Studio"
you just need to download the installation file of the version of SQL you are using or a higher version and install only the management studio.
Posted : April 21, 2017 6:58 am
Topic starter
Thank you. I don't know or use Crystal. I prefer to use SQL.
I will try the Microsoft product.
Thanks, again.
Posted : April 21, 2017 9:15 am
Another advantage of SQL Server 2008 is that it includes SQL Server Reporting Services (SSRS). You can use either Visual Studio or the SSRS Report Builder software to build both: (1) reports that users can run on-demand; (2) automated reports that are emailed to recipients on a schedule.
Posted : April 24, 2017 9:40 am
You can use Oracle's SQL Developer with Microsoft SQL Server. You have to install a 3rd party java driver (I have jtds-1.3.1.jar installed). That adds the ability to connect to SQL Server to the connection properties. But I would agrees that SQL Server Management Studio is the way to go. It is now offered as a standalone download and works with 2008 through 2016. Lots of tools and features that you would be missing using SQL Developer because it just wasn't designed to work with MS SQL. The one thing I miss though is the ability to have multiple results for the same query tab.
Posted : April 25, 2017 3:37 am
Topic starter
I've been using the Microsoft SQL Server Management Studio, and it is working great for what I need.
Thank you everyone. 🙂
Robin
Posted : April 26, 2017 5:09 pm
