AutoCAD Plant 3D General DIscussion

AutoCAD Plant 3D General DIscussion

Reply
Contributor
12 Posts
0 Kudos
Registered: ‎07-18-2011
Post 1 of 4

SQL versus basic database

426 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
172 Posts
21 Kudos
Registered: ‎02-27-2009
Post 2 of 4

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
85 Posts
4 Kudos
Registered: ‎03-10-2011
Post 3 of 4

Re: SQL versus basic database

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

 How would you intergrate SQL with AutoCAD?

Employee
564 Posts
51 Kudos
Registered: ‎12-01-2010
Post 4 of 4

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.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
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.