<div>
Thanks Dan, thats a great idea. &nbsp;that way Unit testing can be done. &nbsp;It also is helpful to have a development environment.<br />
<br />
as soon as I posted this, I tried a few more queries in Google and found some good best practices for SQL in general. &nbsp;I can look at those and extrapolate from there.
</div>


Thanks Dan, thats a great idea.  that way Unit testing can be done.  It also is helpful to have a development environment.

as soon as I posted this, I tried a few more queries in Google and found some good best practices for SQL in general.  I can look at those and extrapolate from there.

<div>
Thanks for the feedback and your patience.
</div>


Thanks for the feedback and your patience.

<div>
<div class="content wysiwyg-content">
I'm trying to find some best practices for importing data into a SQL table. &nbsp;Not just any SQL table, but an existing table that is used in a complex application.<br />
<br />
What I mean by complex is that the table may have many constraints or a trigger or some other unforeseen complication.<br />
<br />
I tried a few google searches, but I'm just finding results on how to do inserts. <br />
<br />
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.<br />
<br />
How does this apply to different databases such as MSSQL, MySQL, DB2 Oracle, etcetera
</div>
</div>


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

MS SQL Inserting Data Best Practices

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.