Does TOAD and SQL Navigator Team coding use the same tables?
Is it possible to use Toad and SQL Navigator with only one team coding installation, because some users like to use the SQL Navigator and others like to use Toad.
RESOLUTION:
Both can use the same tables so you would only need to install the server side objects once.
If you get a prompt that you need to update your tables in SQL Nav, there is a TCupdate_xx.sql file located in the SQL Nav/Install directory. You may need to run it.
Also, the roles are named different in nav and toad but it should be ok.
This has been tested by installing team coding in Toad and was able to use it in SQL Navigator as well.
-- TCupdate_70.sql
-- Update Quest Team Coding Support Objects to version 7.0 (SQL Navigator 5.1 or later)
--
-- Copyright (c) 2006 Quest Software.
-- All Rights reserved.
--
-- ** This script should be used when upgrading from SQL Navigator 5.0
-- to SQL Navigator 5.1 or later.
--
-- ** It is assumed that Team Coding Support was installed with an earlier
-- version of Navigator. If Team Coding Support has not been installed,
-- run the Server Side Installation Wizard instead of this script.
--
-- ** This script must be run under the SQLNAV user
--
-- ** Run this script in a fresh session.
--
-- ** If using Oracle version < 8.15, PRAGMA declaration in final statement must
-- be removed.
--
-- ** Restart all sessions for current database after executing.
-- Insert rows for new Team Coding file extensions
INSERT INTO sqln_vcs_fileext (vcs_objtype, vcs_objext)
VALUES ('TABLE', 'TAB')
/
INSERT INTO sqln_vcs_fileext (vcs_objtype, vcs_objext)
VALUES ('INDEX', 'IDX')
/
INSERT INTO sqln_vcs_fileext (vcs_objtype, vcs_objext)
VALUES ('SEQUENCE', 'SEQ')
/
INSERT INTO sqln_vcs_fileext (vcs_objtype, vcs_objext)
VALUES ('SYNONYM', 'SYN')
/
INSERT INTO sqln_vcs_fileext (vcs_objtype, vcs_objext)
VALUES ('JAVA SOURCE', 'JSC')
/
INSERT INTO sqln_vcs_fileext (vcs_objtype, vcs_objext)
VALUES ('CLUSTER', 'CSR')
/
-- note: if using Oracle version < 8.15, delete the following PRAGMA line and be
-- aware that all updates in current session will be committed.
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
UPDATE SQLNAV4_VCS_CONFIG
SET VERSION = '0070Nav 0510';
COMMIT;
END;
/
STATUS:
None.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center