Replication concept

Hi,
I got a new application with Access front end and sql server back-end. This
application has replication features where users can directly upload their
changes on the main server. I have no knowledge about replication. However, I
need to maintain this sytem. Is there any article or book that will help me
achieve this? Please let me know. Thanks in advance.
Are you sure that this is being replicated? If users are sending their access
changes to sql server, it sounds like this might be the way that the Access
application is designed, and not SQL Server replication. If it is somehow SQL
Server Replication, then there are 2 books out there (see
www.replicationanswers.com for links on homepage) and books on line (BOL).
Cheers,
Paul Ibison
|||Thanks Paul for your advise. I appreciate it.
Best Regards,
"Paul Ibison" wrote:

> Are you sure that this is being replicated? If users are sending their access
> changes to sql server, it sounds like this might be the way that the Access
> application is designed, and not SQL Server replication. If it is somehow SQL
> Server Replication, then there are 2 books out there (see
> www.replicationanswers.com for links on homepage) and books on line (BOL).
> Cheers,
> Paul Ibison
>
|||Hope the books help, but I'd check first of all verify that you do have
replication occurring. It's possible that heterogenous subscribers have been
configured so your Access database is a subscriber to a SQL Server publisher,
and the uploading of changes in Access is a triggering of the synchronization
process (starting the ActiveX control to merge a pull subscription). Having a
look at the SQL Server box should show if this is the case and if so, looking
for heterogenous subscribers in BOL should help.
Paul Ibison
|||I would check to see if they have linked tables or if they have code in the
access project to write to SQL Server.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:2F158A54-ACE0-4C5B-913E-AD13C89DEF19@.microsoft.com...
> Hi,
> I got a new application with Access front end and sql server back-end.
> This
> application has replication features where users can directly upload their
> changes on the main server. I have no knowledge about replication.
> However, I
> need to maintain this sytem. Is there any article or book that will help
> me
> achieve this? Please let me know. Thanks in advance.
>

Replication and Log shipping

Sql server 2005 heavily hit database
Plans
1)Create a replicated databases to let users with query only access
2)Log shipping to allow a 4hour lag time with Disaster recovery just in
case
users gaff..
Your opinion
1)Transactional replication
2)Log shipping with a stagger of 4 hours
Not done this and wondering are there things to watch out for?
Are there better ways to go about this?
Is replication and log shipping in 2005 configured as a single setup?
Again your time and ideas are appreciated as alwaysI would create database snapshots on the local server if you have a large
tempdb and lots of memory. Otherwise I would use replication.
With log shipping your exposure to data loss if in excess of 4 hours. When
you apply the log you will have to kick your users off the system as you
apply the log to the database. With replication you can put user indexes on
the replicated subscriber database to offer better querying performance.
With log shipping the database is read only - you can't create indexes
there.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Massa Batheli" <mngong@.gmail.com> wrote in message
news:1159285642.485892.323850@.b28g2000cwb.googlegroups.com...
> Sql server 2005 heavily hit database
> Plans
> 1)Create a replicated databases to let users with query only access
> 2)Log shipping to allow a 4hour lag time with Disaster recovery just in
> case
> users gaff..
> Your opinion
> 1)Transactional replication
> 2)Log shipping with a stagger of 4 hours
> Not done this and wondering are there things to watch out for?
> Are there better ways to go about this?
> Is replication and log shipping in 2005 configured as a single setup?
> Again your time and ideas are appreciated as always
>|||Massa,
I did an article a while back that will help you decide between the 2
options: http://www.replicationanswers.com/Standby.asp.
As you're using SQL Server 2005, I'd also add a couple more options for you
to consider looking at:
(a) Mirroring and database snapshots
(b) READ_COMMITTED_SNAPSHOT option to transactional replication as a
variant on the standard Transactional Replication
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Thanks Folks for your time and great ideas ...............
Paul Ibison wrote:
> Massa,
> I did an article a while back that will help you decide between the 2
> options: http://www.replicationanswers.com/Standby.asp.
> As you're using SQL Server 2005, I'd also add a couple more options for you
> to consider looking at:
> (a) Mirroring and database snapshots
> (b) READ_COMMITTED_SNAPSHOT option to transactional replication as a
> variant on the standard Transactional Replication
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .

Replication and direct updating in SQL 2000

I have taken over the support over a database in sql 2000 that has 10+ remote users that synchronise each day. However it also has 30+ users who are directly updating the data in the live database on the server.

One of these users is entering data directly upon the database on the server but the new rows are being placed in the conflict table somehow!!

Does anybody have any ideas about how this could be happening ?

Is it ok to have users directly updating on the server and users synchronising ?

I would appreciate any help!!

Thanks.

If a change causes a conflict, then it will be placed in the conflict tables. YOu can look at the Conflict Viewer to determine what columns/rows are causing conflicts.

I assume this is merge replication? Users can make changes at publisher or subscriber, it is totally up to you to decide where to make changes.

Replication - Changes to Server databases impact to local database

We have a SQLSERVER database that is replicated to many users.
We are currently in an expansion phase where we need to make changes
to the server database. Each time we rollout a new release, we are
deleting the local replicating database and recreating.

