locked
SQL Express with Advanced Services - Read / Write Operation RRS feed

  • Question

  • Iam using SQL Express with Advanced Services database with my Building management system application software. Can a 3rd party system read / write in to my SQL Express database? Third party system may be access or lighting control which may use SQL or proprietary database. It may a SQL database level integration or any other alternative methodology.

    Are there any limitations on number connection to external source or on the data transfer? 

     

    Sunday, May 24, 2015 10:48 AM

Answers

  • Data import and export feature is not available with SQL Server Express.

    Again a wrong information and senseless I dont know how import export wizard matter here. It was not available in SQL Server 2005 but from 2008 onwards it is available for express edition

    Pradeep

    Third party application can connect to SQL Server and such there is no limitation with connection AFAIK but please check documentation I gave at the bottom. Yes there is limitation with

    Database size Max 10G from SQL Server 2008 R2 and above. This does not includes size of log file so log file can be bigger than 10 G

    RAM Not more than 1.5 G of RAM for DB engine

    CPU Single core only

    Please see Features supported by various edition of SQL Server


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP


    Sunday, May 24, 2015 12:29 PM