[fdo-users] Tool for editing f_ tables in SQL 2008?

[Kalman Albert]

good questions, 
the documentation is very poor, is need to digging in this tables
we start to make a procedure to create from sql to f_tables all tables and populate them but we thinking is not be useful and we give up ...
The most lack using FDO schema in Map, is not possible to manage views, and non spatial data (there is no options to add data) , modifying the data structure or adding/modifying views is difficult .
We choose to create datastore directly in sqlserver without any FDO schema, It's fast but has a problem for user because the feature type can be mixt (point, line, polygon) and not always want this, but with triggers can be easily controlled.
But the most unlike is that in map display style is show all tree type of feature class.


kalmy

  ----- Original Message ----- 
  From: Srecko Lipovsek 
  To: fdo-users at lists.osgeo.org 
  Sent: Tuesday, October 26, 2010 12:40 PM
  Subject: [fdo-users] Tool for editing f_ tables in SQL 2008?


  Hi 
  We store all spatial data in SQL 2008. All DB-s also includes f_ tables for describing Schemas and Clases. 

  We realize that f_ tables are now optional in SQL 2008, but they are great because they provide clean and organized data. 

  The only problem when using f_ tables is how to add new feature class from new table or some view. 

  When we import data to SQL with non FDO provider, only table is created and f_ tables are not populated. Also when some new view is created, we have manualy populate f_ tables if we want to view data. When one new column on existing class is created also something with f_ tables, ... there is many cases when manualy editing of f_ tables should be done to corectly view data ... 

  We know, that with some tricks (copy data from one to another DB with no f_ tables and back) should work, but I think that TOOL or PROCEDURE should be the best way for reading psyihical SQL objects maping and writing it to f_ tables (and also checker if something is deleted) ... 

  Editing f_ tables by hand is very tricky, so: 

  1.) I'am wondering if there is some TOOL or SQL PROCEDURE for editing (check, read, write) f_ tables in SQL 2008 (SQL objects phyisical mapping to f_ tables and vice versa)? 

  2.) Whether this can be done via the FDO API? 

  3.) Is there any DOCUMENTATION for f_ tables? 



------------------------------------------------------------------------------
  Srecko Lipovsek, BSc Civil Engineer 
  Kaliopa d.o.o., Ljubljana, Slovenija 
  WWW: www.Kaliopa.si | www.iObcina.si | gis.iObcina.si | www.iSlovenija.si | www.iKomunala.si


------------------------------------------------------------------------------
  View this message in context: Tool for editing f_ tables in SQL 2008?
  Sent from the FDO Users mailing list archive at Nabble.com.



------------------------------------------------------------------------------


  _______________________________________________
  fdo-users mailing list
  fdo-users at lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/fdo-users



  __________ Information from ESET Smart Security, version of virus signature database 5554 (20101022) __________

  The message was checked by ESET Smart Security.

  http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 5554 (20101022) __________

The message was checked by ESET Smart Security.

http://www.eset.com



__________ Information from ESET Smart Security, version of virus signature database 5554 (20101022) __________

The message was checked by ESET Smart Security.

http://www.eset.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20101026/840d9558/attachment.html