Some suggestions

Topics: Developer Forum
Sep 26, 2006 at 6:09 AM
Hi Ricardo

At first my congrats to the new version it works smoothly.
But I've some issues.

  • a "DROP TABLE" doesn't delete all references in TableValuedFunctions,
perhaps you could solve this with a DDL trigger

  • due to my limited knowledge of CLR in SQL Server, I didn't managed it,
to upgrade the database without deleting my tables. Could you please provide
an update guide for me and other users

  • Doesn't it make sense to move you un/deploying, shapefile loading, ...
functionallity into the library, so you can use the same code for web-based
deploying in a hosted environment

BR
/Christian
Coordinator
Sep 26, 2006 at 7:06 AM
> a "DROP TABLE" doesn't delete all references in
> TableValuedFunctions, perhaps you could solve this
> with a DDL trigger

Try with the DropGeometryColumn stored procedure (suggested by OGC specs) or with DropGeometryTable. A DDL trigger is a good idea I will explore.

> due to my limited knowledge of CLR in SQL Server,
> I didn't managed it, to upgrade the database without
> deleting my tables. Could you please provide
> an update guide for me and other users

This task should be automated by a command like "msscmd.exe -update" to be implemented in a next release. Indeed this should be a high priority feature. Thanks for pointing it out.

> Doesn't it make sense to move you un/deploying,
> shapefile loading, ... functionallity into the library,
> so you can use the same code for web-based deploying
> in a hosted environment

Great idea. Anyway, it couldn't be the same library used for deployment in SQLCLR because of some restrictions such as external dependencies (ie. Npgsql.dll). Tell me how urgent for you this feature is, because there's a fast (and dirty ;-) way to get it making public the Main method of msscmd.exe which, as any assembly, could then be referenced by your code. If not so urgent, I will move the needed code to another library one of these days...

Thank you for this great feedback. I will add all your suggestions to the issue tracker. BTW, next time feel free to add there your requests for features and enhacements.

Best regards,
Ricardo Stuven.
Coordinator
Sep 27, 2006 at 7:18 PM
Please, download and try 0.1 RC2

Now the -deploy option makes automatic version upgrades, taking care of removing and recreating all dependencies and without losing your data.

This feature also allows you to deploy with SAFE permission and redeploy with EXTERNAL_ACCESS only when needed.
Sep 27, 2006 at 10:38 PM
Hi Ricardo,

Your automatic upgrade works like a charm and without any exception.

Were you able to use only NTS coordinate system without converting
to #Map and back?
I didn't experienced any performance gain.

Great work!

BR
/Christian
Coordinator
Sep 28, 2006 at 4:43 AM
> Were you able to use only NTS coordinate system
> without converting to #Map and back?
> I didn't experienced any performance gain.

Yep, it's implemented. Maybe you are not transforming enough geometries to get a noticeable performance gain.