Question Re: HANA instead of SQL Server in Technology Q&A https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaa-p/9735454#M3486063 <HTML><HEAD></HEAD><BODY><P>Hi Mario,</P><P></P><P>Please refer to the documents on some of the basic understanding on SQL Query and procedure migration.</P><P></P><P><A __default_attr="82977" __jive_macro_name="blogpost" class="jive_macro jive_macro_blogpost active_link" href="https://community.sap.com/" style="color: #2989c5;"></A></P><P><A __default_attr="39120" __jive_macro_name="document" class="jive_macro jive_macro_document" href="https://community.sap.com/"></A></P><P></P><P>As you know, there is some syntax difference between SQL Server and HANA SQL scripts, there could be some challenges on migrating the SQL Server procedures to HANA.</P><P></P><P>Depending upon how the reporting access the underlying database, (SQL Interface, Queries fired against the database, custom coding), you may have to modify the reports.</P><P></P><P>Regards,</P><P></P><P>Ravi</P></BODY></HTML> Wed, 25 Sep 2013 13:54:08 GMT Ravi_Channe 2013-09-25T13:54:08Z HANA instead of SQL Server https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaq-p/9735451 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have got a specific question about HANA. Is it possible to create software on Microsoft Visual .NET using HANA as database instead of SQL Server?</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P></P><P>Alejandro Fonseca.</P></BODY></HTML> Tue, 24 Sep 2013 19:27:42 GMT https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaq-p/9735451 Former Member 2013-09-24T19:27:42Z Re: HANA instead of SQL Server https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaa-p/9735452#M3486061 <HTML><HEAD></HEAD><BODY><P>Hi Mario,</P><P></P><P>You can build a visual .NET application on SAP HANA using ODBC / ODATA connectivity. Please refer to the <A href="http://help.sap.com/hana/SAP_HANA_SQL_Script_Reference_en.pdf">HANA SQL Script reference</A> for an example of connecting to HANA using C#.</P><P></P><P>Also refer to the document mentioned below for the .NET connectivity using ODBC.</P><P></P><P><A _jive_internal="true" class="active_link" href="https://answers.sap.com/docs/DOC-33628">http://scn.sap.com/docs/DOC-33628</A></P><P></P><P>Regards,</P><P></P><P>Ravi</P></BODY></HTML> Wed, 25 Sep 2013 04:46:45 GMT https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaa-p/9735452#M3486061 Ravi_Channe 2013-09-25T04:46:45Z Re: HANA instead of SQL Server https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaa-p/9735453#M3486062 <HTML><HEAD></HEAD><BODY><P>Hello Ravindra,</P><P></P><P>Thanks for your reply.</P><P></P><P>I'd also like to ask you if it's possible to migrate reports created with Reporting Services and procedures created with SQL Server to HANA. </P><P></P><P>How complex could that migration be?</P><P></P><P>Is it necessary to re-build the SQL Server procedures and reports?</P><P></P><P>Thanks a lot!</P><P></P><P>Mario.</P></BODY></HTML> Wed, 25 Sep 2013 13:36:51 GMT https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaa-p/9735453#M3486062 Former Member 2013-09-25T13:36:51Z Re: HANA instead of SQL Server https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaa-p/9735454#M3486063 <HTML><HEAD></HEAD><BODY><P>Hi Mario,</P><P></P><P>Please refer to the documents on some of the basic understanding on SQL Query and procedure migration.</P><P></P><P><A __default_attr="82977" __jive_macro_name="blogpost" class="jive_macro jive_macro_blogpost active_link" href="https://community.sap.com/" style="color: #2989c5;"></A></P><P><A __default_attr="39120" __jive_macro_name="document" class="jive_macro jive_macro_document" href="https://community.sap.com/"></A></P><P></P><P>As you know, there is some syntax difference between SQL Server and HANA SQL scripts, there could be some challenges on migrating the SQL Server procedures to HANA.</P><P></P><P>Depending upon how the reporting access the underlying database, (SQL Interface, Queries fired against the database, custom coding), you may have to modify the reports.</P><P></P><P>Regards,</P><P></P><P>Ravi</P></BODY></HTML> Wed, 25 Sep 2013 13:54:08 GMT https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaa-p/9735454#M3486063 Ravi_Channe 2013-09-25T13:54:08Z Re: HANA instead of SQL Server https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaa-p/9735455#M3486064 <HTML><HEAD></HEAD><BODY><P>Hello Ravi,</P><P></P><P>I have used in the past the SQL Converter Tool, which is very useful for simple queries. I'm also aware of some of the differences between SQL and HANA.</P><P></P><P>I just wanted to know how challenging it could be to migrate a complete system from SQL Server to HANA and you've answered my question. Thank you very much.</P><P></P><P>Regards,</P><P></P><P>Mario.</P></BODY></HTML> Wed, 25 Sep 2013 20:01:25 GMT https://community.sap.com/t5/technology-q-a/hana-instead-of-sql-server/qaa-p/9735455#M3486064 Former Member 2013-09-25T20:01:25Z