Book a Demo

Author Topic: Full Database development in EA? Not just models but running SQL  (Read 4406 times)

Bill Egge

  • EA User
  • **
  • Posts: 93
  • Karma: +0/-0
    • View Profile
Full Database development in EA? Not just models but running SQL
« on: December 03, 2016, 07:52:55 am »
When develop stored procedures, views, functions in SQL Management studio I am able to execute and test and so on.  Is this possible in EA such that I do not have to touch SQL Management studio.  I like the idea of editing functions straight from the diagram because it helps me keep track of things and keep my eye on the high level.  I wish it were possible, maybe it is?


Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Full Database development in EA? Not just models but running SQL
« Reply #1 on: December 05, 2016, 05:17:25 pm »
Hi,

if I have correctly understood, you want a new language, SQL Sever, with the possibility to execute it.

As far as I know, that's not available from off the shelf.  There are too many languages and SQL dialects available to support them.

In principle, you can do it via an Add-In.

Kind regards,

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)