从database1到数据库2的批量插入 [英] Bulk insert from database1 to database 2

问题描述

由于我需要像我尝试的那样从一个数据库批量插入到另一个数据库(两个数据库的结构相同)，但是外键和主键约束让我感到惊讶，所以任何人都可以帮助我在vb.net中从database1到database2批量插入.



将不胜感激！

Hi,

As i need to bulk insert from one database to another database (both database is in same structure) as i tried but foreign keys & primary keys constraints r freaking me out can any one help me to bulk insert from database1 to database2 in vb.net



will be appreciated!!

推荐答案

尝试:
1.正确看一下数据库设计.按顺序创建表列表，其中最低的表具有最大的依赖性，而最高的表曾经是仅具有主键的主表.
2.按从上到下的顺序填充/迁移表-首先是主表，然后是从属表.

Try:
1. Have a look at the database design properly. make a list of tables in a sequence where the lowest tables having maximum dependencies and top once being kind of master table with only primary keys.
2. Populate/Migrate the table from top to bottom order - First the master tables and then the dependent tables.

这篇关于从database1到数据库2的批量插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！