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

[Chanty4u]

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

[Peter_Cammaert · Accepted solution]

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

[Chanty4u]

thnk u peter.

[petter]

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.