I mean how many children parent has on average? 10? 100? 1000?

what's the expected average/max cardinality on that relationship?

I once separated one Ensemble database (with code and data) into two databases (one db for code, one db for data) on a running system.

It was not difficult actually:

1. Exported code from one database
2. Created new database.
3. Imported code into new database.
4. In a namespace switched code database from old database to a newly created one.
5. Deleted classes from old database.

But in my situation the code itself didn't change.

You're calling an Operation, right?

Operations can be called in async mode.

Make the call async and add wait activity?

Another check. Properties can't be SQL reserved words. I often name properties "Date", etc. only to forget that they can't be used in SQL as is only quoted, so I need to go to Class view and rename them to something else.

The main check we need is parametrization. SQL should not be concattenated from user input, but user input should be passed as an argument.

Well, what do you want to do with that list? Depending on your use case, the solution may differ.

For example to get a list of dashboards execute this query:

SELECT *
FROM %DeepSee_Dashboard.Definition

And to get a list of Pivots execute this one:

SELECT *
FROM %DeepSee_Dashboard.Pivot

And in MDX2JSON project I need to get a list of dashboards visible to the current user.  I use custom result set for that (because user may have access to dashes but not to SQL).

And Tuesday, April 23rd at 11am EDT we would be running an English version of the webinar.

Register here.

Great!

Here's zip archive/unarchive support. Maybe you can unite these two projects?

If it's possible restart the DR Mirror. WIJ should be recreated on startup.

Or a Skype group.

Right after you get this error, what's in your ^||isc.debug global?

zw ^||isc.debug

Can you try restarting the instance?

CSP absolutely should work.

Also check this post about clearing cached elements from webserver.

I never use return unless I really do want to exit from the method while inside some inner loop. So mainly I use quit.

You can separate a file into structured data using Virtual Document API.

To import HL7 into Ensemble please refer to these guides.

Generally it could look like this: HL7 → Virtual Document → Persistent storage → SQL GateWay → MS SQL Server.