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.
Retrieving data ...