Database to Database

L

lothos12345

Well-known member
Joined
May 2, 2002
Messages
294
Location
Texas
I want to develop a program using Visual Basic.NET to pull data from one database and load the data into another. A database that is an exact copy of database that the data is being pulled from. However the database is relational and as data in multiple tables regarding the same record. The data that the program will be pulling from will be off of a query in the orginal database. I also want to continually add data to the copy database from the The database is a Microsoft Access database and I truly have no ideal were to begin as far as writing the program. Any help given would be greatly appreciated and as always thank you in advance.
 
I didnt understand ur post. Do you need a program that copies data from one database to another, or a program that keeps the two database synchronized, ie. when data is inserted in one db, the program copies the new/updated data the the second one?
 
Access has Replication built into it. Why do you want to re-implement it? Why not just go to Tools->Replication->Create Replica and then syncronize every so often?
 
I have data the I want to delete from the original database and move it into the copied one. However the database is relational and every table contains information regarding a single record. I need a quick and easy way to accomplish the moving of a record from one database to another. And both databases are Microsoft Access. Any help given is greatly appreciated and I thank you in advance.
 
Help

I have data the I want to delete from the original database and move it into the copied one. However the database is relational and every table contains information regarding a single record. I need a quick and easy way to accomplish the moving of a record from one database to another and deleting that record from the original database once the record has been moved to the duplicate database. And both databases are Microsoft Access. And to do this automatically as opposed to manually is a great time saver. Any help given is greatly appreciated and I thank you in advance.
 
Create your two Access databases then use the capabilities of
ADO.net, create two datasets: one for the original and one for
the copy.

Then:

Dim dr As DataRow = DataSet1.Tables("TableName").Rows.Item(0)

Using the addrow method (DataSet2.Tables("TableName").Rows.Add(dr) )you can
add a row to the dataset that represents the copy (assumed here to be dataset2)
of your database.


To delete the row from the original, use the deleterow method (dataset1.Tables("TableName").Rows(0).Delete())
will let you delete the row from the original table.


From the posting dates, looks like youve been working on this for
a while....hope this helps.
 
Back
Top