Remote synchronization

Hi
We are considering an access front end app with back end tables on sql
server in our office. Is there a way to have a copy this app on a laptop
for a tele-worker and have it synchronised from time to time using either a
3G data connection, or the office LAN when the tele-worker is in the office?
I presume we will have to make copies of both access front end and sql
server backend on the laptop and then the laptop sql server will synchronise
with the office sql server. Is there a better way to handle this?
Thanks
Regards
have a look at DB Ghost - http://www.dbghost.com - I use it to synchronize my
laptop with the production database when I'm online so I have a database at
all times to run reports on.
"John" wrote:

> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either a
> 3G data connection, or the office LAN when the tele-worker is in the office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
>
|||For occasional testing... I simply backup/restore or attach/detach... Mostly
I use backup/restore because the production database does not have to come
down ( and the backups are already made).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <John@.nospam.infovis.co.uk> wrote in message
news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the
office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will
synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
|||I was under the impression that sql server supports synchronisation...or is
replication something different?
Thanks
Regards
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uzGwBYHBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> For occasional testing... I simply backup/restore or attach/detach...
Mostly[vbcol=seagreen]
> I use backup/restore because the production database does not have to come
> down ( and the backups are already made).
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "John" <John@.nospam.infovis.co.uk> wrote in message
> news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
laptop[vbcol=seagreen]
either
> a
> office?
> synchronise
>

Remote synchronization

Hi
We are considering an access front end app with back end tables on sql
server in our office. Is there a way to have a copy this app on a laptop
for a tele-worker and have it synchronised from time to time using either a
3G data connection, or the office LAN when the tele-worker is in the office?
I presume we will have to make copies of both access front end and sql
server backend on the laptop and then the laptop sql server will synchronise
with the office sql server. Is there a better way to handle this?
Thanks
Regardshave a look at DB Ghost - http://www.dbghost.com - I use it to synchronize m
y
laptop with the production database when I'm online so I have a database at
all times to run reports on.
"John" wrote:

> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the offic
e?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will synchroni
se
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
>|||For occasional testing... I simply backup/restore or attach/detach... Mostly
I use backup/restore because the production database does not have to come
down ( and the backups are already made).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <John@.nospam.infovis.co.uk> wrote in message
news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the
office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will
synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>|||I was under the impression that sql server supports synchronisation...or is
replication something different?
Thanks
Regards
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uzGwBYHBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> For occasional testing... I simply backup/restore or attach/detach...
Mostly
> I use backup/restore because the production database does not have to come
> down ( and the backups are already made).
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "John" <John@.nospam.infovis.co.uk> wrote in message
> news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
laptop[vbcol=seagreen]
either[vbcol=seagreen]
> a
> office?
> synchronise
>

Remote synchronization

Hi
We are considering an access front end app with back end tables on sql
server in our office. Is there a way to have a copy this app on a laptop
for a tele-worker and have it synchronised from time to time using either a
3G data connection, or the office LAN when the tele-worker is in the office?
I presume we will have to make copies of both access front end and sql
server backend on the laptop and then the laptop sql server will synchronise
with the office sql server. Is there a better way to handle this?
Thanks
Regardshave a look at DB Ghost - http://www.dbghost.com - I use it to synchronize my
laptop with the production database when I'm online so I have a database at
all times to run reports on.
"John" wrote:
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either a
> 3G data connection, or the office LAN when the tele-worker is in the office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
>|||For occasional testing... I simply backup/restore or attach/detach... Mostly
I use backup/restore because the production database does not have to come
down ( and the backups are already made).
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <John@.nospam.infovis.co.uk> wrote in message
news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the
office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will
synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>|||I was under the impression that sql server supports synchronisation...or is
replication something different?
Thanks
Regards
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uzGwBYHBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> For occasional testing... I simply backup/restore or attach/detach...
Mostly
> I use backup/restore because the production database does not have to come
> down ( and the backups are already made).
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "John" <John@.nospam.infovis.co.uk> wrote in message
> news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> > Hi
> >
> > We are considering an access front end app with back end tables on sql
> > server in our office. Is there a way to have a copy this app on a
laptop
> > for a tele-worker and have it synchronised from time to time using
either
> a
> > 3G data connection, or the office LAN when the tele-worker is in the
> office?
> > I presume we will have to make copies of both access front end and sql
> > server backend on the laptop and then the laptop sql server will
> synchronise
> > with the office sql server. Is there a better way to handle this?
> >
> > Thanks
> >
> > Regards
> >
> >
>

Remote SQL server access

I'm writing a piece of software that is designed to access data from SQL server. The office's server has SQL server version 7 installed. The software works perfectly when running on a computer on the network in the office. I however am trying to work out how to use use the software from my home computer and connect to the SQL server database remotely. I've never done this before and I'm finding it hard to find the right information.

Firstly, is it easy to do this? What do I need to do with the server in the office to allow this to work? Do I need any extra hardware/software? How will my software connect to SQL server? Is it as simple as changing the connection string to something like the server's ip address and sql server name?

I'm writing the software in Visual Studio 2005 professional and programming in VB.

Many thanks.

Well, that depends.

"Firstly, is it easy to do this? "

Yes, this is not that hard. If you going through VPN or direct call connections using a dialin you don′t have to worry. Using the internet as the transport layer, you will have to consider your security archtitecture of your office as if you need to have access to your office you probably will need to open certain ports on the firewall which might protect your company from intruders.

"What do I need to do with the server in the office to allow this to work?"

Well assuming for the next questions that you will use a internet connection to connect to your office, you will need to have a (stateful) firewall configured in your office, which exposes the SQL Server Service to the outsides in some way. For security reasons you should consider locking you access to the office using certain security rules like IPSEC / Certificate bases transports etc.

"Do I need any extra hardware/software? "

That depends. using a firewall and the appropiate security mechanims, you won′t need additional stuff. Having a firewall which is able to do VPN, you will need to have a software which is able to establish a VPN tunnel. For the pure access to SQL Server you won′t need any additional software.

"How will my software connect to SQL server? Is it as simple as changing the connection string to something like the server's ip address and sql server name?"

Yes, thats right, after having a connection to your company network (either through the internet as described below or dial-ins) you can connect to your server easily by changing the servername within the connectionstring to the public name or the IPAdress (and eventually in addition the configured port)

Jens K. Suessmeyer

http://www.sqlserver2005.de|||

Thank you very much for your assistance. I will try this out in the office in the next couple of days. I'll post another message if I still have questions but hopefully it'll be fine.

Many thanks again,

Sam

Remote SQL server access

I'm writing a piece of software that is designed to access data from SQL server. The office's server has SQL server version 7 installed. The software works perfectly when running on a computer on the network in the office. I however am trying to work out how to use use the software from my home computer and connect to the SQL server database remotely. I've never done this before and I'm finding it hard to find the right information.

Firstly, is it easy to do this? What do I need to do with the server in the office to allow this to work? Do I need any extra hardware/software? How will my software connect to SQL server? Is it as simple as changing the connection string to something like the server's ip address and sql server name?

I'm writing the software in Visual Studio 2005 professional and programming in VB.

Many thanks.

Well, that depends.

"Firstly, is it easy to do this? "

Yes, this is not that hard. If you going through VPN or direct call connections using a dialin you don′t have to worry. Using the internet as the transport layer, you will have to consider your security archtitecture of your office as if you need to have access to your office you probably will need to open certain ports on the firewall which might protect your company from intruders.

"What do I need to do with the server in the office to allow this to work?"

Well assuming for the next questions that you will use a internet connection to connect to your office, you will need to have a (stateful) firewall configured in your office, which exposes the SQL Server Service to the outsides in some way. For security reasons you should consider locking you access to the office using certain security rules like IPSEC / Certificate bases transports etc.

"Do I need any extra hardware/software? "

That depends. using a firewall and the appropiate security mechanims, you won′t need additional stuff. Having a firewall which is able to do VPN, you will need to have a software which is able to establish a VPN tunnel. For the pure access to SQL Server you won′t need any additional software.

"How will my software connect to SQL server? Is it as simple as changing the connection string to something like the server's ip address and sql server name?"

Yes, thats right, after having a connection to your company network (either through the internet as described below or dial-ins) you can connect to your server easily by changing the servername within the connectionstring to the public name or the IPAdress (and eventually in addition the configured port)

Jens K. Suessmeyer

http://www.sqlserver2005.de|||

Thank you very much for your assistance. I will try this out in the office in the next couple of days. I'll post another message if I still have questions but hopefully it'll be fine.

Many thanks again,

Sam

Remote server connection

We have a database on a shared SQL Server stored on our ISP's server. I can
connect to this via Enterprise Manager from our office, but when I try the
same from Enterprise Manager on my PC at home I get the following message:

A connection could not be established to MFSERVER.

Reason: SQL Server is not running or access denied.

Any ideas?

ThanksHi

There is probably a firewall blocking port 1433.
Check with your network administrators.

Regards
----------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@.epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Mark Fisher" <mfisher@.uku.co.uk> wrote in message
news:%wGud.1214$uv1.177@.newsfe1-gui.ntli.net...
> We have a database on a shared SQL Server stored on our ISP's server. I
can
> connect to this via Enterprise Manager from our office, but when I try the
> same from Enterprise Manager on my PC at home I get the following message:
> A connection could not be established to MFSERVER.
> Reason: SQL Server is not running or access denied.
> Any ideas?
> Thanks