MS SQL Inserting Data Best Practices
Posted on 2014-03-07
I'm trying to find some best practices for importing data into a SQL table. Not just any SQL table, but an existing table that is used in a complex application.
What I mean by complex is that the table may have many constraints or a trigger or some other unforeseen complication.
I tried a few google searches, but I'm just finding results on how to do inserts.
I know that one cannot just blindly start importing data into a system because all kinds of havoc can be done without careful planning and data quality checks.
How does this apply to different databases such as MSSQL, MySQL, DB2 Oracle, etcetera