August 18, 2017 at 3:17 pm
I am needing a development environment for SQL Server SSIS processors and I thought I would ask a forum like this if anyone knew of one? AWS Amazon Web Services has several cloud servers with 2008 SQL Server R2 but they will not load the SSIS packages. I could myself they tell me if I have a licence. I do not. I just want to rent a development environment for about 2 months. Does anyone know of one? This seems so close yet I am not getting it to happen. I have SSIS in my Microsoft 2015 Visual Studio but it is not backward compatible. I do not want to have to purchase 2008 licenses for all of this short term development. I am hoping others in this forum have found the answer that I am not finding. Let me know. I want to pay for the service but I really do not want to pay for the licenses that will be wasted.
August 21, 2017 at 8:33 am
I think that you need to use Visual Studio 2008 (with the SQL Server Data Tools installed) and that should allow you to create SSIS pacakges to run against a 2008 R2 SQL instance.
I know that was how we did it in the past before upgrading to SQL 2012; then we could use Visual Studio 2012 or 2015.
Looking online, you should be able to install SQL 2008 R2 Developer on your machine for free and then you wouldn't need an SSIS host.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 21, 2017 at 8:57 am
@bmg002 - SQL 2008 R2 Developer Edition is not free--it is $50 (or more...). The Developer Edition of SQL Server did not begin being a free download until SQL Server 2014. Every version prior was (at least) $50.
@bill - Do you have to have the full Developer Edition of SQL Server, or could you get by with using SQL Server Express? Express is and always has been free--there are some limitations of the free edition, like SQL Agent is disabled and there are size limitations. You may be able to find it from a retail site, like Amazon, but when I searched for it, it was around $200--probably because it's an older version, and it looked like it was a DVD instead of a download (I didn't click the link, so I'm not sure).
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 21, 2017 at 9:10 am
Right... forgot that developer only went free with future versions.
With express, does that let you do SSIS? I can't remember and it has been a very long time since I worked with Express.
Looking online (https://stackoverflow.com/questions/292564/can-i-run-ssis-packages-with-sql-server-express-or-web-or-workgroup-editions) it sounds like SSIS works in a very limited manner with Express in SQL 2005... not sure about 2008.
As for cloud SSIS, I am not seeing any good solutions for that apart from spinning up a cloud VM and instlaling SQL Server on it (which would require a license of some flavor).
But getting a SQL 2008 R2 Standard license should be pretty cheap as it is quite old software and no longer supported. BUT as it is no longer supported, finding a valid working license for it may be tricky.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 21, 2017 at 9:52 am
SQL Server 2008 and R2 is supported until 2019. Only mainstream support has ended. See this MSDN blog post:
https://blogs.msdn.microsoft.com/sqlreleaseservices/end-of-mainstream-support-for-sql-server-2008-and-sql-server-2008-r2/
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 21, 2017 at 10:42 am
Geeze, I seem to be bad at offering advice today, eh?
I apologize for the misinformation I provided.
That being said, and back to the OP, I don't think there is any cloud-bsed SSIS system apart from running SSIS on a VM (which would require a SQL Server license). At least, everything I looked up (which was brief) showed that you needed to spin up a VM for that.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 21, 2017 at 10:45 am
LOL! No worries. It's Monday. "Technically", your response was accurate...with an asterisk. SQL 2008 is no longer in mainstream support. It's now on extended support. 🙂
Anyway, @bill, I think your option is to spin up a VM with SQL 2008 R2 and SSIS (if you can find a provider to do that) or to "order" Developer Edition and install it on your local machine.
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 21, 2017 at 10:55 am
bmg002 - Monday, August 21, 2017 9:10 AMWith express, does that let you do SSIS? I can't remember and it has been a very long time since I worked with Express.
Looking online (https://stackoverflow.com/questions/292564/can-i-run-ssis-packages-with-sql-server-express-or-web-or-workgroup-editions) it sounds like SSIS works in a very limited manner with Express in SQL 2005... not sure about 2008.
This one is correct, it's limited with all current versions. Here is the 2008 features document:
Features Supported by the Editions of SQL Server 2008 R2
Sue
August 23, 2017 at 9:21 am
Thank you all for your thoughts. I was afraid the answer was not a simple one. I have decided to try getting a copy of the 2008 SQL Server R2 Developer and running it locally or in a local virtual. Perhaps I could even use its license in an Amazon cloud server but I am not sure yet. I had hoped for a sandbox but I really liked the idea that this aged software might be on the cheap now and it was. Thank you for letting me ask for help on your forum.
August 23, 2017 at 9:26 am
@bill - Keep in mind that SQL Server 2014 and higher has a Developer Edition that is completely free, and downloadable from Microsoft's site(s). So...you could go with a more recent version and it would be the cheapest you can get (free!). 🙂
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply