Using the Database Builder

Using the Database Builder

The DataBase Builder is a Scriptcase 'DBMS' (Database Manager System), this tool allows you to create tables, modify the structure of your tables, generate ER diagrams (Entity x Relationships), perform the export of the tables among other things.


Currently DataBase Builder connects only with databases: Oracle, SqlServer (Other than ODBC), Mysql, Postgres, SQLite


In this example, we will show you how to create and export a table using the Database Builder, follow the steps below:


1. To access this tool, we must first be inside a project with the connections previously created.

2. Next, we must access the Database menu> DataBase Builder







3. Next, we must select which connection we want to access, if there is more than one in our project.








4. Next, we will be redirected to the screen below:







In this image, we can see all the options available for data and table manipulation.


The DataBase Builder provides some similar functions to traditional 'DBMSs', allows us, among other things, to create triggers, change user permissions, export tables in different formats, modify table structures.


5. Next, we will create the new table, above the list of existing tables click on New table







 


6. At the side, the screen for creating the table will be displayed.






In this step, we must inform the name of the table, and the default type for the table.


 


After creating the table, we will now export it.


7. Above the option to create tables, click Export


 





 


8. In the export screen, it is possible to inform the type of output, the format of the generated file.






    After making the settings, click export.


    • Related Articles

    • Connection with MSSQL Database

      Scriptcase has 3types of connections that can be used to communicate with Database MSSQL Server. - MSSQL Server Native SRV PDO - MSSQL Server Native SRV - MSSQL Server ODBC 1. Connection ODBC (MSSQL Server ODBC)  This connection may be used on the ...
    • Using ajax: onChange events

      In this article we will see how the onChange event works, available in Scriptcase. It is triggered when the object, which makes use of it, has its value changed. Down below is an example of using this event. We will use an order items form, we will ...
    • Using the sc_confirm macro

      In this article, see a practical example of using the sc_confirm macro. This macro can only be used on PHP buttons created in the toolbar of form and control applications, with the aim of confirming the action's excursion. See how to create a PHP ...
    • How to create a simple LDAP Database on Linux

      Creating a simple LDAP Database on Linux. Installing and configuring slapd We are going to use OpenLDAP(slapd) to build a LDAP database accessible for the security module WITHOUT simulating an Active Directory. This tutorial will create an LDAP ...
    • How to create a LDAP Database on Windows Server

      Creating a LDAP Database on Windows Server. Server Manager Image 01: Server manager option on the startup menu. In Windows Server is natively possible to create a LDAP database to feed an Active Directory structure. We will need to access the Server ...
    • Popular Articles

    • Examples for diagrams

      This tutorial shows how you can import and use the new examples for diagrams released with Scriptpcase V9.2.16.  The applications were created using the components: Jsmind, JKanban e Orgchart.  - Sample 1: Mind Map diagram Click here to  execute the ...
    • Manual Update - Windows

      Before performing any procedure we recommend performing a backup of your projects. To back up Scriptcase: Go to Settings > Administration, in the side menu go to Services > Backup. A file (.ZIP) will be generated with all your projects, save this ...
    • PHP functions necessary for ScriptCase

      In PHP , there are some essential functions for the operation of Scriptcase .  On some servers , these functions are disabled , this makes the Scriptcase not work properly.  If you're using a shared hosting server, you'll need to contact the host ...
    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • Using friendly URL

      The friendly URL was included from Scriptcase 7, in order to make the URL, of the applications generated by Scriptcase, cleaner and easier to associate them with applications. For example, using friendly URLs the link to a Scriptcase application ...