Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Replica sans attachments

Posted on 2004-09-29
8
Medium Priority
?
256 Views
Last Modified: 2013-12-18
I want to replicate some databases that are huge in size, primarily because of attachments. THere are replicas of the databases on user workstations. There is no utility of attachments on the workstation however they might want to work with the local database for read only purpose. Changes are not to be updated back to server. The no of workstations would be a couple and the required update frequency a couple of hours.

What is my solution?

Thanks for sharing your expertise.
0
Comment
Question by:RanjeetRain
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 9

Accepted Solution

by:
HappyFunBall earned 500 total points
ID: 12185236
When you setup the replica, would the option to replicate only the first 40KB of rich text help you?  I imagine you want something more customizable, but that is a very simple way to remove attachments in a replica.
0
 
LVL 19

Author Comment

by:RanjeetRain
ID: 12185283
Nope. Those workarounds aren't as neat as I want. 40K method ain't good anyway. These documents might be under 4K wihtout attachments. Why spend 40K?

Programmatic solution, is the first thing that comes to mind but also the last thing I am looking at.
0
 
LVL 9

Expert Comment

by:HappyFunBall
ID: 12186200
Actually, I just noticed in R6 there's an option to choose what size limit you want for attachments.  Try to create a new replica and click the More Options button before hitting OK.  Change the receive documents from server option to Partial Documents, then change the "Limit attachment size to" field to 0kbs.

It worked for me - documents were replicated but not the attachments.
0
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

 
LVL 19

Author Comment

by:RanjeetRain
ID: 12188058
Seems, it was necessary to give the version. R 5.0.3 - 5.0.8

HFB, that would just be what I am looking for. Could you please see if there is something of the same kind in R5?
0
 
LVL 9

Expert Comment

by:HappyFunBall
ID: 12193691
I've been looking around but can't find anything better than the < 40KB idea to use in R5.  I've been thinking about how to do this programmatically and that seems like a nightmare.

I'm reaching, I know, but if you have even one R6 server in the environment and people replicate with only that server then the attachment size limit idea could work.

I'll keep thinking...
0
 
LVL 19

Author Comment

by:RanjeetRain
ID: 12218686
Lets hope you come out with some smart workaround.
0
 
LVL 9

Expert Comment

by:HappyFunBall
ID: 12308439
I've been thinking about this now and then and nothing has come to mind.  I guess for a programmatic solution, you can create a database copy which users will replicate from.  This copy will be maintained by agents that update it from the original database.  Basically, you can just write an agent to do a loop through all docs of the original db.  During the loop, do a subloop that scans all the items in the original doc.  Copy all items to the database copy that are not of type RICHTEXT.  

Actually as I think about it, that isn't too bad of a workaround.  It shouldn't take too long to write that.  Let me know if you need help writing the agent.
0
 
LVL 19

Author Comment

by:RanjeetRain
ID: 12643498
Okay, time to close this one. Thanks for all the help HFB. I wish there was an easy way to do this without writing code. Thanks anyways.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question