Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003

    Unhappy Unanswered: How to copy table from database A to database B

    Hello There,

    I'am new with sql2000

    Could some one help me.
    i want to copy a table from database A to database B with all soure and permissions.

    When i export the table in database B and i want the table with access
    i can not make change in the table.

    the soure (database A) can be changed.

    please help me.

    thanks in advance


  2. #2
    Join Date
    Sep 2003
    United States
    Provided Answers: 1

    Explore DTS

    I think DTS can help u, explore that DTS utility, hopefully that will solve ur problem else re-post ur question with more clarity.
    >> Learn PHP/MySQL for free
    >> Free Web Hosting with PHP, MySQL, Website Builder :

  3. #3
    Join Date
    Feb 2002
    Will you maintain this data - database A will be the source and database B will be updated periodically from database A (replication)? For the permissions, you can setup the logins to only have a db_datareader role for that database.

  4. #4
    Join Date
    Dec 2002

    Re: How to copy table from database A to database B

    I'm not positive that DTS can transfer permissions (it may, but I'm not sure). One thing that you can do is script off the table (using EM or Query Analyzer). Be sure to check off the option to script permissions. Also besure that any users/roles that are granted permissions on the source table exist on the target server.

    One you have scripted the table and built it on your target server, then you can easily use DTS to transfer the data in the table. You could also add the target server as a linked server and just use a T-SQL statement.



Posting Permissions

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