off-site adp

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steel - 24 Aug 2005 05:58 GMT

Hi,
I am putting together a project for a client as follows:
1. Client HQ: SQL Server 2000 database + SQL Reporting Services
2. Client Site: ADP front-end --> SQL db (Client HQ)
3. ADP front-end --> URL link to Reporting db

My issue is due to the dial-up connection speed at the Client Site. I am
converting all adp Reports to SQL Reporting to help limit the size of the ADP
front-end. The ADP tables are linked to the Client HQ SQL db.

Is it best to use MSDE at Client Site and have MSDE and SQL Server
synchronise to help with download speeds - or is the solution I currently
have the best one?

Thank you.

Signature

Regards,

Steel

Reply to this Message

Peter Yang [MSFT] - 24 Aug 2005 08:15 GMT

Hello Steel,

I think it depends on if there is frequent update on the backend db. If the
update is not so frequently, the load of sync between MSDE and backend SQL
server bring less load.

In addition, it depends on how many users use the ADP client concurrently.
Since clients can query the same msde db on client side, Using SQL
replication could drop load of current access to HQ SQL server from
clients.

You have to balance these according to your own situation.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

| Thread-Topic: off-site adp
| thread-index: AcWoaGdoWvgc2BMcQwCzUvDRUz85dQ==
[quoted text clipped - 34 lines]
|
| Thank you.

Reply to this Message

steel - 24 Aug 2005 09:01 GMT

Peter,

Thanks for your reply - so quick!

To delve a little further. If the Clients @ Site are using different PC's
does one of them become the 'master' MSDE that links to the HQ db, while the
'slave' PC's link to the 'master'?

When the 'master' PC first loads the ADP project database the project links
to the HQ db to retrieve the objects (Tables, views, etc...). Can this object
structure be stored on the Client @ Site PC during installation of the ADP
project on their PC? So when the project is Opened the project looks to the
HQ db for changes only. Is this possible?

Thank you again.

Signature

Regards,

Alan

> Hello Steel,
>
[quoted text clipped - 62 lines]
> |
> | Thank you.

Reply to this Message

Peter Yang [MSFT] - 25 Aug 2005 03:46 GMT

Hello Alan,

Per you question, you may only configure a 'master' MSDE on client site
which replicates with HQ server. All other client ADP only uses this master
MSDE as if it is the server in HQ.

You may consider transactional r merged replication according to the
feature of the database you want. All the objects have the same copy in
both HQ and client site. Please refer to "Merge Replication or Updatable
Subscriptions" in SQL Books Online for more details.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

| Thread-Topic: off-site adp
| thread-index: AcWogfiCXHdDCqBuQm6GvDecjybJMQ==
| X-WBNR-Posting-Host: 203.10.231.231
| From: "=?Utf-8?B?c3RlZWw=?=" <steel@community.nospam>
| References: <3F1E4587-DAB8-4E38-8D6E-A2999564B843@microsoft.com>

<tWQeguHqFHA.2152@TK2MSFTNGXA01.phx.gbl>

Reply to this Message