<div>
Are there foreign keys and/or primary keys defined on the tables? Do they autonumber (IDENTITY)?
</div>


Are there foreign keys and/or primary keys defined on the tables? Do they autonumber (IDENTITY)?

<div>
In other words, could you script out the tables with Enterprise Manager and post them here?
</div>


In other words, could you script out the tables with Enterprise Manager and post them here?

<div>
yes they do autonumber, iam not sure what the table looks like yet, but its pretty much standard stuff with primary and foriegn keys
</div>


yes they do autonumber, iam not sure what the table looks like yet, but its pretty much standard stuff with primary and foriegn keys

<div>
<div class="content wysiwyg-content">
What is the best way to move parent child(multiple) data to from one db to another using code C# or t-SQL in one transaction (if this is a good idea)<br />
&nbsp;
</div>
</div>


What is the best way to move parent child(multiple) data to from one db to another using code C# or t-SQL in one transaction (if this is a good idea)
 

Best way to move parent child data from one db to another

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.