Porting SQL Server 2005 stored procedures to HQL


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

Any tools / recomendations are wellcomed ...
LVL 19
Who is Participating?
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
    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:


Hope this helps
What do you mean by "porting"? Is it a conversion to ensure (almost) full functionality or just copying SPs from SQL Server somewhere outside?
Raja Jegan RSQL Server DBA & ArchitectCommented:
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.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

elimesikaAuthor Commented:

Yes it a conversion to ensure full functionality


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

pcelbaConnect With a Mentor Commented:
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.
elimesikaAuthor Commented:
Thanks rrjegan17 & pcelba for your kind help ...
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome elimesika
And glad to help you out.
You are welcome, elimesika.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.