topic Re: migrating the database from MS-SQL 2008 to MS-SQL 2012. in QlikView

migrating the database from MS-SQL 2008 to MS-SQL 2012.

Chanty4u — Tue, 26 May 2015 13:05:28 GMT

hi guys need urgent help...

migrating database from MS-SQL 2008 TO MS-SQL2012

I need your help to identify columns used by QlikView dashboard that is not/has not migrated to MS-SQL 2012.

How can i do dis task tel me the process and steps urgent

thanks .

suresh

Re: migrating the database from MS-SQL 2008 to MS-SQL 2012.

Peter_Cammaert — Tue, 26 May 2015 13:19:38 GMT

That's not a quickie, so it doesn't matter whether it's urgent or not. You'll have to sit down and think it over.

Two tips off the top of my head:

Scan your script for tables and fields and make an inventory. Then compare to what is available (already)
Extract the script and put it in a new document. Change the CONNECT string to connect it to the new DB. Run the script until you get a FieldNotFound error. Comment that field, and run the script again. Repeat.

I don't think the Governance Dashboard offers you lineage information up until the very database tables and fields. Anyone has more experience with this?

Peter

Re: migrating the database from MS-SQL 2008 to MS-SQL 2012.

Chanty4u — Tue, 26 May 2015 13:41:25 GMT

thnk u peter.

Re: migrating the database from MS-SQL 2008 to MS-SQL 2012.

petter — Tue, 26 May 2015 17:47:47 GMT

You have the option of turning on ODBC tracing if you are using Microsofts ODBC driver not the OLEDB-driver and then analyse the resulting logs. But it is not a thing done in a hurry if you have never done it before.