If you see nothing but the table (or database view) name you may have a local database view in your Remedy database of the remote linked server database. If that is so then all you need to do is update that local database view to point to the new remote database. ARS doesn't have to be changed at all.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Anderson, Doug Sent: Monday, January 23, 2012 8:42 AM To: [email protected] Subject: Re: Moving the database to which a view form links? ** Hi Fred, LJ, et al., Fred, we're on MS SQL. I see the table name in the View Info tab of the form properties but it gives no clue as to the database & server. LJ, you suggested the XML version of the table definition would show the old connection. I exported to xml and there is no evidence of the database name or the database server name in the resulting file. I exported workflow database calls to discover the old server name. However, knowing that doesn't help me change it in an ARS-friendly way. Thanks again for any suggestions on where/how to change the view form's target database. Doug -----Original Message----- Original message: Date: Fri, 20 Jan 2012 22:20:00 +0000 From: "Grooms, Frederick W" <[email protected]> Subject: Re: Moving the database to which a view form links? In the Admin tool the Form Properties -> View Information tab lists the source for the data (in the Table Name field). What database are you using? Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Anderson, Doug Sent: Friday, January 20, 2012 3:42 PM To: [email protected] Subject: Moving the database to which a view form links? ** Hi All, I've inherited a view form that points to a table in a non-ARS database. That database needs to move to a different server. I've never had to do this before. This is on ARS 7.1 patch 6. I've looked through the manuals & I see where the path is set when creating a view form. What I don't see is where & how to change that path for an existing view form. I've queried the schema_view table and don't see it there. I've exported a def file and don't see it there. How does one do this? Must I re-create the view form (and everything that references it)? Thanks for any clues, Doug Anderson _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
