Experts invited! Is there a good way?

Category: MS-SQL Server -> Foundation Classes Author: qzq000168 Date: 2011-09-13 09:04:16
 
qzq000168
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)
xihawuzu
2011-09-13 09:16:25
Backup Restore
yaoyao254765804
2011-09-13 09:34:17
sql server data replication and distribution
andy12354
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!
zangxinxuan
2011-09-13 09:44:51
Use SqlServer DTC's deal with it
a1989802500
2011-09-13 10:00:47
DTS is king.
xx313327885
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?
FENG852297014
2011-09-13 10:26:29
ready copies, daring to lead it! Access points
kaka46912
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