I don't intend to touch anything on the database level unless it will be impacted by the syncing of codes. So I think I will only impact the views and I have to recreate them. Thanks for your help on this. I appreciate it.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthik Sent: Monday, March 17, 2014 9:14 PM To: arslist@ARSLIST.ORG Subject: Re: Syncing Remedy codes ** Furthermore, if a replication is used at DB level, that most likely would get broken as well. - Karthik On Mar 17, 2014 6:42 PM, "Karthik" <karthik...@gmail.com<mailto:karthik...@gmail.com>> wrote: You could identify all views and grants needed and create a script to be used to provide all grants after every code sync. This way it would be easy to maintain. - Karthik On Mar 17, 2014 6:30 PM, "Misi Mladoniczky" <m...@rrr.se<mailto:m...@rrr.se>> wrote: Hi, Database views might be deleted and recreated if something has changed. So if you have granted special permissions or anything on the database level this might get lost. I use def-file for syncing, and I have created a set of tools to Export, Compare, Import and Delete differences between servers or backup copies of def files. https://rrr.se/cgi/tools/main?tool=rrrExportDef https://rrr.se/cgi/tools/main?tool=rrrDefDiff https://rrr.se/cgi/tools/main?tool=rrrImportDef https://rrr.se/cgi/tools/main?tool=rrrDeleteObject You could also use Migrator to do something similar. It does nt export/import objects, but rather creates/modifies them in a similar way as you would manually add/change objects in DevStudio. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Hi All, > > Has anyone here tried syncing Remedy codes from one server to another? I'm > only focused on syncing codes and not data/database/tables. > > I assume it's pretty much exporting/importing .def files but I'm concerned > about the database views if I'm about to import a different copy of > forms/workflows. Will this impact the database views at all? > > Thanks in advance. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org<http://www.arslist.org> > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"