none
SQL service installation at client end

    คำถาม

  • hello,

    i have a project which i have to install at the client end. it is done in VB.net and SQL 2008R2(SQLEXPRESS). My problem is when i make a setup file including All the necessary files (.mdf, .ldf, etc) and try to install at the clients end. the installation is complete, but when i try to run, it gives an error of SQL, coz the client machine does not have SQL, i do not want to install the whole SQL server coz it is a very small project, what are the alternatives for it please

    thanks and regards


    HV

    • ย้ายโดย Bob BeaucheminMVP 6 มีนาคม 2555 6:14 Moving to a more relevent forum for better results (From:.NET Framework inside SQL Server)
    5 มีนาคม 2555 4:35

คำตอบ

  • Hi Hari vaag,

    For SQL Server compact you can refer to this reference: http://support.microsoft.com/kb/920700/en-us

    I suggest you to use SQL Server localDB, LocalDB is created specifically for developers. It is very easy to install and requires no management, yet it offers the same T-SQL language, programming surface and client-side providers as the regular SQL Server Express. In effect the developers that target SQL Server no longer have to install and manage a full instance of SQL Server Express on their laptops and other development machines. Moreover, if the simplicity (and limitations) of LocalDB fit the needs of the target application environment, developers can continue using it in production, as LocalDB makes a pretty good embedded database too.

    You can refer to: http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx 


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • ทำเครื่องหมายเป็นคำตอบโดย Hari Vaag 7 มีนาคม 2555 12:18
    7 มีนาคม 2555 7:04
    ผู้ดูแล

ตอบทั้งหมด