Results 1 to 2 of 2

Thread: Databases linked to Master Database
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular schielrn's Avatar
    Join Date
    Apr 2007
    Location
    Cincinnati, Ohio
    Posts
    6,933
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Databases linked to Master Database

    We have a master database that holds a lot of data. We want to migrate this to SQL. The issue becomes we do not know who all accesses this database and what other databases/processes have links to this database.

    What are your best way to determine what all connects to a master database? I can determine what this database is connected to, but have no idea what is connecting to this database if that makes sense.

    We could rename the master table, but with the large volumes of data people may not even realize this table is not being updated. I could put in VBA to capture who opens the database, but I still don't think that would let me know who already has connections to this database.

    Has anyone gone through this to try to determine what all links to a specific database?
    Always make a back up copy before trying new code, you never know what you might lose!


    - Posting guidelines, forum rules and terms of use

    -Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    "The world suffers a lot. Not because of the violence of bad people, but because of the silence of good people!"

  2. #2
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,338
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Databases linked to Master Database

    If you remove the database you will find out who uses it (or they will accept their fate and quietly go about things differently). That's the only good way I know.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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