Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

SQL Developer without Oracle

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

5 Users

0 Reactions

62 Views

RSS

rtardif

(@rtardif)

Posts: 55

Trusted Member

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

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Do you have Crystal?

Posted : April 21, 2017 6:37 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

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

rtardif

(@rtardif)

Posts: 55

Trusted Member

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

chaddix

(@chaddix)

Posts: 177

Estimable Member

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

DavidShower

(@davidshower)

Posts: 1255

Noble Member

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

rtardif

(@rtardif)

Posts: 55

Trusted Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
5 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0