Jump to content

Cloning database tables

NewsBot
 Share

Recommended Posts

NewsBot Newbie

NewsBot

Posted
Posted

If I have a database (SQL) with identical schemas on two seperate computers, how can I clone the contents of certain tables?

I already have a mechanism (in WCF) whereby I can send text between the computers.

Currently I have a fairly clumsy mechanism where the data is all loaded into a dataset, the XML of that dataset is sent over to the other machine, and then a fairly long parsing routine builds sql statements that re-insert the data on the other machine.

The key here is that the primary keys of the tables cannot be changed, they must be the same on both machines.

I bow to your superior knowledge for guidance...

 

 

More...

 

View All Our Microsoft Related Feeds

View All Our Microsft Related Feeds
  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...