Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Porting SQL Server 2005 stored procedures to HQL

Posted on 2009-07-05
8
283 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 42

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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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
 
LVL 42

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 42

Expert Comment

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

Featured Post

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.

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.
This is about my first experience with programming Arduino.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

839 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