Experts invited! Is there a good way?

Category: MS-SQL Server -> Foundation Classes Author: qzq000168 Date: 2011-09-13 09:04:16
2011-09-13 09:04:16
Software c # + sql server local area network software
now need a project to import, export functions.
units of a whole project information into the unit 2 database, project information can not conflict, higher efficiency.
my thoughts (sqlserver <-> access <-> sql server)
2011-09-13 09:16:25
Backup Restore
2011-09-13 09:34:17
sql server data replication and distribution
2011-09-13 09:38:42
MSSQL database comes with data import and export functions, as long as you use on it, a conflict, the table must be keyword!
2011-09-13 09:44:51
Use SqlServer DTC's deal with it
2011-09-13 10:00:47
DTS is king.
2011-09-13 10:15:32
connect to connect two database servers using the database a data import dataset1 inside, will Database 2 data import dataset2 inside. And then how to deal with not that any of you fish up?
2011-09-13 10:26:29
ready copies, daring to lead it! Access points
2011-09-13 10:36:48
Using SQL Server database replication from the primary server to the specified database objects (data, tables, and even stored procedures, etc.) is copied to another machine. Very efficient, but you can not copy a subscription database objects and data over any changes, otherwise the entire replication stopped