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

JeannieH(COLLABERA INC) 391 Reputation points
2021-10-25T20:19:55.157+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,489 questions
{count} votes

2 answers

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-10-26T02:54:42.89+00:00

    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.

    0 comments No comments

  2. Olaf Helper 40,246 Reputation points
    2021-10-26T06:01:23.85+00:00

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