Post reply

best way to distribute/ synchronise datafiles

  • November 22, 2004 at 4:47 am

    #87063

    Hiya,

     

    I am at the start of the dev process for a project.

    I have the development datafiles on my local PC.

    I want to be able to allow other users on the LAN to be able to directly enter sample data to a specific subset of my tables, via enterprise manager.These users all have EM installed locally on their boxes.

     

    At the moment, I am simply putting a copy of my MDF files onto their local hard drives (as I can’t seem to get EM to be able to attach to datafiles that arent’t local)

    Pretty messy, I then need to copy them back to my local PC then re-attach

     

    Obviously, I’d like to be able to:

    1)     centralise these tables into a single datafile, that all the users can get acess to.

    2)     Restrict what these user can get access to (they really don’t need to see sprocs and udf’s etc)

     

    I’d say this is an admin issue.Can anyone suggest how I can make the process a bit less messy?

     

    Many thanks,

    yogi

     

  • November 22, 2004 at 6:00 am

    #531011

    EM can access database remotely. then use right to limit what can be seen for each user.

  • November 22, 2004 at 9:10 am

    #531075

    My buddy Andy would say use Access and link it to your tables. Setup only links to those tables the users need.

  • November 23, 2004 at 2:38 am

    #531180

    Thanks all.

    I went for the access option at the minute, simply because I'm not yet confident enough that I can adequately control the permissions to my sprocs and tables.

    cheers,

  • November 23, 2004 at 3:48 am

    #531193

    Hi,

      clients can access the database residing in a remote machine. This is possible by registering a new server in EM (client machine) based on machine name or ipaddress of ur machine. 

     If u want to restrict their functionality on Database u can create the user(s) with specific server/db roles to them.  

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply