|
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
|
|
|
|
|
What database server are you using?
|
|
|
|
|
You can also user the SQL import Export wizard to transfer the data from one database to other database either table wise of bulk
|
|
|
|