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.
Hi,
have you tried bulk copy? Look >>>here<<< to get an overview of how to.
- alfred -
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
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 😉
- alfred -
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?
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. 😉
- alfred -
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
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
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 -