April 11, 2008 at 2:36 pm
Hi,
I am new to SQL Server and SSIS. I am migrating an app from Visual FoxPro to SQL 2005 and I need to do a one time data load. I have SQL Developer and I have done an Import Wizard and worked with it in BIDS but it is not sufficient (I think) for the transformations required. I have started learning more of SSIS but before I go too far I have a question on deployment. I know I can develop the package on my developer edition and deploy it to another SQL Server (the database will be on a system that is in a different state) but the original plan was to deploy the system using SQL Express (the database is only about 700MB). I could use Workgroup Edition if necessary but I understand that Workgroup only comes with the wizard (which I know I can also download and add to Express).
If I develop a package on Developer and deploy it to Express or Workgroup can the package be run from there?
April 11, 2008 at 3:13 pm
No, unfortunately you cannot deploy an Integration Services package to SQL Express or Workgroup:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
April 11, 2008 at 3:35 pm
Thanks Tim. I kind of thought that might be the case.
Is there any reason I could not develop the package on my Developer Edition and move both it and the package to my laptop, then go on site, run the package against the live database then drop the database move it to their server and attach it? This is far from ideal since I will have to do it again at the end of Beta and I really don't like flying anymore. Of course all of this assumes I can even figure out how to build the package in the first place.
April 12, 2008 at 1:29 pm
I just went back and reread the EULA. Guess I'll have to find another way to get there from here.
" a. General. One user may install and use copies of the software to design, develop, test and demonstrate your programs. Testing does not include staging on a server in a production environment, such as loading content prior to production use."
Tom Harbin
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply