How to move an SQL database???

Question

I have SQL Server management Studio 18. I have built a database therein.
I need to be able to move that database, named MATERIALSSQL to a different version of SQL.
I do NOT know the version of the receiving software.

Should I export? If so, how is it done? I have tried Tasks>Export Data. No matter which Datasource I select, I get the following error:
"The operation could not be completed. Additional information: - "

I have made a .bak backup file, but am not sure this will work. I need to get the database onto a thumb drive and to another computer by Monday.

I could use all the help I can get. 30 years experience with Access, practically none with SQL.

Thank you in advance.

Answer 1

Hi @Maxine Nietz ,

From your description, it seems that you want to migrate databases from one server to another server? If I misunderstood, please let me know.

If you do not know the destination SQL server version , please run select @@version command to check the destination SQL server version.

You can try below methods to move databases to other server.

1. You can use the BACKUP and RESTORE database. Backup the databases on server A, copy the backup files to server B , then restore the databases on server B.
2. You can also use the Copy Database Wizard to move database to other server. Right click database >Task >Copy database.
3. You can also use the Generate Scripts Wizard to move a database.

If you have any confused about my suggestion, please feel free to let me know.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @CathyJi-MSFT ,
Thanks you for your answer.

I have a backup and will try to restore.
My SQL does NOT have the Copy Database Wizard at Task>Copy database, so that one is out.
I also copied the entire project to my thumb drive.
I will also try the Generate Scripts Wizard as well.

I will try these methods on Monday when I go to the location of the destination SQL and let you know.

Thanks again.