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 |
|
jaycee
Starting Member
18 Posts |
 Posted - 2012-02-19 : 05:22:07
|
| I am about to start in a new company. They have an Access db in UK, Aus & Canada. Data is transferred by ftp and uploaded into the Head Office UK Access db manually. Aus and Canada only need their own data but the UK needs it all. As yet I've not seen the size of the dbs but would guess at 300000 records in each, size about 2Gb. I want them to move to SQL Server ASAP. Is the best way to create router based VPN, set up SQL Server replication and code a .Net interface? Any suggestions? thanks. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-02-19 : 06:35:13
|
| The method you're proposing would work. One other option is to have the one sql server - which all countries access. Is there a specific reason - why Aus and Canada can't access the data based on a UK based server? One problem , I can see is performance . Depending on the type of data manipulation , the response may be slow.Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
jaycee
Starting Member
18 Posts |
Posted - 2012-02-19 : 07:41:56
|
| Thanks for that. No, there's no reason why the server can't be uk based - I guess we're then talking an asp/php front end. when you say there would be a performance problem, are you talking performance with replication or uk based server option? I guess uk server based would have to use a very fast connection for returning data, not having used replication over a vpn internationally I wouldn't know. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-02-20 : 01:42:52
|
| In that scenario , testing is required. Over vpn, I've had mixed success with UK to US.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
jaycee
Starting Member
18 Posts |
Posted - 2012-02-20 : 04:55:53
|
| Thanks for your help Jack. |
|
|
|
jaycee
Starting Member
18 Posts |
Posted - 2012-02-20 : 05:01:07
|
| Just come across something which is presumably new to sql 2008 R2 - Web Synchronization for Merge Replication. I don't suppose you (or anyone else) have any experience of this Jack? Thanks, Jim. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-02-21 : 01:31:06
|
| It has good potential for your purpose - you're discussing. It gets around the problem - if you have a strict firewall. Based on my experience - transfering large volumes of data is more challenging - and requires some extra configurations and experimentingJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
jaycee
Starting Member
18 Posts |
Posted - 2012-02-23 : 08:37:11
|
| Many thanks - I'll see how I get on. |
|
|
|
|
|
|
|
|
Move from Access to SQL Server in countries