Solaris system and database migration help

10 More Discussions You Might Find Interesting

1. Solaris

Migration of Solaris 10 on physical host to Solaris Zones

Hi All Kindly let me know how can I move Solaris 10 OS running update 10 on physical machine to another machine solaris zone running Solaris 10 update 11

2. Shell Programming and Scripting

UNIX file system to Linux file system migration

We would be migrating UNIX file system to Linux file system. We do have many directory and sub directories with files. after migrating unix to linux file system , i want to make sure all the files has been copied ? What would be the best approach to validate directory ,sub-directory and file...

3. Linux

Migration from solaris to linux

Hi, Currently I can able to access php script from solaris. I want to access from Linux I have done the following things: 1) I have copied all the scripts from solaris to linux. 2) I have installed php,mysql,apache. I tried with http://Hostname/username/test.php . This is not working ....

4. Solaris

redirect solaris database from linux database..

hi.. i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database which is in solaris 10 x86... can u tell me the procedure .. how it can be done through php .. sorry am new to php... is it possible to redirect from linux mysql to...

5. Solaris

Solaris printing system migration

Hello folks, I'm currently working on migration of printing system from one server to another (namely from Sol 9 to Sol 10). I would like ask if is possible to manage migration via simple copying /etc/printers.conf file and folder /etc/lp to the new server??? I'm not sure if printers...

6. Shell Programming and Scripting

Connect to remote database from solaris system

Hi, i need to connect to a oracle database available in a remote PC (reachable from the host solaris server). I have added the tnsnames of that remote DB in to the tnsnames.ora file of the host solaris server. Am able to ping that IP. How do i connect to that DB for running sql...

7. Solaris

Migration from solaris 8 to 10

Hello, We have upgraded our system from SunOS 5.8 to Solaris 10. I would like to know if the applications (written in c, c++, pro*c, java,..) running on the 5.8 can run on the Solaris 10 without code modification or the need to be recompiled ? thanks you for your help.

8. UNIX for Advanced & Expert Users

Solaris migration

Hi , There is going to be a server migration from Solaris 8.0 to Solaris10.0. Could anyone give me some tips and documents regarding the steps to be remembered,tips to be followed etc. like syntax differences any new changes to the existing commands and tools we use whatever the...

9. Solaris

Migration Solaris 5.8 to 10

Hi, it is necessary to make the migration of Solaris 5.8 for Solaris 10, would like to know which the best form to execute this task, if to be able to say me where I can arrange some manual that helps me to make this task. Thanks :o

10. UNIX for Advanced & Expert Users

Database Migration

Hi All, This question is mainly to get help from u all experts for a database vendor change we are in the process of migrating our database vendor from INFORMIX to ORACLE to run on SOLARIS 9.4 box. Hence we need to work out on our applications which all are written in native 4GL (an easy...

LEARN ABOUT SUNOS

capture-schema

capture-schema(1m)					    Application Server Utility						capture-schema(1m)

NAME

       capture-schema -  stores the database metadata (schema) in a file for use in mapping and execution

SYNOPSIS

       capture-schema-dburl url-username name- password password-driver a_jdbc_driver [-schemaname name] [-table tablename]* [-out filename]

       Stores  the  database metadata (schema) in a file. You can also use the Sun Java System Studio IDE to capture the database schema. Run cap-
       ture-schema as the same database user that owns the tables, so that the -username and -schemaname options  are  given  the  same  username.
       Additionally, you can grant the database user running the capture-schema command the ANALYZE ANY TABLE privilege.

OPTIONS

       -dburl		       JDBC URL expected by the driver for accessing a database.

       -username	       user name for authenticating access to a database.

       -password	       password for accessing the selected database.

       -driver		       JDBC driver classname in your CLASSPATH.

       -schemaname	       name of the user schema being captured. If not specified, the default will capture metadata for all tables from all
			       the schemas accessible to this user. Specifying this parameter is highly recommended. If more than  one	schema	is
			       accessible to this user, more than one table with the same name may be captured which will cause problems.

       -table		       name of the table; multiple table names can be specified.

       -out		       output target; defaults to stdout. This parameter corresponds to the schema sub-element of the sun-cmp-mapping ele-
			       ment in the sun-cmp-mapping_1_1.dtd file.

EXAMPLES

       Example 1: Using capture-schema

       capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
       -schemaname cantiflas -username CANTIFLAS -password enigma -driver
       oracle.jdbc.driver.OracleDriver

       asadmin(1M)

Sun Java System Application Server				    March 2004							capture-schema(1m)

Solaris