Hi All,
Good Evening.
I need a comparision between Evaluation copy and Standard license version of SQL Server 2005 /SSIS.
I'm assigned a task to evaluate SSIS and migrate a project to SSIS.
I have downloaded SSIS evaluation version and started working on that.
Now i'm being posed questions for the complete functionality of the tool...
- Whether it has a Bulk load trasformation ?
- Whether the evaluation version contain all the features of a standard license version ?
I need to submit a consolidated report for SSIS in comparision to the current ETL tool features.
Can you please let me is there any considerable features not given with a evaluation copy ?
Thanks in advance,
Suresh N
As I understand it, the only difference between trial versions of SQL Server and the retail versions of the same edition (in this case, Standard Edition) is the 120-day time bomb on the software. All of the features should be identical. WIth that said, I've beeen unable to find supporting documentation on this point, so please do not take my word as gospel here.
Another option is for you (or your employer/client) to get an MSDN subscription. With this you can use the 'real" SQL Server Standard Edition and not worry about any differences with the trial edition.
One last point: SSIS has a Bulk Load task, but for most situations you actually want to use the Data FLow task when you're bulk loading data, as it has phenominal performance and many more capabilities than a simple bulk load.
|||I think that most of the trial versions include the Enterprise Edition feature set. You can see the comparison between editions here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx|||Thanks much Matthew.
Regards,
Suresh N
