AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Active Member
darrenk
Posts: 8
Registered: ‎11-03-2000
Message 1 of 9 (263 Views)

Convert dwg with database links

263 Views, 8 Replies
06-08-2012 06:53 AM

Hello all.

I am trying to convert several drawings that are linked to an SQL database to SQL spatial. The drawings are from a Autodesk map 2004 system. I have Map D 2013 64Bit installed on a laptop along with SQL server 2012 RC0 (Microsoft SQL Server Management Studio      11.0.1750.32 Microsoft Data Access Components (MDAC)      6.1.7601.17514 Microsoft MSXML      3.0 4.0 5.0 6.0 Microsoft Internet Explorer      9.0.8112.16421 Microsoft .NET Framework      4.0.30319.269 Operating System      6.1.7601). To keep my rouge laptop off the company network I exported our existing SQL data to a access database that I placed on the laptop and converted back to SQL and linked it to the 2004 drawings. That part worked fine. I would like to convert all of them to SQL spatial. I have converted a small drawing but it took a couple of hours. I am in the process of a larger drawing that has 60,000 entities and it has been working for 8 hours and only has 4550 of them completed. I am using the output to fdo connection. Should it be this slow? Thanks.

The specs are attached.

   

*Expert Elite*
Alfred.NESWADBA
Posts: 9,071
Registered: ‎06-29-2007
Message 2 of 9 (261 Views)

Re: Convert dwg with database links

06-08-2012 07:31 AM in reply to: darrenk

Hi,

 

have you tried bulk copy? Look >>>here<<< to get an overview of how to.

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Active Member
darrenk
Posts: 8
Registered: ‎11-03-2000
Message 3 of 9 (257 Views)

Re: Convert dwg with database links

06-08-2012 07:47 AM in reply to: Alfred.NESWADBA

I was under the impression that bulk copy was from one fdo source to another. How can I select my dwg in the bulk copy window? Thanks

*Expert Elite*
Alfred.NESWADBA
Posts: 9,071
Registered: ‎06-29-2007
Message 4 of 9 (254 Views)

Re: Convert dwg with database links

06-08-2012 07:59 AM in reply to: darrenk

Hi,

 

>> How can I select my dwg in the bulk copy window?

Export your drawing to an SDF (using command _MAPEXPORT), don't forget to include your object-data into it. Then you are on the way for a direct bulk copy :smileywink:

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Active Member
darrenk
Posts: 8
Registered: ‎11-03-2000
Message 5 of 9 (250 Views)

Re: Convert dwg with database links

06-08-2012 09:53 AM in reply to: Alfred.NESWADBA

Thanks for the reply. It has been working for about 1:30 hours and has completd 350 of 60,000. Should it be this slow?

*Expert Elite*
Alfred.NESWADBA
Posts: 9,071
Registered: ‎06-29-2007
Message 6 of 9 (247 Views)

Re: Convert dwg with database links

06-08-2012 10:00 AM in reply to: darrenk

Hi,

 

>> It has been working for about 1:30 hours and has completd 350 of 60,000. Should it be this slow?

What process? The MAPEXPORT or the BULKCOPY?

Anyway ... none of these should be as slow.

 

I would try to remove most of the geometry so you have just a few (10 or so) geometry-objects.

And now run the process again. Then verify if there is all correct with the result.

That would prevent you from waiting additional 100 days and then receiving an error message. :smileywink:

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Active Member
darrenk
Posts: 8
Registered: ‎11-03-2000
Message 7 of 9 (241 Views)

Re: Convert dwg with database links

06-08-2012 01:48 PM in reply to: Alfred.NESWADBA

I have tried to both methods and it seems that coping the SQL data is the slow part. The drawing is linked to the same SQL database that is installed on this computer. I configured the data source for the old drawing with a udl pointed to the SQL database. It is fast when I don't select the database links. I think I will look at this again Monday. Thanks

Active Member
darrenk
Posts: 8
Registered: ‎11-03-2000
Message 8 of 9 (222 Views)

Re: Convert dwg with database links

06-11-2012 06:04 AM in reply to: Alfred.NESWADBA

I selected 86 features in the drawing and selected their database link. It took 3 minutes. I have 60000 of them. Is this normal? I figured that it would take about 35 hours to do this drawing. We have 59 drawings that range from just a few kb to 44mb. The one I have been working on is 7.5mb. Any ideas? Thanks

*Expert Elite*
Alfred.NESWADBA
Posts: 9,071
Registered: ‎06-29-2007
Message 9 of 9 (200 Views)

Re: Convert dwg with database links

06-12-2012 12:05 AM in reply to: darrenk

Hi,

 

Sorry, I though I would have time to do a small setup simulating that SQL-Server environment, but my time is run out and I have no chance for the next days to do that.

Globally: I don't think that writing 80 records can use 3minutes under normal circumstances. Either there are some conflicts with access to SQL-Server (check servicepacks, check to run with admin-rights for the test, maybe check another SQL-Server-version) or it has to do with some data-settings in the drawing (like e.g. object-data you transfer, coord-system, ...).

For testing different data I would start with simple polygons without additional data, then adding field by field (one string, one integer, ...) and verify when the performance goes down.

 

Again sorry, - alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.