New SQL data Input - need to validate field names, formats, field lengths etc

[rmwillis1973]

Hi,

Probably a simple answer to this one, but I can't locate the correct tool to do this task, so any help would be much appreciated.

We have an existing data connection in SQL, which pulls all of our data (SQL table is called fact_invoice).  We are having a new sales system implemented imminently.  The data is also going to be put into the same SQL database (the new table will be called fact_invoice_New).

The part I'm struggling with is to audit the fields, their format and length, to make sure they are all consistent between the 2 tables, in case some are missing or have different headings.

I have about 50 of these tables to do, so need a way to repeat it.

I want to flag the differences, so i can alert the IT team of mismatches.

Thanks.

[patrick_mcauliffe · Accepted solution]

You can use the Field Info tool.

Create a data input for each of the old and new tables.

Connection to a Field Info tool and and join on Field Name. 

Then a filter that returns true if type_old != type_new or size_old != size_new, etc.

[rmwillis1973]

Thank you Patrick.  A perfect solution!  It gives us exactly what we need.