question

JeannieHCollaberaVendor avatar image
0 Votes"
JeannieHCollaberaVendor asked AmeliaGu-msft commented

Why is Import --> Database... grayed out?

In SQL Server Data Tools v 15.9.40, I am trying to import a database in the solution explorer and the option for Import --> Database... is grayed out.

How do I get this option working again?

143505-image.png


sql-server-general
image.png (50.2 KiB)
· 1
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 JeannieHCollaberaVendor,

How are things going? Do the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi JeannieHCollaberaVendor,
This is because the ability to import a schema from a database or .dacpac file is only available when no schema objects have been defined in the project.

You can add a new project to the solution by right-clicking the solution-> Add ->New Project.

143625-image.png

Then you can import database to the new object.

143651-image.png

Best Regards,
Amelia


If the answer is the right solution, 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.



image.png (32.6 KiB)
image.png (22.0 KiB)
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.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

You can import existing database only into a new, empty project of type "Database"; is this the case here?

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.