question

MaxineNietz-6447 avatar image
0 Votes"
MaxineNietz-6447 asked Cathyji-msft commented

How to move an SQL database???

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.

sql-server-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @MaxineNietz-6447,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MaxineNietz-6447 avatar image
0 Votes"
MaxineNietz-6447 answered Cathyji-msft commented

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

Waiting for your good news.

0 Votes 0 ·

Hi ,

Any update for this thread? Could you share us the progress?

0 Votes 0 ·