Share via

SQL to WID migration

Mateusz Bęben 1 Reputation point
2020-12-16T14:19:48.9+00:00

Hello,

If it possible moving SQL databse to WID? If yes, how I can do this? I found a lot of guide to migrate in other side but I can't find complete guide to migrate from SQL to WID.

Regards,

Mateusz

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,865 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Shashank Singh 6,251 Reputation points
    2020-12-16T15:30:57.83+00:00

    By WID you mean Windows Internal Database ? If yes WID is not supported database configuration and MS does not suggests you to use it as full fledged DB. See this Windows Internal Database (WID) is Not Destined as a Regular SQL Server

    What is the reason for such migration ?

    0 comments
  2. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2020-12-17T03:23:56.803+00:00

    Hi @Mateusz Bęben ,

    I agree with Shashank. In addition, the WID is designed to only be accessible to Windows Services running on the same machine and is not available as a standalone product for use by end-user applications. Therefore, migrating SQL Server database to WID does not seem appropriate.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.