slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: Renaming a DB field?

Mike Haney
Posts: 20

Renaming a DB field? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Sep 07 10:32 AM

I've added some custom fields to several main tables and noted an inconsistency with the naming of one particular field, and I'd like to change it so that it reflects the same name as used in SLX. From the Administrator DB Management area I cannot rename a field, but can do it directly through SQL Manager...

I've tried renaming it through the SQL Manager on my development machine and it seems to have worked fine, but I have a few questions before I'll consider doing this in production:

1) Will this have any ill effects with remote sync? I'm assuming they won't see the change properly and I should final sync the remotes, make the change then re-cut the remote DB's...
2) Is there anything else I need to do to rename the field, asides from changing it in SQL Manager and reloading my admin/client apps?

Thanks!

[Reply][Quote]

Jason Buss
Posts: 382

Re: Renaming a DB field? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Sep 07 11:02 AM

There is a SECTABLEDEFS table which contains a row for each field in the database. I believe that fields not matching a row in that table would not be able to syncronize. Maybe someone could verify this? (I'm by no means a sync expert!)

Changing field names in SQL Manager seems a little dangerous to me. The safest thing to do (which I admid would require more work on your part), would be to delete the fields in DB Manager, and re-add them with the correct name.

[Reply][Quote]

Mike Haney
Posts: 20

Re: Renaming a DB field? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Sep 07 1:50 PM

OK that gives me enough to worry about other problems this may raise. I'll create the new field, copy data over, and then delete the old field via the SLX DB Admin.

Thanks for the heads-up Jason!

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 4:56:13 PM