Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Migrating From Sql To Vertica.

HI Experts,

 

    we are migrating from Sql 2012 to vertica7. I have the following question, any help is really appreciated.

 

1. We have converted the sql stored procedure to shell scripts that are running fine. Now How can i call these from my UI code ( i am using ADO.net), I know i can execute single or multiline queries on vertica DB. But i do not want to write these big queries in the UI code.Is there a better approach where can i call the queries already written in the shell script and get a data set out of it. It should look like below :

 

 

  VerticaCommand cmd = Vcon.CreateCommand();

  cmd.CommandText =  " Read query from shell script / or a external file , do not hard code here" ;

 

Basically i am lookign to call a stored procedure from my UI Code.

 

Comments

  • HI,

     

      did anyone get a chance to look at this question; please share some ideas..

    Thanks.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.