locked
database in Visual Studio 2015 - can we use it in SQL Server 2014 - SQLExpress RRS feed

  • Question

  • User-945256609 posted

    Dear all,

    I am planning to create a asp.net application and database using Visual Studio project. Can I use this database at later stage in SQL Server in production environment.

    can you clarify?

    Thanks

    sathya

    Thursday, July 7, 2016 8:27 AM

Answers

  • User753101303 posted

    Hi,

    Use SELECT @@Version to see what you have on both sides. If the version level match you should be able to backup and restore the db in both direction. Usually on the VS side it uses SQL Local Db and perhaps a connection string that points to a file while on a production environment you point to a SQL Server instance.

    You can still give a try at running your app in production condition to avoid last minute surprises especially if you are new to all that.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 7, 2016 9:14 AM

All replies

  • User753101303 posted

    Hi,

    Use SELECT @@Version to see what you have on both sides. If the version level match you should be able to backup and restore the db in both direction. Usually on the VS side it uses SQL Local Db and perhaps a connection string that points to a file while on a production environment you point to a SQL Server instance.

    You can still give a try at running your app in production condition to avoid last minute surprises especially if you are new to all that.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 7, 2016 9:14 AM
  • User-271186128 posted

    Hi sathya,

    database in Visual Studio 2015 - can we use it in SQL Server 2014 - SQLExpress

    By default, the SQL Server version in Visual Studio 2015 is 2014.

    Best regards,
    Dillion

    Thursday, July 14, 2016 8:16 AM