topic Re: Moving from Oracle to Sql Server Database in QlikView https://community.qlik.com/t5/QlikView/Moving-from-Oracle-to-Sql-Server-Database/m-p/1354136#M842577 <HTML><HEAD></HEAD><BODY><P>once it is created ,</P><P></P><P>Raise a access request for <STRONG>SQL server</STRONG> DB.</P><P>depends on DB team advice Ask them install sql server client edition in your machine.</P><P>Try to create <STRONG>ODBC connection</STRONG> for new data base <STRONG>Sql server</STRONG> as per your credentials</P><P>and check the check box for <STRONG>Preceding load</STRONG> option.</P><P>and work as it is before you did with Oracle.</P><P></P><P>Only <STRONG>ODBC</STRONG> connection you need to change in <STRONG>Include file/Connections.</STRONG></P></BODY></HTML> Fri, 21 Apr 2017 07:39:19 GMT ramasaisaksoft 2017-04-21T07:39:19Z Moving from Oracle to Sql Server Database https://community.qlik.com/t5/QlikView/Moving-from-Oracle-to-Sql-Server-Database/m-p/1354134#M842575 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I wanted to know what are the things that needs attention from QlikView point of view when changing the database.</P><P>Currently, we are using Oracle and planning to move to Sql Server. QV version 12.10 SR1</P><P>All that I can think of is changing the connection string.</P><P></P><P>Can you please provide your inputs on this?</P><P></P><P>Thanks you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Moving-from-Oracle-to-Sql-Server-Database/m-p/1354134#M842575 aarohipatel 2020-11-25T16:16:04Z Re: Moving from Oracle to Sql Server Database https://community.qlik.com/t5/QlikView/Moving-from-Oracle-to-Sql-Server-Database/m-p/1354135#M842576 <HTML><HEAD></HEAD><BODY><P>Look at the sql statement, sometimes the syntax is different</P><P></P><P><A href="http://www.dba-oracle.com/oracle_news/2005_12_16_sql_syntax_differences.htm" title="http://www.dba-oracle.com/oracle_news/2005_12_16_sql_syntax_differences.htm">SQL Syntax differences between Oracle -&nbsp; MS-SQL</A></P><P>or here</P><P><A href="https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htm" title="https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htm">Microsoft SQL Server and Oracle Compared</A></P></BODY></HTML> Thu, 20 Apr 2017 18:37:39 GMT https://community.qlik.com/t5/QlikView/Moving-from-Oracle-to-Sql-Server-Database/m-p/1354135#M842576 maxgro 2017-04-20T18:37:39Z Re: Moving from Oracle to Sql Server Database https://community.qlik.com/t5/QlikView/Moving-from-Oracle-to-Sql-Server-Database/m-p/1354136#M842577 <HTML><HEAD></HEAD><BODY><P>once it is created ,</P><P></P><P>Raise a access request for <STRONG>SQL server</STRONG> DB.</P><P>depends on DB team advice Ask them install sql server client edition in your machine.</P><P>Try to create <STRONG>ODBC connection</STRONG> for new data base <STRONG>Sql server</STRONG> as per your credentials</P><P>and check the check box for <STRONG>Preceding load</STRONG> option.</P><P>and work as it is before you did with Oracle.</P><P></P><P>Only <STRONG>ODBC</STRONG> connection you need to change in <STRONG>Include file/Connections.</STRONG></P></BODY></HTML> Fri, 21 Apr 2017 07:39:19 GMT https://community.qlik.com/t5/QlikView/Moving-from-Oracle-to-Sql-Server-Database/m-p/1354136#M842577 ramasaisaksoft 2017-04-21T07:39:19Z