index > Windows Forms Data Controls and Databinding > how to update tables data one server to another using vb.net

how to update tables data one server to another using vb.net

There are 2 servers serverA and serverB.
I want to update tables data to serverA to ServerB.

thanks

Ather

Ather.Abbas Tuesday, August 18, 2009 5:09 AM

It would get quite complicated to achieve what you want using Windows Forms and .NET
I would suggest you to try Database Mirroring or Replication services provided by SQL2005 and above.

Database Mirroring in SQL 2005
SQL Server Replication

Goodluck,
Regards,
Mohib Sheth

Life would have been much easier if I had the source-code !!

Marked As Answer byAland LiMSFT, ModeratorFriday, August 21, 2009 2:02 AM

Mohib Sheth Tuesday, August 18, 2009 5:47 AM

No I dont think so. Since you are new to all this.. I would suggest you to with a Step-By-Step tutorial.

SQL Server 2005 - Replication Step by Step Procedure (SQL2005)

Setting Up Replication: A Step-by-step Guide (SQL2000)

Goodluck :)
Regards,
Mohib Sheth

Life would have been much easier if I had the source-code !!

Marked As Answer byAland LiMSFT, ModeratorFriday, August 21, 2009 2:02 AM

Mohib Sheth Thursday, August 20, 2009 10:34 AM

It would get quite complicated to achieve what you want using Windows Forms and .NET
I would suggest you to try Database Mirroring or Replication services provided by SQL2005 and above.

Database Mirroring in SQL 2005
SQL Server Replication

Goodluck,
Regards,
Mohib Sheth

Life would have been much easier if I had the source-code !!

Marked As Answer byAland LiMSFT, ModeratorFriday, August 21, 2009 2:02 AM

Mohib Sheth Tuesday, August 18, 2009 5:47 AM

is this complicated to web as well?

Ather

Ather.Abbas Tuesday, August 18, 2009 6:37 AM

Thanks for your reply. Can you tell me that the followingcodeis work on Windows XP?
http://www.devbuzz.com/Articles/zinc_sql_merge_replication_pg1.aspx

Ather

Ather.Abbas Thursday, August 20, 2009 9:22 AM

No I dont think so. Since you are new to all this.. I would suggest you to with a Step-By-Step tutorial.

SQL Server 2005 - Replication Step by Step Procedure (SQL2005)

Setting Up Replication: A Step-by-step Guide (SQL2000)

Goodluck :)
Regards,
Mohib Sheth

Life would have been much easier if I had the source-code !!

Marked As Answer byAland LiMSFT, ModeratorFriday, August 21, 2009 2:02 AM

Mohib Sheth Thursday, August 20, 2009 10:34 AM

You can use google to search for other answers

Custom Search

More Threads

• DataGrid From 2 Tables but cannot bind second table to

• How do I call this.tableadapter.update without knowing which table adapter?

• When to get data from the database

• DataGridViewCheckBoxColumn and CellTemplate.Value

• ObjectDataSource Wizard Problem

• Passing paremeters in SQL DataSource

• Make image field empty (in SQL table)

• Get SQLCommand Collection from TableAdapter

• How to avoid de-selection of a row (in a datagridview), when user clicks on it along with Ctrl key of the keyboard.

• Control must loose focus to commit data