none
MS SQL - PC without development studio 2017 RRS feed

  • Question

  • Hello,
    C:\Users\Freitag\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB
    2 Files
    Connectionstringtest sb
    Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=TestDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False
    I create my application with a test database. I install it on a PC without a development environment.
    Then I test this application.
    If good, then I enter the correct connection string to customer database.
    What do I have to install on the PC. Which files of the test database do I have to copy?
    Thanks in advance for the tutorial / guideline.
    Greetings Markus
    Saturday, July 27, 2019 10:00 AM

Answers

  • Hello,

    From the following installation there is an option to install LocalDb

    https://www.microsoft.com/en-us/sql-server/sql-server-editions-express


    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    StackOverFlow
    profile for Karen Payne on Stack Exchange

    Saturday, July 27, 2019 11:01 AM
    Moderator
  • From the following installation there is an option to install LocalDb

    https://www.microsoft.com/en-us/sql-server/sql-server-editions-express



    Hello Karen,

    Thanks for the quick response.

    So I install this and copy my two files.

    That is it, right?

    Have a nice weekend.

    Greetings Markus

    All you have to do is use the MSI installation file for MS SQL Server Express Localdb, just make sure you are using the Localdb for the version of MS SQL Server Express you have developed against..  

    https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-2017

    <copied> 

    The LocalDB setup program uses the SqlLocalDB.msi program to install the necessary files on the computer. Once installed, LocalDB is an instance of SQL Server Express that can create and open SQL Server databases.

    <end>

    https://www.sqlshack.com/install-microsoft-sql-server-express-localdb/


    • Edited by DA924x Saturday, July 27, 2019 12:15 PM
    • Marked as answer by Markus Freitag Monday, July 29, 2019 5:01 PM
    Saturday, July 27, 2019 12:11 PM

All replies

  • Hello,

    From the following installation there is an option to install LocalDb

    https://www.microsoft.com/en-us/sql-server/sql-server-editions-express


    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    StackOverFlow
    profile for Karen Payne on Stack Exchange

    Saturday, July 27, 2019 11:01 AM
    Moderator
  • From the following installation there is an option to install LocalDb

    https://www.microsoft.com/en-us/sql-server/sql-server-editions-express



    Hello Karen,

    Thanks for the quick response.

    So I install this and copy my two files.

    That is it, right?

    Have a nice weekend.

    Greetings Markus

    Saturday, July 27, 2019 11:52 AM
  • From the following installation there is an option to install LocalDb

    https://www.microsoft.com/en-us/sql-server/sql-server-editions-express



    Hello Karen,

    Thanks for the quick response.

    So I install this and copy my two files.

    That is it, right?

    Have a nice weekend.

    Greetings Markus

    All you have to do is use the MSI installation file for MS SQL Server Express Localdb, just make sure you are using the Localdb for the version of MS SQL Server Express you have developed against..  

    https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-2017

    <copied> 

    The LocalDB setup program uses the SqlLocalDB.msi program to install the necessary files on the computer. Once installed, LocalDB is an instance of SQL Server Express that can create and open SQL Server databases.

    <end>

    https://www.sqlshack.com/install-microsoft-sql-server-express-localdb/


    • Edited by DA924x Saturday, July 27, 2019 12:15 PM
    • Marked as answer by Markus Freitag Monday, July 29, 2019 5:01 PM
    Saturday, July 27, 2019 12:11 PM