question about database relationships

  • Thread starter Thread starter Sean McKaharay
  • Start date Start date
S

Sean McKaharay

I have 2 disconnected servers I need to take new data from server 1 to
server 2. I am exporting the data from server1 to xml. My thought was going
to import the xml into a dataset then do bulk insert and updates, but to do
that I need to find out what order the tables need to be loaded so I don't
break any constraints. Does anyone know how I can get that order?

Sean
 
Sean,

This all depends on the underlying data store. If you need to do this
in a generic way, you should use COM interop and use the ADOX libraries,
which will get you schema information about a database, which you can then
use to make your determinations about order.

Hope this helps.
 
Back
Top