Just wondering if anyone is running PDM Pro with SQL Express?
why would anyone want to do this where SQL express has limits comparing to SQL standard
Only for testing. Never in production.
Why not in production? Do you need replication or have a huge number of users or did you see a performance difference in your testing?
Never tried but the number here can tell you what the performance diff.
Depending on environment that should have no effect. Thus my question.
How big is your vault? and the number of the users
PDM pro. might be overkill for you?
The 10gig is for the database, not the file store. You'd have to have an enormous vault to reach that limit. We need PDM Pro for the BOM functionality.
I'm talking about the speed, not database
That's why I'm asking.
Speed would be big diff. such as searching files between the standard and pro - however, you don't see much diff. with small Vault database
SQL Server came with PDM when we purchased. Provides additional functionality beyond what Express does that our IT database team utilizes (scheduled backups, indexing, etc.).
We do replicate files not databases. In fact the database replication introduced in PDM Professional 2017 requires SQL Server Enterprise edition.
Thank you Michael
My thinking is this: Most of the additional functionality of PDM Pro is software driven (except scalability) and has nothing to do with the database. I could be wrong because I haven't looked at the databases but I believe they are the same for both Pro and Standard. PDM Standard runs on SQL Express and DDM recommends SQL Express up to 50 users (unless replication or other enterprise level functionality is required). I wouldn't use SQL Express with that many users but I don't believe a 10 user shop would see any difference unless something in the product required full SQL. Backups should be accomplished via the Product and not thru SQL (at least that's how it worked with Autodesk).
Do you (or anyone) have any facts that would disagree? I'm still doing my homework here
The databases are identical between PDM Standard and Professional. I'd say if you want to try running on SQL Express go ahead but have a plan to upgrade to SQL Server standard in case you see performance issues. What does your VAR say? Will they support you if you are running on SQL Express?
That's kind of my thinking - have a plan to go to full SQL but try Express. I don't know if our VAR would support that or not, they seem more interested in making sales and ongoing consulting fees than what is in our best interest. They sold us on CAMWorks (before I got here) even though it doesn't support woodworking routers. That was about 13k down the drain. Now they want us to use one of their pre-configured ASME solutions with a 7k setup fee. We are a custom cabinet shop and have no need for what they are proposing.
Only testing would tell you if you have performance issues. What hasn't been mentioned is that SQL Express is limited to one core and 1GB of RAM. If your users are searching a lot or checking in/out large assemblies, my thought is that you may experience some performance issues. (Compared to Pro.)
SQL Express supports only 1 processor but 4 cores. I'm just having a hard time understanding how the demand on the database would be any different than with if we went with PDM Standard.
Ever find your answer? I'm in the same situation. I've got a 5-man operation but need PDM Pro for BOM functionality, etc. Our assemblies are relatively large, but we'd have nowhere near 10gb of SQL data...
Also wondering what the transition process would look like if we decided to go to full SQL in the future.
The answer I found was we really didn't need PDM Pro for BOM functionality as I was lead to believe. I was able to set PDM Standard up on a test computer (my home computer despite them telling me that couldn't be done) and run it through its paces. PDM Standard is amazingly capable and is only missing some of the automation functionality and you can't get too exotic with workflows.
Give it a try yourself on a spare computer if you have one. They told me it had to be installed on the license server which is not the case - you only need access to the license server. You could install it on one of your production stations but it could get confusing switching back and forth with Workgroup PDM and PDM Standard add-ins.
Unfortunately I left the company before Implementing PDM Standard.
Thanks for the quick response, Dave! Sounds like you're pretty resourceful. Not a bad idea to test it out on a spare computer...
I haven't made my decision yet (those automation functions seem pretty sweet), but I appreciate your insight. Enjoy the day!
Hi Dave -
Glad you got it setup and tested. I'm not sure why they told you it needed to be installed on the license server? Probably just an error in semantics. A true server level machine is always best when running client/server software.
In General, SQL Server and the PDM Database Server are installed on the same server machine (memory and CPU being the keys). The Archive Server is typically installed on a machine with adequate storage and fast IO.
SQL Express is pretty capable for small workgroups.
However, make sure that whatever machine you use that it is dedicated to just PDM. (ie: don't use your print server or email server machine) :-)
In defense of resellers, you can cut down your learning curve by having a 'skilled' reseller assist you with implementation.
The more you can define your needs, the smoother and faster the process.
Things to know:
For those new to PDM Standard, the documentation is very good (if you have some basic knowledge).
There are a ton of videos available online to learn more about the product and how it differs from PDM Professional.
solidworks pdm standard - Bing video
Lastly, as you already know, the online community is rich with skilled users who share their expertise, tips and knowledge.
Good luck, and if you are coming to 3DEXPERIENCE World, look me up and we can talk PDM :-)
I implement both PDM Pro and PDM Standard for companies all the time. Both versions work very well but the need of one over the other is usually dictated by a few key pieces of information as Joy indicated, except maybe adding in a few questions like: do you need multi-site replication? And do you need to automate any functions?. Basically, PDM Standard is a “limited” version of PDM Pro, the notable differences are:
And anyone that knows Joy, knows she's serious, if you look her up at 3DEXPERIENCE World she's loves to talk about PDM. I think we have a few discussions about PDM every year!
Retrieving data ...