Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-21 : 07:52:29
|
| Peter writes "Can snapshot replication be done where there is no physical connection path available between the publisher and subscriber?The problem we are trying to address using SQL Server 2000 is as follows.We have a master database that has over 20 tables being maintained.At adhoc times we would like to distribute this data to other instances.There is no physical connectivity between the source and destination instances as they belong to different organisations.The delivery is most likely on CD.Can the distribution database be backed up onto the media and then restored at the destination.Secondly can this all be configured and controlled under stored procedures. My indication so far is that subscription can only be done under the Enterprise Manager. Very interested if the technique is possible otherwise the alternate is looking to be a merge process using bcpRegardsPeter" |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-11-21 : 13:01:52
|
Nothing like this currently exists (to my knowledge atleast... prove me wrong otherwise  ). If you moving via cd, your best option would be to back-up the database and move it over to the other server and restore. You could look into moving transaction logs in the future and just applying the transaction logs to the server your moving to (transactional sneaker net I guess). You could look into using bcp or DTS to export the data to a csv and then importing at the other server. Theres a few options I guess... None are that easy to implement though... Ya get to be creative. I guess microsoft assumes that computers sharing data should be networked together -----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
Tim
Starting Member
392 Posts |
Posted - 2002-11-24 : 19:42:09
|
snapshots can be distributed via offline media (incl CD) in SQL200 replication.Sounds like what you want.from BOL quote:
SQL Server 2000 enhances snapshot replication, transactional replication, and merge replication by adding: Alternate snapshot locations, which provide easier and more flexible methods for applying the initial snapshot to Subscribers. You can save (and compress) the snapshot files to a network location or removable media, which can then be transferred to Subscribers without using the network.
----Nancy Davolio: Best looking chick at Northwind 1992-2000 |
|
|
|
magro
Starting Member
2 Posts |
Posted - 2002-11-25 : 20:10:11
|
| I will look further into the distribution of snapshot replication, otherwise we will probably go with BCP out and then BCP into temp tables and then merge the data programatically.A bit more detail:-The master instance has 3 schemas with one that are we are looking at "copying into" other disconnected instances. The goal it to script the process as much as possible as the receivers of the updates desire a controlled "install" rather than a manual processThanksPeter |
|
|
|
magro
Starting Member
2 Posts |
Posted - 2002-11-25 : 20:17:16
|
quote:
Nothing like this currently exists (to my knowledge atleast... prove me wrong otherwise ). If you moving via cd, your best option would be to back-up the database and move it over to the other server and restore.
I had a bit of a look at backup/restore of specific files (we don't want to copy the full instance) but the restore says the transaction log needs to be applied after the restore, which for a different instance sounds like a no-go for that ideaPeter |
|
|
|
|
|
|
Remote Replication 