SQL server peeps.

Nov 10, 2020, 7:59 PM

I have a littel Synology NAS (I think... I know its Synology) server that I use for work. We have a shared folder on there that is linked to everyones computer so everyone can have access to files no matter who received them. Basically all our project files are on this server and the server pushes it out to all of our computers. Those files are actually saved on to our individual hard drives as well by the server.

I use AutoCAD Plant to do piping models and drawings. We saved it on the server, but just realized when we creat the project, you have to decide if it is to be saved as a local project or on an SQL server. We have always used local because typically the projects are small enough that one person can pretty much handle the whole piping design by themselves. Plus, we thought that since it was saved to the Synology server, and that pushes out to everyone, that everyone would get the latest.

But apparently not. Apparently Plant overrides the push. The guy that has been doing everything so far has his latest file date as 11/06/2020. Mine shows 07/09/2020. The actual server, which is supposed to be the latest up-to-date file shows 06/10/2020 because that is when it was created. So clearly it is not taking the latest (11/06/2020) and replacing the existing with the latest like it does every other file. Again, I am assuming this because we set it up to be local so the local file is the one that is ever accessed.

Now onto the question. I have no idea what an SQL server actually means or does. IT gurus, do you think that we could use the Synology server (which is basically just a huge hardrive that pushes out to everyone what anyone else saves) as the SQL Server or is there something else that I need to get or setup?

Again, sorry if something isnt explained well... I am not overly familiar with this.

flag link

military_tech

thumb_down

thumb_up

We all have the "Active" folder on our computers. It is mapped to the "Active" folder on the server. If I save a file in the Active folder and I am connected to the internet, my computer is synced with the server and my computer saves the file to the server. Then if Steve (thats what we will call one of the other employee... because thats his name) is connected to the internet, the server saves the file to his computer as well. Now we both have the file.

If Andy (another employee) is at the plant and doesnt have internet access, then he does not receive that file yet. However, he has everything that the server had when he was last connected to the internet. Then say he save a file to the Active folder. Then he goes home and connects to the internet. Now his file is saved to the server and the server saves his file to everyone else's computer and the server saves the file I saved to his computer as well. Now everyone has the exact same thing again.

My plant project.xml file is definitely different than Steve's. His is the later date one and his has everything in it... mine has very little even though the server says everyone is up-to-date. His file is clearly not replacing the one on the server (file date is July) and the server is clearly not pushing it out to everyone. I do not know why. The interesting thing is, it is only that .xml file that is not being pushed. There are drawings that the date is the latest one my computer, but the have to be opened through the project.xml file when you open plant. With that file being from August or something, it is bringing in August stuff... not the latest.

SQL server peeps.

Re: SQL server peeps.

The folder is shared.

Re: The folder is shared.

I am not sure. How it typically works is like this.

Re: I am not sure. How it typically works is like this.

Re: I am not sure. How it typically works is like this.

TigerBoard POTD