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 ...
    • 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 ...
    • Correcting access error for the Scriptcase database

      Sometimes we encounter an error accessing the Scriptcase database itself, as shown in the image below:   This problem happens when we change the folder name of the scriptcase to another name, such as "sc". Then, the error happens because the complete ...
    • Necessary libraries to install the Scriptcase in Windows 7

      To install Windows 7 SP1, you need to verify that the system has the following items installed: * Visual C ++ Redistributable Packages for Visual Studio (2008) x86 and x64. * Visual C ++ Redistributable Packages for Visual Studio (2010) x86 and x64. ...
    • 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 ...