Solved

Porting SQL Server 2005 stored procedures to HQL

Posted on 2009-07-05
8
272 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 41

Assisted Solution

by:pcelba
pcelba earned 250 total points
Comment Utility
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
Comment Utility
Thanks rrjegan17 & pcelba for your kind help ...
0
 
LVL 57

Expert Comment

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

Expert Comment

by:pcelba
Comment Utility
You are welcome, elimesika.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 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

16 Experts available now in Live!

Get 1:1 Help Now