Is the database included with SW EPDM?
What is the level database support provided if yes?
Are there riplication tools for the Database. I see much reference replicating the vaults, but not the database?
SQL Server 2008 is included with EPDM.
I'm not sure what you mean by what level of support you will be provided. Your VAR could answer that.
The database is not replicated in the traditional sense, as far as SQL server replication goes. The archive/vault is replicated, and remote locations point to the main database.
Lee Young wrote: SQL Server 2008 is included with EPDM. I'm not sure what you mean by what level of support you will be provided. Your VAR could answer that. The database is not replicated in the traditional sense, as far as SQL server replication goes. The archive/vault is replicated, and remote locations point to the main database.
Lee Young wrote:
Level of support - What is the typical level of support provided for SQL Server, considering considering SQL Server was not purchased directly form Microsoft? I'm asking because of previous experience with another PDM, and I want end user experience, not the VAR's.
If you have database issues, how much support can you expect if the issue is not covered by a canned knowledge base answer? Should we consider purchasing SQL Server in order to have a higher level of support?
If the database is not replicated, how is the performance on global multi-site connections?
Level of support - I can't personally answer that as I haven't needed much support in that area. I would hope most VARs would be able to support you, but if not, SolidWorks should be able to step in. Microsoft should be your last call.
The database of EPDM isn't complex. It's not hard to understand. It doesn't use a lot of obscure features of SQL server. It's simple, clean, and well organised. You really shouldn't have any issues.
Your performance is limited to your connection to your offsite offices, as well as when and how you do your replication. (Replication on demand vs scheduled.)
I implemented EPDM in June of 2007 and am the EPDM administrator; all help desk calls for SolidWorks, EPDM, AutoCAD , etc go through me. We do have an in house DBA but most all SQL issues for EPDM are handled through me and our VAR. If the VAR can not handle a situation SolidWorks does get involved and they are very competent. I have not had to get Microsoft involved at all. It is actually very rare that we have to get into the SQL tables but it does happen from time to time depending on the situation.
As far as replication goes, we have five replicated servers set up across the country and do not have an issue with letency between the replicated and database server. The latency experienced is with getting the archive data to and from the master archive server here on site. However, if you set up scheduled replication, the archive data can be replicated off hours; on the weekends, afternoons, etc. Once the archive data is on the replicated server, users have not experienced delays (so far).
Hope that helps!
So do you do things like rebuild indexes or poulate new fields or other mass changes directly in Sql Server? Do you know of anyone running replication database and vaults overseas (India or China)?
How does Sql Server multi-site compare to Oracle multi-site?
We do rebuild indexes as part of the maintenance schedule but we do not ever manipulate the data via the tables. Manipulation of the tables without SolidWorks consent voids all support. Unfortunately I do not know of anyone going overseas. I have not gotten into SQL Server multi-site because like I mentioned the latency is not bad on the SQL side of things. I do know of one company that is doing multi site SQL and they are having issues with it; not sure the specifics.
The database is not replicated, just the files. Thus SQL server multisite is not used.
Although we are not utilizing this functionality in SQL server, I do know of a company who is utilizing SQL server multisite with their EPDM replication. So, apparently it is possible if you experience unexceptable letency between sites (overseas for example) for database functionality; searching for example.
That is pretty cool! ...I've always thought it would work in theory, but have never heard of anyone replicating the database in production. If you learn anymore let us know!
Supported with SQL Server at multisite is possible to use data exchanging throught internet.
Unfortuately, I just learn of some information but never apply it.
Lucus - Can you forward me the contact information for the company that is replicating the SQL DB server. We are having severe user issues when the fetch informaion from the master SQL DB server.
Please shoot me an email at email@example.com and I will reply with the information.
Retrieving data ...