SQL Server Express: How to export/import database with Management Studio

Yihui Bai 0

I tried to export/import database between SQL Server Express 2016 and 2019, the results show me all success but did nothing. Is there anyone has experience on that?

Olaf Helper 44,931 Reputation points

2023-08-30T10:45:42.6433333+00:00

What do you mean with Export/Import? Please describe you process/steps more detailed.
Yihui Bai 0 Reputation points

2023-08-31T07:14:35.4933333+00:00

I would directly backup database from SQL Server 2016 Express@AWS to local SQL Server 2022 Express. As you know Integration Service is not present for Express so I go with Management Studio like this:

Right click remote database, select "Tasks"->"Export Data" to start the wizard, select "Microsoft OLE DB Provider for SQL Server" at "Data Source", make sure both remote source database and local destination database are connected successfully, "Copy Data from one or more tables or views", select all tables , then save and run the SSIS package immdiately, all looks good but it did nothing.

1 answer

AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor

2023-08-31T06:03:12.7033333+00:00

Hi @Yihui Bai

Do you want to use this import and export function: Import and Export Data with the SQL Server Import and Export Wizard?

Or do you want to backup and restore the database or generate script files?

Backup and restore

Script objects in SQL Server Management Studio

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya
Please sign in to rate this answer.
Yihui Bai 0 Reputation points

2023-08-31T07:16:05.1766667+00:00

Yes

I would directly backup database from SQL Server 2016 Express@AWS to local SQL Server 2022 Express. As you know Integration Service is not present for Express so I go with Management Studio like this:

Right click remote database, select "Tasks"->"Export Data" to start the wizard, select "Microsoft OLE DB Provider for SQL Server" at "Data Source", make sure both remote source database and local destination database are connected successfully, "Copy Data from one or more tables or views", select all tables , then save and run the SSIS package immdiately, all looks good but it did nothing.

Yihui Bai 0 Reputation points

2023-08-31T07:22:12.12+00:00

Yes, I followed the import and export wizard.

AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor

2023-08-31T08:07:48.18+00:00

Hi @Yihui Bai

If it runs without any errors, the table should be copied to the new database. I did a simple test, a table has been copied from another database to the current database.

Can you refresh it and see?

Best regards,

Aniya

Yihui Bai 0 Reputation points

2023-08-31T08:22:36.13+00:00

I refreshed many times but it doesn't work , Aniya

:-(

AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor

2023-09-05T08:54:04.27+00:00

Hi @Yihui Bai

I tested again. Export/Import database from remote SQL Server Express 2016 to SQL Server Express 2019. After all actions are successful, the table is successfully copied to the 2019 database.

All your actions succeed, but nothing happens, which is weird. Since we can't check the status of your server in the forum, issues like this are often difficult to resolve. I recommend that you consider using the phone support service provided by Microsoft, which can often help you solve your problem.

https://support.microsoft.com/en-us/help/4051701/global-customer-service-phone-numbers
https://support.microsoft.com/en-us/supportforbusiness/productselection

Best regards,

Aniya

Yihui Bai 0 Reputation points

2023-09-05T09:42:59.92+00:00

@AniyaTang-MSFT Thank you for your suggestion. Actually I tried phone support service but was told MS doesn't provide any phone support for SQL Server Express.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SQL Server Express: How to export/import database with Management Studio

1 answer

Your answer