what is the different b/w SSIS & commercial tools
I know there are many commercial tools to migrate data from sql server to another sql server (like Red-gate tools, PolyServer from HP, file-aid from Compuware) but I am not sure what is the different between these tools and the built-in sql sever integration services (SSIS)? Why there are commercial tools and people are buying and paying money for license and support whereas there is built-in tool? What are the advantages of the commercial tools?
Re: what is the different b/w SSIS & commercial tools
I often wonder the same. Is it worth it to buy commercial tools versus using the built in? Sorry - I have no answers, just the same questions. Clearly the marketing of these tools is good.