Data validate tools (ETL tools) for SQL server
Posted
by Stan
on Stack Overflow
See other posts from Stack Overflow
or by Stan
Published on 2010-05-14T21:44:00Z
Indexed on
2010/05/16
13:30 UTC
Read the original article
Hit count: 388
sql-server
|validation
I have some data in Excel and need to import into database. Is there any tool that can validate and maybe clean the data? Does Red Gate have such tool?
The input will be Excel. Given table constraints, eg. CHECK, UNIQUE KEY, datetime format, NOT NULL. Desire output should be as least shows which lines are having problems, and then fix some trivial error automatically, like fill in default value for NULL columns, automatically correct datetime format.
I know using Python can build such a script. But just wonder what's the popular way to do this. Thanks.
© Stack Overflow or respective owner