I have connected the Plant3D data to Mssql using PnPProjectMaintenance.exe.
Does Plant3D synchronize with MSSQL in real-time so that changes made to the data in MSSQL are applied to Plant3D? For example, if the length of a pipe is 1000, and I change the value in MSSQL to 100, will the length of the 3D pipe model in Plant3D change to 100?
Solved! Go to Solution.
Solved by h_eger. Go to Solution.
No, unfortunately this does not work.
We write all data to the DB regardless of MSSQL or SQLite.
Only graphical changes must be made in P3D and not in the DB.
Hartmut Eger
Senior Engineer
Anlagenplanung + Elektotechnik
XING | LinkedIn
Thank you for your reply.
Is there a way to create, modify, and delete 3D models without using Plant3D, by utilizing an SQL database? Developing algorithms in SQL and executing them through queries would be a typical example.
No, this is not planned in the development of P3D.
Please contact Autodesk at the Idea Station where you can ask such questions.
Hartmut Eger
Senior Engineer
Anlagenplanung + Elektotechnik
XING | LinkedIn
Thank you for your reply.
Why can't geometry data be modified in MS SQL, and why can it only be changed in P3D? Does MS SQL not have geometry data?
Additionally, if there is geometry data in a DWG file, can it not be included in MS SQL? Or is it not possible to access the DWG file to retrieve the geometry data?
Correct, the geometry data is NOT written to the database (SQLite, MS SQL etc).
Are you from E3D or why this question?
To my knowledge it was never the intention of Autodesk to have a database based 3D model.
The basis was Autodesk AutoCAD and therefore linked to the dwg format.
Hartmut Eger
Senior Engineer
Anlagenplanung + Elektotechnik
XING | LinkedIn
Can't find what you're looking for? Ask the community or share your knowledge.