AutoCAD Plant 3D General DIscussion

AutoCAD Plant 3D General DIscussion

Reply
Contributor
TIMSHANAHAN9157
Posts: 12
Registered: ‎07-18-2011
Message 1 of 4 (424 Views)

SQL versus basic database

424 Views, 3 Replies
07-29-2011 10:09 PM

What are the pros and cons of converting to an SQL database versus the out of the box database system?

Employee
RSFAdsk
Posts: 172
Registered: ‎02-27-2009
Message 2 of 4 (404 Views)

Re: SQL versus basic database

08-01-2011 08:41 AM in reply to: TIMSHANAHAN9157

Hello,

First, if you are considering migrating a project to SQL Express, I highly recommend waiting just a bit longer for AutoCAD Plant 3D or AutoCAD P&ID 2012.

 

Pros for using SQL Server are primarily improved multi-user performance (and indeed avoiding a Multi-user limitation).

Con are increased admin requirements to deal with the SQL Server, such as backing up the database separately.  Using the default database, you can simply copy the project files.

 



Richard Frank
AEC Plant Solutions
Autodesk, Inc.
Valued Contributor
JRPalmer
Posts: 85
Registered: ‎03-10-2011
Message 3 of 4 (358 Views)

Re: SQL versus basic database

08-04-2011 02:23 PM in reply to: RSFAdsk

 How would you intergrate SQL with AutoCAD?

Employee
TomislavGolubovic
Posts: 540
Registered: ‎12-01-2010
Message 4 of 4 (340 Views)

Re: SQL versus basic database

08-07-2011 07:14 PM in reply to: JRPalmer

For Plant3D, it can run with a SQLite database, or SQL Server. There is a file in the Plant installation folder to convert the SQLite project to SQL if you want.



Tomislav Golubovic
Plant Solutions Engineer
Autodesk Australia / New Zealand
Autodesk, Inc.

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 to get help installing your software.

New AutoCAD Plant 3D Category!

The AutoCAD Plant 3D forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.