SQL Server database sync with another database table
I have 2 tables. The 1st table is just a normal table in a database inside SQL Server. The 2nd table is also a table in a database except that it belong to Sha开发者_开发知识库rePoint 2007 and is not known even though one can go to the SharePoint site to see that it belong to a SharePoint Form library.
My question is how to auto-sync these two tables together? (At anytime, the two table must contain the same information.)
You can synchronize databases with SQL Server Replication.
Best Regards
精彩评论