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