[sims] DBATTACH for FMS Why different? [Solved]

[mark-p]

Hi All

 

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?

 

Thanks

Mark

[GREED]

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).

[vikpaw]

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.

[Cache]

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).

[matt40k]

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.

[PhilNeal]

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)

 

For example

 

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.

[GREED]

Dependable as always Phil!

[matt40k]

@Phil looks like a "Simon says"

[mark-p]

Thanks everyone. Phil, that's a very comprehensive explanation and will help me not to grumble so much.

Cheers

Mark

[PhilNeal]

I barely understand it though