How to mearge local database with server database
-
I use two database one is local server because there internet is not available. another is on global server my problem is that how to update local database on global database.
-
I use two database one is local server because there internet is not available. another is on global server my problem is that how to update local database on global database.
Do some research into "replication" this may meet your needs or you can script the data transfer. There is no simple way to "merge" 2 databases. You may also look into Data Compare from Red Gate but I don't think that is going to be the tool.
Never underestimate the power of human stupidity RAH
-
I use two database one is local server because there internet is not available. another is on global server my problem is that how to update local database on global database.
What database server are you using?
-
What database server are you using?
sql server 2008 r2
-
sql server 2008 r2
Try Sync Framework http://msdn.microsoft.com/en-us/sync/bb736753.aspx[^]
-
I use two database one is local server because there internet is not available. another is on global server my problem is that how to update local database on global database.
You can also user the SQL import Export wizard to transfer the data from one database to other database either table wise of bulk