Toad World® Forums

Incremental Scripts - Team Coding


#1

We are doing the source coding using Team Coding with GIT as source controller. Below is the sample script.

CREATE TABLE TMP_TEST
(TXT VARCHAR2(200 BYTE));

Now I check out the table and going to edit the below table or using alter script to add a new column.

ALTER table tmp_test add new_col VARCHAR2(200));

I am doing the check out and see the code is changed as below.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE),

NEW_COL VARCHAR2(100 BYTE);

But, I would like to see the file as like below.

CREATE TABLE TMP_TEST
(TXT VARCHAR2(200 BYTE));

ALTER TABLE TMP_TEST ADD NEW_COL varchar2(100);

Is that possible using TOAD- Team coding?


#2

Hello,

Team Coding tracks changes to the actual DDL, so it does not track the associated alter statement when the Table was modified in the schema browser.

If you want to track changes to the script with the alter statements, I think the best approach would be to check the script in to Git from Toad. That way the alter statements are tracked in Git history.

Stephen

From: stanis.j.raja.-nd [mailto:bounce-stanisjraja-nd@toadworld.com]

Sent: Monday, July 13, 2015 5:55 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Incremental Scripts - Team Coding

Incremental Scripts - Team Coding

Thread created by stanis.j.raja.-nd

We are doing the source coding using Team Coding with GIT as source controller. Below is the sample script.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE));

Now I check out the table and going to edit the below table or using alter script to add a new column.

ALTER table tmp_test add new_col VARCHAR2(200));

I am doing the check out and see the code is changed as below.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE),

NEW_COL VARCHAR2(100 BYTE);

But, I would like to see the file as like below.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE));

ALTER TABLE TMP_TEST ADD NEW_COL varchar2(100);

Is that possible using TOAD- Team coding?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

Hi Stephen,

Thanks for your prompt reply. Appreciate the same.

I don’t understand what do you mean by “check the script in to Git from Toad.” Can you please explain the same?

I tried running multiple ALTER statements in TOAD on a single table, but when I see the script they are combined together as a single CREATE statements. Please guide.

Regards,

Stanis

From: Stephen Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]

Sent: Tuesday, July 14, 2015 7:55 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] [Toad for Oracle - Discussion Forum] Incremental Scripts - Team Coding

RE: [Toad for Oracle - Discussion Forum] Incremental Scripts - Team Coding

Thread created by Stephen Beausang

Hello,

Team Coding tracks changes to the actual DDL, so it does not track the associated alter statement when the Table was modified in the schema browser.

If you want to track changes to the script with the alter statements, I think the best approach would be to check the script in to Git from Toad. That way the alter statements are tracked in Git history.

Stephen

From: stanis.j.raja.-nd [mailto:bounce-stanisjraja-nd@toadworld.com]

Sent: Monday, July 13, 2015 5:55 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Incremental Scripts - Team Coding

Incremental Scripts - Team Coding

Thread created by stanis.j.raja.-nd

We are doing the source coding using Team Coding with GIT as source controller. Below is the sample script.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE));

Now I check out the table and going to edit the below table or using alter script to add a new column.

ALTER table tmp_test add new_col VARCHAR2(200));

I am doing the check out and see the code is changed as below.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE),

NEW_COL VARCHAR2(100 BYTE);

But, I would like to see the file as like below.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE));

ALTER TABLE TMP_TEST ADD NEW_COL varchar2(100);

Is that possible using TOAD- Team coding?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#4

TC will always show the actual DDL for the Table, without the alter statements. If you are using Team Coding to control Table Objects , Team Coding always stores the latest version of the Table DDL, so Team Coding will not do what you need. So you can’t handle this in the Toad Alter Tables window.

The alternative is to treat the Table DDL as a script. e,g MyTable.sql and make the changes in the editor. In my opinion, it is not a perfect solution, but may be closer to what you need.

The steps would be something like this.

  1.  Set Git as your VCS Provider
    
  2.  Add the MyTable.sql to VCS from the editor Team Coding Toolbar.
    
  3.  Check out MyTable.Sql to make a change .
    
  4.  Add Alter Script
    
  5.  Check in to Git from the editor.
    

From: Stanis [mailto:bounce-stanisjraja-nd@toadworld.com]

Sent: Tuesday, July 14, 2015 9:54 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] [Toad for Oracle - Discussion Forum] [Toad for Oracle - Discussion Forum] Incremental Scripts - Team Coding

RE: [Toad for Oracle - Discussion Forum] [Toad for Oracle - Discussion Forum] Incremental Scripts - Team Coding

Thread created by Stanis

Hi Stephen,

Thanks for your prompt reply. Appreciate the same.

I don’t understand what do you mean by “ check the script in to Git from Toad.” Can you please explain the same?

I tried running multiple ALTER statements in TOAD on a single table, but when I see the script they are combined together as a single CREATE statements. Please guide.

Regards,

Stanis

From: Stephen Beausang [mailto:bounce-StephenBeausang_734@toadworld.com]

Sent: Tuesday, July 14, 2015 7:55 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] [Toad for Oracle - Discussion Forum] Incremental Scripts - Team Coding

RE: [Toad for Oracle - Discussion Forum] Incremental Scripts - Team Coding

Thread created by Stephen Beausang

Hello,

Team Coding tracks changes to the actual DDL, so it does not track the associated alter statement when the Table was modified in the schema browser.

If you want to track changes to the script with the alter statements, I think the best approach would be to check the script in to Git from Toad. That way the alter statements are tracked in Git history.

Stephen

From: stanis.j.raja.-nd [mailto:bounce-stanisjraja-nd@toadworld.com]

Sent: Monday, July 13, 2015 5:55 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Incremental Scripts - Team Coding

Incremental Scripts - Team Coding

Thread created by stanis.j.raja.-nd

We are doing the source coding using Team Coding with GIT as source controller. Below is the sample script.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE));

Now I check out the table and going to edit the below table or using alter script to add a new column.

ALTER table tmp_test add new_col VARCHAR2(200));

I am doing the check out and see the code is changed as below.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE),

NEW_COL VARCHAR2(100 BYTE);

But, I would like to see the file as like below.

CREATE TABLE TMP_TEST

(TXT VARCHAR2(200 BYTE));

ALTER TABLE TMP_TEST ADD NEW_COL varchar2(100);

Is that possible using TOAD- Team coding?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.