Skip to Content (Press Enter)
2018-09-07 11-54-27
Eric Oud Ammerveld
4Views
6Comments
Database management by DBA & Outsystems script output
Question
Dear All,

Concerning the managing of both the Database content and the metadata (tablestructure) I have two questions.

Changing values in tables
In our current database environment we have database tools to change the database's content in AD-HOC situations.
Does Outsystems have a generic tool to manage the database content using the Entity names that are used in Outsystems?
e.g. execute a :
 UPDATE {client}
 SET [vat_tariff] = 19
 WHERE {client}.[vat_tariff] = 17.5

Deploying new versions of a script
Our current database deployment setup involves a DBA that will manually execute a database change.
This is something that is still preferred.
Is there a way to make Outsystems handle the creation of a "database create / change script" and output this script?

The alternative would be to use a tool like Powerdesigner.
0
0
10 May 2010
Copy Link
2011-08-23 22-04-05
Tiago Simões
Staff
Changing values in a table:
Advanced Query



Deploying new version of a script:


1. Upload the eSpace in Service Center


2. Select Publish step by step in debug mode


3 - Click the Download Database Upgrade Script
0
0
10 May 2010
Copy Link
2018-09-07 11-54-27
Eric Oud Ammerveld
Hi Tiago,

Thanks for you reply.
This is indeed the answer to the second question I had.

Anyone has an answer for the 1st?
0
0
10 May 2010
Copy Link
UserImage.jpg
Jeffrey Sullivan
Eric,

The Advanced Query action can update the values in a table.
0
0
10 May 2010
Copy Link
2018-09-07 11-54-27
Eric Oud Ammerveld
Hi Jeffrey,

Thanks for your reply, but I'm looking for a more 'user friendly' tool.
Think around the lines of tools like
  • Service Studio
  • Sequal Server Management Console
  • iSQL
  • SQL Uniform
  • PHPMyadmin
0
0
11 May 2010
Copy Link
UserImage.jpg
Jeffrey Sullivan
Ah. I haven't heard of one.  

You could always build your own in the platform using advanced query functionality and share it with the community...
0
0
11 May 2010
Copy Link
2011-08-23 22-04-05
Tiago Simões
Staff
Hi Eric,

Have you seen SQLMap?
Although it does not execute the script it will give you the T-SQL translation.

Cheers,
Tiago Simões

0
0
11 May 2010
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.