March 1, 2013 at 12:26 am
Hello All, I have one query (it may sound stupid though). We have one SQL Server 2008 (Microsoft SQL Server 2008 (SP2) - 10.0.4266.0 (X64)) and on my machine I've installed the client tools.
We have some process where we create soem bulky temp tables after doing some heavy processing on sybase and thereafter through a java code the data in those temp tables in Sybase are transferred to SQL batchwise. I think this is not safe and efficient strategy and somewhat time consuming and also feel that it should be handled using SSIS packages (?). Can anyone suggest on that ?
Secondly, if creating SSIS package is good option then will I have to uninstall the SQL client on my machine and install the developer edition (with business studio) ? Is there license requirement (we have license for SQL Server Enterprise Edition) ?
March 1, 2013 at 1:57 am
sqlnaive (3/1/2013)
Hello All, I have one query (it may sound stupid though). We have one SQL Server 2008 (Microsoft SQL Server 2008 (SP2) - 10.0.4266.0 (X64)) and on my machine I've installed the client tools.We have some process where we create soem bulky temp tables after doing some heavy processing on sybase and thereafter through a java code the data in those temp tables in Sybase are transferred to SQL batchwise. I think this is not safe and efficient strategy and somewhat time consuming and also feel that it should be handled using SSIS packages (?). Can anyone suggest on that ?
Secondly, if creating SSIS package is good option then will I have to uninstall the SQL client on my machine and install the developer edition (with business studio) ? Is there license requirement (we have license for SQL Server Enterprise Edition) ?
For data migration tasks , SSIS should be a better option .. I really can't extend my opinion on this except that we use SSIS for more like huge and frequent data transfer wherein different providers are invloved..
about the licence ; enterprise edition should do .. It worked for me , but it was for 2008 .. not sure about 2012 .. I think there is a special business intelligence edition too ...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
March 1, 2013 at 4:24 am
about the licence ; enterprise edition should do .. It worked for me , but it was for 2008 .. not sure about 2012 .. I think there is a special business intelligence edition too ...
How can I find what sql 2008 client is installed in my local machine ?
March 4, 2013 at 8:11 am
Can anyone please help ?
"In corporate world, how should business intelligence be installed and used for development purpose when we already have our application productionized ? Currently neither we are using business studio nor we have installed them"
March 4, 2013 at 8:21 am
SQL Server Installation Centre (should be on your start menu) has a 'Installed SQL Server features discovery report' option in the Tools menu.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply