+ Post New Thread
Results 1 to 10 of 10
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 ...
  1. #1

    Join Date
    Jan 2009
    Location
    Liverpool
    Posts
    9
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    DBATTACH for FMS Why different? [Solved]

    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

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    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).

  3. Thanks to GREED from:

    mark-p (6th January 2011)

  4. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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.

  5. Thanks to vikpaw from:

    mark-p (6th January 2011)

  6. #4
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,206
    Thank Post
    450
    Thanked 173 Times in 170 Posts
    Blog Entries
    3
    Rep Power
    63
    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).

  7. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,382
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    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.

  8. #6

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78
    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.

  9. 3 Thanks to PhilNeal:

    GREED (5th January 2011), mark-p (6th January 2011), Rawns (6th January 2011)

  10. #7

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    Dependable as always Phil!

  11. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,382
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    @Phil looks like a "Simon says"

  12. #9

    Join Date
    Jan 2009
    Location
    Liverpool
    Posts
    9
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks everyone. Phil, that's a very comprehensive explanation and will help me not to grumble so much.
    Cheers
    Mark

  13. #10

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78
    I barely understand it though

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS - FMS] GDI32.DLL error [Solved]
    By jamesloker in forum MIS Systems
    Replies: 36
    Last Post: 14th July 2010, 11:04 PM
  2. Error using DBAttach
    By zag in forum MIS Systems
    Replies: 3
    Last Post: 10th December 2009, 03:45 PM
  3. DBAttach
    By TechMonkey in forum MIS Systems
    Replies: 2
    Last Post: 21st September 2009, 02:23 PM
  4. Replies: 2
    Last Post: 11th August 2009, 12:17 PM
  5. DBATTACH exit code
    By ajbritton in forum MIS Systems
    Replies: 0
    Last Post: 24th November 2006, 11:31 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •