SSDT with Express Edition

  • Hello Community!

    A customer has an SQL Server Express Edition running in his company. Now I should help to build a system for reporting. As different resources are used, I thought about the SSDT software package. As the Express Edition has not SSIS Support, I am wondering if I am allowed to use the SSDT to import data in regular intervals.
    I have found nothing in the license terms about a minimum requirement of the SQL Server version. Have I missed something?

    Thank you for the information.
    Best Regards
    Alex

  • Alex-489474 - Thursday, April 20, 2017 12:36 AM

    Hello Community!

    A customer has an SQL Server Express Edition running in his company. Now I should help to build a system for reporting. As different resources are used, I thought about the SSDT software package. As the Express Edition has not SSIS Support, I am wondering if I am allowed to use the SSDT to import data in regular intervals.
    I have found nothing in the license terms about a minimum requirement of the SQL Server version. Have I missed something?

    Thank you for the information.
    Best Regards
    Alex

    As SQL Server Express Edition does not support Integration Services, what do you expect SSDT to be able to do?   Without SSIS, there's no way for an SSIS package to run on that instance.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • sgmunson - Thursday, April 20, 2017 10:50 AM

    As SQL Server Express Edition does not support Integration Services, what do you expect SSDT to be able to do?   Without SSIS, there's no way for an SSIS package to run on that instance.

    Wouldn't manually clicking on 'Start' in SSDT work? I've never tried, but I can't see why not.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • I'm pretty sure that SSDT does work on Express. In fact, I'm confident we have a package that connects to a third party Express database at the office. Yes, the package runs on the SQL server, but it would have been initially developed in SSDT. That, or it's not actually Express... That could be a licence problem... I'll pretend I didn't say anything. :Whistling:

    I'm personally not a fan of the idea, as it relies on a user or someone "remembering" (and I don't trust users, and I often don't trust myself to "remember" to do a task every week/month), but it should work for you provided your confident it'll always get done. 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • As SQL Server Express Edition does not support Integration Services, what do you expect SSDT to be able to do? ...

    I'm pretty sure that SSDT does work on Express.

    I have created an example package for them which I run against my local Express installation. My concern is, that the execution of the package is influenced by the installed developer edition on my laptop

    Wouldn't manually clicking on 'Start' in SSDT work?

    See the quote above. I think I will have to check this on a virtual machine installation.

    ...Without SSIS, there's no way for an SSIS package to run on that instance.

    I read somewhere else that they developed a package. The package was running through the windows task planer with a batch file. The file started an executable file which is installed with the SSDT. So they were able to run the package on a regular interval against their express edition. I will post the link to the thread if i find it again.

    Wheter it is technically working, I have not found anything that states using the SSDT with an Express Edition is - in terms of licensing - allowed or permitted.

    Best Regards
    Alex

  • Licence terms can be found here: https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools-license-terms

    A quick scan doesn't say anything, but it would be worth reading and checking yourself. for your own benefit.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • All,

    SSIS packages do require an instance of SSIS to be able to run, unless SSDT has now effectively simulated what the Integration Services service was doing in older versions of SQL Server.   So what that means is that you could potentially run a package on a Windows client machine with just SSDT installed (and no SQL instance), that then accesses data on an Express instance.   That is NOT the same, however, as running the package directly on the Express instance.   Thus, if a local developer edition instance of SQL is on the Windows client, then that instance of SSIS would actually "RUN" the package.   I have not yet been given any direct statement that says that SSDT alone is sufficient to run a package, and while that may be, I just haven't heard it yet from anyone I would implicitly trust on matters of this nature.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • sgmunson - Friday, April 21, 2017 8:53 AM

    All,

    SSIS packages do require an instance of SSIS to be able to run, unless SSDT has now effectively simulated what the Integration Services service was doing in older versions of SQL Server.   So what that means is that you could potentially run a package on a Windows client machine with just SSDT installed (and no SQL instance), that then accesses data on an Express instance.   That is NOT the same, however, as running the package directly on the Express instance.   Thus, if a local developer edition instance of SQL is on the Windows client, then that instance of SSIS would actually "RUN" the package.   I have not yet been given any direct statement that says that SSDT alone is sufficient to run a package, and while that may be, I just haven't heard it yet from anyone I would implicitly trust on matters of this nature.

    This is not correct, as you'll see from this page: " The Integration Services service ... is not required to create, save, and run Integration Services packages."
    We're getting into semantics a little, but the OP is not asking about 'running a package on an Express instance', instead, they are asking about using SSDT to run a package, essentially in design mode, to move data into the instance.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Hello Phil!

    This is not correct, as you'll see from this page: " The Integration Services service ... is not required to create, save, and run Integration Services packages."
    We're getting into semantics a little, but the OP is not asking about 'running a package on an Express instance', instead, they are asking about using SSDT to run a package, essentially in design mode, to move data into the instance.

    This is exactly the reason why I am asking. I read through the license terms and other resources but found no information if I am allowed to run a package through SSDT against an express edition that is used in a productive environment to move data into the instance.

    So I am asking if it is allowed to run a package in regular intervals, that is excecuted through SSDT, against an Express Edition.

  • from the licensing terms at https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools-license-terms

    Installation and Use.

      You may install and use any number of copies of the software on your devices to design, develop and test your programs.

    And looking at the features per edition at https://docs.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server

    we see that most of the integration services features are not available on the express edition

    So based on the above most would consider that you can not use SSDT to do production work at it is not on the list of allowable usage.

    As for the link that Phil gave - yes the Integration Services SERVICE is not required to run the packages - this is because from SQL 2012 SSIS catalog was introduced and that does not require the independent service - but the usage of Integration Services is still there and still needs to be selected as part of an install of a instance

  • As for the link that Phil gave - yes the Integration Services SERVICE is not required to run the packages - this is because from SQL 2012 SSIS catalog was introduced and that does not require the independent service - but the usage of Integration Services is still there and still needs to be selected as part of an install of a instance 

    The implication that the IS service was required to run packages prior to 2012 is not correct. See here, for example.

    I do, however, agree that, at minimum, it goes against the spirit of the licensing terms to routinely fire up SSDT & use it to populate a production instance of Express.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply