MIS Systems Thread, DBATTACH for FMS Why different? [Solved] in Technical; Hi All
This question has gnawed away at me for ages. I'd be grateful of an answer and maybe then ...
4th January 2011, 03:09 PM #1
- Rep Power
DBATTACH for FMS Why different? [Solved]
This question has gnawed away at me for ages. I'd be grateful of an answer and maybe then I won't grumble so much.
The sims.net database and the FMS database both sit on the same SQL server. Why do they use different versions of DBattach?
IDG Tech News
4th January 2011, 03:13 PM #2
I would put good money on it being becuase they still have legacy bits of code that work differently. Remember the tool does other things not just attach/detach (if it did then big woop, SQL does that just as well, if not quicker, direct from SSMS).
Thanks to GREED from:
mark-p (6th January 2011)
4th January 2011, 05:51 PM #3
well for sims, it takes the logins and puts them in a table in the database so you can move the file elsewhere easily, then on reattach sorts it all out for you. i guess if this is non-standard and hard coded, the location for fms is different, and so needs it's own version of dbattach.
Thanks to vikpaw from:
mark-p (6th January 2011)
4th January 2011, 08:24 PM #4
When I asked it was mentioned as GREED suggested.
Apparently at one time they did use the same version then split 2/3 years ago I believe (but could be wrong, it's from memory).
4th January 2011, 08:27 PM #5
They are both the same program, it's just a safely thing if they ever need to change some to just one, at the moment however, exact, copy and paste same thing. Shame really because it'll be since if dbupgrade (fms) added the fms prefix to the end of the setups directory.
5th January 2011, 02:16 PM #6
For those that are interested!
Part of the functionality in DBAttach is the ability to backup the Document Management Server - to do this it uses dll's compiled as part of the main SIMS .net 'solution' - this means that for SIMS, every time we rebuild Pulsar.exe (SIMS .net) we also have to rebuild the DBAttach.exe to maintain version compatibility and strong naming conventions.
In a typical release FMS by its nature requires far fewer physical compilations of the source code before its ready to go (as its just one project rather than several or tens delivering)
Builds SIMS FMS DBAttach in SIMS installer DBAttach in FMS installer
1 7.136.001 6.136.001 7.136.001 7.136.001
2 7.136.002 7.136.002
3 7.136.003 6.136.003 7.136.003 7.136.003
4 7.136.004 7.136.004
5 7.136.005 7.136.005
So if after 5 builds we shipped both SIMS and FMS (last built at build #3) then the version of DBAttach.exe shipped with FMS is going to be physically different version - but because its delivered to a different location it doesn't matter (so they won't overwrite each other) and the strong naming of the exe and dll remain consistent.
In this situation they will be identical versions of the source, just different builds.
3 Thanks to PhilNeal:
GREED (5th January 2011), mark-p (6th January 2011), Rawns (6th January 2011)
5th January 2011, 03:17 PM #7
Dependable as always Phil!
6th January 2011, 10:43 AM #8
@Phil looks like a "Simon says"
6th January 2011, 01:42 PM #9
- Rep Power
Thanks everyone. Phil, that's a very comprehensive explanation and will help me not to grumble so much.
6th January 2011, 08:05 PM #10
I barely understand it though
By jamesloker in forum MIS Systems
Last Post: 15th July 2010, 12:04 AM
By zag in forum MIS Systems
Last Post: 10th December 2009, 04:45 PM
By TechMonkey in forum MIS Systems
Last Post: 21st September 2009, 03:23 PM
By nry in forum MIS Systems
Last Post: 11th August 2009, 01:17 PM
By ajbritton in forum MIS Systems
Last Post: 24th November 2006, 12:31 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)