none
How to export and import a database with all users from one server to another RRS feed

  • Question

  • We have a production server and need to export and import the database in development. What would be steps that I need to follow to create a copy of the database with users.
    Thursday, January 23, 2020 10:43 PM

Answers

  • Other option: Copy Databases with Backup and Restore

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, January 24, 2020 7:44 AM
    Moderator
  • We can achieve it using below options.

    >> Using the Copy Database Wizard.

    >> Restoring a database backup.

    >> Using the Generate Scripts Wizard to publish databases

    For more details please go through below Article it may helps you.

    https://docs.microsoft.com/en-us/sql/relational-databases/databases/copy-databases-to-other-servers?view=sql-server-ver15


    Please click "Mark as Answer" if it solved your issue and/or "Vote as helpful" if it helped. This can be beneficial to other community members reading this thread.

    Friday, January 24, 2020 9:17 AM
  • Thanks for the response. What would be the best process to clean up the database from the server?
    Hi Avyayah,

    >> Thanks for the response. What would be the best process to clean up the database from the server?

    Did you mean that you want to delete the database that have been copied? If that, you can use the Copy Database Wizard that I mentioned above. Choosing the Move option that will deletes the source database automatically after moving the database. If I misunderstood, please let me know. But we suggest you delete database carefully, if you are in product environment. 
     
    By the way, If you have resolved your issue, please mark the useful reply as answer. This can be beneficial to other community members reading the thread.
    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Avyayah Tuesday, January 28, 2020 3:40 PM
    Monday, January 27, 2020 7:23 AM

All replies

  • Hi Avyayah,

    You can use the Copy Database Wizard as below screenshot.  The Copy Database Wizard moves or copies databases and certain server objects easily from one instance of SQL Server to another instance, with no server downtime.

    During the process, please choose Use the SQL Management Object method option, database users can continue to access the database during the transfer. And please choose the Copy option, this option will not deletes the source database automatically after moving the database. Please refer to Use the Copy Database Wizard to get more information. Or you can refer to this blog to get more information.

    Best regards,
    Cathy   


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Friday, January 24, 2020 1:01 AM
  • Other option: Copy Databases with Backup and Restore

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, January 24, 2020 7:44 AM
    Moderator
  • We can achieve it using below options.

    >> Using the Copy Database Wizard.

    >> Restoring a database backup.

    >> Using the Generate Scripts Wizard to publish databases

    For more details please go through below Article it may helps you.

    https://docs.microsoft.com/en-us/sql/relational-databases/databases/copy-databases-to-other-servers?view=sql-server-ver15


    Please click "Mark as Answer" if it solved your issue and/or "Vote as helpful" if it helped. This can be beneficial to other community members reading this thread.

    Friday, January 24, 2020 9:17 AM
  • Thanks for the response. What would be the best process to clean up the database from the server?
    Friday, January 24, 2020 10:13 PM
  • Thanks for the response. What would be the best process to clean up the database from the server?
    Hi Avyayah,

    >> Thanks for the response. What would be the best process to clean up the database from the server?

    Did you mean that you want to delete the database that have been copied? If that, you can use the Copy Database Wizard that I mentioned above. Choosing the Move option that will deletes the source database automatically after moving the database. If I misunderstood, please let me know. But we suggest you delete database carefully, if you are in product environment. 
     
    By the way, If you have resolved your issue, please mark the useful reply as answer. This can be beneficial to other community members reading the thread.
    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Avyayah Tuesday, January 28, 2020 3:40 PM
    Monday, January 27, 2020 7:23 AM