DataStage V8.0 upgrade on SQL Server
Posted: Fri Jan 26, 2007 10:29 am
Hi:
We are looking to upgrade the Server Component only for Information ServerV8.0. We would like to have SQL server as our metadata repository.
I have SQL Server 2005 installed on a server. I created the repository database on SQL Server 2005 with the SQL scripts shipped with the install. The server/client components of DataStage would have to be installed on my desktop
During installation, I chose custom install and there is no way to select/deselect metadata repository. I would need this to install the metadata repository first on the SQL Server machine and then the rest of the components on my desktop. However, the graphical install takes me to a page where it identifies there is no DB2 install on my machine and goes ahead installing DB2. I would like to know if there is an option I'm missing to install the program in parts. Or is there a separate license required if the repository has to be on a database other than DB2
Thanks
We are looking to upgrade the Server Component only for Information ServerV8.0. We would like to have SQL server as our metadata repository.
I have SQL Server 2005 installed on a server. I created the repository database on SQL Server 2005 with the SQL scripts shipped with the install. The server/client components of DataStage would have to be installed on my desktop
During installation, I chose custom install and there is no way to select/deselect metadata repository. I would need this to install the metadata repository first on the SQL Server machine and then the rest of the components on my desktop. However, the graphical install takes me to a page where it identifies there is no DB2 install on my machine and goes ahead installing DB2. I would like to know if there is an option I'm missing to install the program in parts. Or is there a separate license required if the repository has to be on a database other than DB2
Thanks