AutoCAD P&ID General Discussion

AutoCAD P&ID General Discussion

Reply
Active Contributor
dogyeom
Posts: 35
Registered: ‎03-22-2012
Message 1 of 2 (443 Views)

[Urgency]SQL & P&ID Question

443 Views, 1 Replies
09-25-2012 10:46 PM

P & ID SQL Part

1. Change the information I am using SQLite. However, the property did not change.

    It is possible to know the "PnPlocalCachePurer.exe". But in order to use this method,

    AutoCAD P & ID should be shut down. This method is a very cumbersome task.

 

   Do you have any other suggestions?

 

2. When you use SQL Server, SQL account, it is possible to login.

    However, the domain user's login is not possible.

 

    I wonder if the reason and how to resolve.

 

3. SQL Server from Local database to move (Local Database -> SQL Server).
    But the opposite case is impossible.

 

    Possible way?

 

4. Local Database backup is easy. but SQL Server backup is difficult.

 

    Easy backup methods?

 

5. In SQL, Create column, and tried to change the position. But that was impossible.

 

    Is there a way to sort?

 

P & ID Drawing Part

1. In create project, to set up the PIP, JIS, standard setting page.

    But in addition to them, I want to create a user-defined specifications.

    and the item I want to add it. In the specifications set page.

 

    Wondering how

*Expert Elite*
dave.wolfe
Posts: 731
Registered: ‎12-04-2009
Message 2 of 2 (432 Views)

Re: [Urgency]SQL & P&ID Question

09-26-2012 04:19 AM in reply to: dogyeom

1. Can you clarify what information you are changing?

2. The computer you run SQL Server has to be part of your domain (and not the domain controller). In SQL Server, you have to allow SQL Server authentication and Windows Authentication.

3. Create a new project using the wizard, and specify the existing SQL Server project as the project template, and using the SQLite database.  Then you can copy the drawings from the SQL Server project to the new SQLite project.  Because the data is stored in the DWG, the information will be carried to the new project.

4. We have a series of posts on SQL Server with Plant 3d.  One of the is backing up the server: http://www.pdoteam.com/2012/02/creating-backups-for-sql-express/

5. Can you explain more?

6. I don't know of a way to do this.  What would the advantage be?  All of the items should be available in the project, so what would having a standard get you?

Dave Wolfe
Isaiah 57:15

ECAD, Inc.
Tips and Tricks on our blog: Process Design, from the Outside

A P3D Authorized Reseller
Plant 3d Wish list: https://plant3d.uservoice.com/
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 P&ID Category!

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

Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.