How to rename an entity's internal name

Pedro Barreto

Question

Hi,

I need to rename an entity's internal name, the one used to create the sql table, to have the same names on Service Studio and SQL Manager.

Is this possible?

Thanks,
Pedro

19 Aug 2008

Pedro Barreto

Solved it!

Here's how I did it:
1. Changed entity names on Service Studio and published the eSpace;
2. Duplicated the bd;
3. Edited by hand the physical_table_name on the sql table ossys_Entity;
4. Dropped the tables;
5. Re-published the eSpace
6. Created and run a script to migrate data from the backup db to the tables with new name.
Regards,
Pedro

19 Aug 2008

2 replies

Last reply 19 Aug 2008

Show thread

Hide thread

Paulo Ramos

Staff

Hi Pedro,

Although you may have solved your problem, you may also read this related topic:
https://www.outsystems.com/NetworkForums/viewtopic.aspx?TopicId=3444

Also, if your goal is simply having more ease executing queries or managing tables in SQL Management Studio, maybe this tool is enough for translating between logical and physical table names:
https://www.outsystems.com/NetworkForums/viewtopic.aspx?TopicId=2943

19 Aug 2008

Pedro Barreto

Thanks Paulo,

I had looked into those two posts.

My problem was a real name change in entities, e.g: from "issue" to "incident".

Thanks for the tip, I'll use the SQL Map eSpace for sure, it's a very handy tool!

Pedro

19 Aug 2008

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines