Solved

Porting SQL Server 2005 stored procedures to HQL

Posted on 2009-07-05
8
276 Views
Last Modified: 2013-11-13
HI

Is thier any easy (automated / semi-auomated) way to port SQL Server 2005 Stored Procedures to HQL?

Any tools / recomendations are wellcomed ...
Thanks
0
Comment
Question by:elimesika
  • 3
  • 3
  • 2
8 Comments
 
LVL 41

Expert Comment

by:pcelba
ID: 24781649
What do you mean by "porting"? Is it a conversion to ensure (almost) full functionality or just copying SPs from SQL Server somewhere outside?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24781864
I am afraid as it is No.

You have to understand the logic in SQL Procedure and then implement the same in HQL to achieve it.

By the way can you kindly tell us why do you need to convert a procedure into HQL as you can directly call the procedure if the procedure is already available right.

And running a procedure in SQL Server is faster compared to running the same logic from HQL.
0
 
LVL 19

Author Comment

by:elimesika
ID: 24783438
pcelba:

Yes it a conversion to ensure full functionality

rrjegan17:

We are porting to open-source solutions so we have to implement all our SP in HQL

Therefor we can not use SQL Server anymore

Thanks
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 250 total points
ID: 24783654
elimesika,
    I am not aware of any such tools / utilities available as of now:
And hence you have to understand all logics involved and need to convert it into equivalent HQL.

Not sure about this one but give it a try:

https://forum.hibernate.org/viewtopic.php?p=2394174

Hope this helps
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 41

Assisted Solution

by:pcelba
pcelba earned 250 total points
ID: 24783666
Maybe you could look for some conversion tool from SQL Server to the newly intended server. BUT it is not conversion to HQL, of course.

Very trivial conversions are easy but can you magine several joins, unions, subqueries and CTEs? Then table valued parameters and some user defined data types...

HQL means to start almost from the scratch.
0
 
LVL 19

Author Closing Comment

by:elimesika
ID: 31599962
Thanks rrjegan17 & pcelba for your kind help ...
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24784617
Welcome elimesika
And glad to help you out.
0
 
LVL 41

Expert Comment

by:pcelba
ID: 24784705
You are welcome, elimesika.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now