Is there any way to automatically transfer the changes from the server
to existing local database without deleting?dipillama@.nswccd.navy.mil (Michael diPilla) wrote in message news:<4e67e68b.0308181234.4c8e5e98@.posting.google.com>...
> We have a SQLSERVER database that is replicated to many users.
> We are currently in an expansion phase where we need to make changes
> to the server database. Each time we rollout a new release, we are
> deleting the local replicating database and recreating.
> Is there any way to automatically transfer the changes from the server
> to existing local database without deleting?

It's not clear what you mean by 'changes' - changes to table
structures can be replicated if you make them through the publication
properties dialogue.

I'd suggest you post this in microsoft.public.sqlserver.replication,
as you'll probably get a better answer there.

Simon

Replicating users and privileges...

Hi,
In my publisher database I have defined an user with restricted privileges.
This user is "used" by the user interface application to connect to the
database. How can I replicate this user and restrictions to the subscriber?
Should I script this on a post-snapshot script? Is any other automatic
solution?
Thanks in advance
Faustino Dina
If my email address starts with two 'f'
drop the first 'f' when mailing me.
Faustino,
there's no automatic solution for this, as we can't replicate system tables.
You could use :
a pre-snapshot script,
a post-snapshot script,
sp_addscriptexec,
DTS,
linked servers.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Replicating to over 70 databases...why??

Is this reasonable or is this poor design...why not just a few power servers
and all users have high speed internet connections or at least DSL'
Thanks
Ken S.Think you will have to explain your situation a little more to get any good
feedback
Ray Higdon MCSE, MCDBA, CCNA
--
"SMAN" <ksanti@.nycap.rr.com> wrote in message
news:O1ct4n9AEHA.2404@.TK2MSFTNGP11.phx.gbl...
> Is this reasonable or is this poor design...why not just a few power
servers
> and all users have high speed internet connections or at least DSL'
> Thanks
> Ken S.
>

Replicating to over 70 databases...why??

Is this reasonable or is this poor design...why not just a few power servers
and all users have high speed internet connections or at least DSL'
Thanks
Ken S.Think you will have to explain your situation a little more to get any good
feedback
--
Ray Higdon MCSE, MCDBA, CCNA
--
"SMAN" <ksanti@.nycap.rr.com> wrote in message
news:O1ct4n9AEHA.2404@.TK2MSFTNGP11.phx.gbl...
> Is this reasonable or is this poor design...why not just a few power
servers
> and all users have high speed internet connections or at least DSL'
> Thanks
> Ken S.
>

Replicating Permissions

My reports are currently configured so that only certain users on the
domain can access certain reports. I have installed another server at
a remote location that will need to have the same permissions as the
first one. Is there a way to replicate the security settings without
having to set the permissions manually each time?
Is there a security configuration file somewhere on the first server
that i could move over to the second, since they are pretty much the
same?
Thank you!You may want to check the following tool courtesy of Jasper Smith:
http://www.sqldbatips.com/showarticle.asp?ID=62
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"muris" <rmuris@.hotmail.com> wrote in message
news:1113533808.430998.255460@.f14g2000cwb.googlegroups.com...
> My reports are currently configured so that only certain users on the
> domain can access certain reports. I have installed another server at
> a remote location that will need to have the same permissions as the
> first one. Is there a way to replicate the security settings without
> having to set the permissions manually each time?
> Is there a security configuration file somewhere on the first server
> that i could move over to the second, since they are pretty much the
> same?
> Thank you!
>|||Thanks for your Reply. The app you refered me to helps me replicate
the reports and user roles to multiple servers, but it does not
replicate the security permissions for each folder nor the report. Is
there a script that can accomplish this task?
Thanks!|||Jasper Smith may add this kind of functionality to the tool in a future
release.
On RS 2000 you would have to do this through the SOAP API (ListChildren,
GetProperties, GetPermissions, etc.)
The Management Studio for the upcoming SQL Server 2005 release of Reporting
Services will allow you to generate a script to capture that state and then
apply it to another server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"muris" <rmuris@.hotmail.com> wrote in message
news:1113572435.510884.55430@.z14g2000cwz.googlegroups.com...
> Thanks for your Reply. The app you refered me to helps me replicate
> the reports and user roles to multiple servers, but it does not
> replicate the security permissions for each folder nor the report. Is
> there a script that can accomplish this task?
> Thanks!
>

Replicating MSDE & SQL2000

Hi All,
What is the best way to merge/replicate SQL2000 & MSDE? We have an app that
laptop users will be running locally when not connected to the network.
When they come into the office we want their local DB on their laptop which
would be MSDE to connect to the SQL2000 Server and the 2 databases to update
each other.
Any references/websites addressing this would be great.
Thanks
Lee
I think you will want to use merge replication. It was designed for just
this kind of situation. Replication is a rather broad topic. The BOL has
lots of information. I would recommend setting up a couple of test databases
and experimenting with replication, just to get familiar with it.
Jim
"Lee Trotter" <latrotter@.@.@.sympatico.ca> wrote in message
news:epJHkFLVEHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> What is the best way to merge/replicate SQL2000 & MSDE? We have an app
that
> laptop users will be running locally when not connected to the network.
> When they come into the office we want their local DB on their laptop
which
> would be MSDE to connect to the SQL2000 Server and the 2 databases to
update
> each other.
> Any references/websites addressing this would be great.
> Thanks
> Lee
>