AutoCAD Map 3D General

Reply
Valued Contributor
rick-chappell
Posts: 85
Registered: ‎01-20-2010
Message 1 of 3 (170 Views)

Export to DFO- SQL Server not consistent

170 Views, 2 Replies
12-05-2012 01:42 PM

I've been doing a lat of conversion lately, and I'm seeing pretty inconsistent results when exportinig AutoCAD geometry through FDO into SQL Server Spatial. I'm using Map 2012 with current sps on Win 7, and SQL Server 2008 R2 - using a local instance on the same machine as AutoDCAD.. I have a large drawing (200k objects), and I have several small OD tables attached to most objects. We are pushing those into SQL Server through FDO (Export to FDO connection) and I get pretty inconsistent results on the number of objects for example, out of 788 polygons, 436 will convert. I delete the objects from SS and try again, and it usually takes at least three times for the export to be complete. It seems to be inconsistent and of course, there's no error notes thrown out anywhere. I find I have to pull counts of all the objects before starting conversion on a drawing so I can keep tabs on it.

  Are there any known issues that might be the cause or contributing?

  Thanks,

  Rick

Valued Mentor
Posts: 269
Registered: ‎10-06-2008
Message 2 of 3 (164 Views)

Re: Export to DFO- SQL Server not consistent

12-05-2012 05:49 PM in reply to: rick-chappell

SQL Server (2008 at least) has this nasty problem of being completely **** retentive about the ring orientation of your polygons, which may explain why a fair chunk of your polygons are being rejected.

 

I don't know if FDO SQL Server export does any attempt at correcting ring orientation as part of exporting (it should, otherwise it'd be pretty flimsy). Someone else can chime in here.

 

- Jackie

Valued Contributor
rick-chappell
Posts: 85
Registered: ‎01-20-2010
Message 3 of 3 (160 Views)

Re: Export to DFO- SQL Server not consistent

12-05-2012 07:16 PM in reply to: jackie.ng

  I'll have to explore that issue, but there's more here as it happens to lines as well. It's not consistent on all drawings, but I do seem to get better luck starting with a blank drawing, attaching the file and querying in only the objects to push into SQL. We're just doing a lot of data and it's a bit frustrating at times. I'm starting to wonder if I ought to use SQLite as an imtermediary and pump the data into SQL from SQLite - but that ignores the problem.

  Thanks,

  Rick

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community