Is it possible to Create Tables using one Sql script?

Is it possible to Create Tables using one Sql script?

  

Hi,

Me and my team, we are currently facing a problem regarding the migration of one application to Outsystems.

Long story short, we have one Sql server database and we want to migrate it to OutSystems, but we have too many tables and we were thinking if it is possible to run our create table script.

By the way, we already tested to run the script as an sql statement in one server action but we got one permission error.

Is there any other way to overcome this problem? 

Kind regards,

Armindo 

Solution

Hi,

Why not keep the sqlserver as an external database?

Don't see the immediate advantage to migrate the database into outsystems...


In any case, imho the easiest way is as follows:

- import all entities via the import wizard  in integration studio.

- publish the xif

- reference all entities in your new core-module.

- copy paste the entities

- remove the xif

fix small things probably, setting the right delete rules etc..


Solution

J. wrote:


Hi J, is this method every-times I use the data it will link to the originally database, or it is the way import the data to the outsystems? 

Thank you.


Hi,

Why not keep the sqlserver as an external database?

Don't see the immediate advantage to migrate the database into outsystems...


In any case, imho the easiest way is as follows:

- import all entities via the import wizard  in integration studio.

- publish the xif

- reference all entities in your new core-module.

- copy paste the entities

- remove the xif

fix small things probably, setting the right delete rules etc..




Hi Eva,

The five steps J. describes are used to copy the data model of your external database only...

- import all entities via the import wizard  in integration studio.

- publish the xif

- reference all entities in your new core-module.

These three steps make your external database tables accessible from OutSystems applications (data is still stored and managed on the external database only).

If you want to also import data then you will have to implement the import logic to read from the external database entities and write on OutSystems database entities.


Thanks Jorge!!

May I ask you one more question.

How about I use this, is this allow us to connect the the external database to edit and view data from it? 

https://success.outsystems.com/Documentation/10/Extensibility_and_Integration/Integrate_with_an_External_Database


The only way I want to import data from SQL SERVER MANAGEMENT STUDIO is using outsystems development? 

Thank YOU.




Hi Eva,

The five steps J. describes are used to copy the data model of your external database only...

- import all entities via the import wizard  in integration studio.

- publish the xif

- reference all entities in your new core-module.

These three steps make your external database tables accessible from OutSystems applications (data is still stored and managed on the external database only).

If you want to also import data then you will have to implement the import logic to read from the external database entities and write on OutSystems database entities.