TOAD - TFS schema name

tobias.anestrand_218 · August 23, 2011, 5:38am

Hi,

We have a problem with parallell development in diffrent database schemas.
When export to TFS all file name starts with schema_name.file_name.

Merging in TFS between diffrent schemas is not working becouse the file name i diffrent.

Is it possible to remove schema_name from the file name when export to TFS.

Stephen.Beausang_734 · August 23, 2011, 5:38am

Team Coding uses the Schema Name – Object Name naming to track revision
history, so removing the Schema name is not possible. Team Coding provides a
User Mapping (Mirroring ) capability that allows users to work on objects in
their own Sandbox schema , which might accomplish what you need to do. Are you
using this feature?

Stephen

Guest · August 31, 2011, 6:02am

Message from: susan1

You can use the same names we default to on a clean TFS 2010

Historical Messages

Author: James Salerno
Date: Wed Aug 31 04:02:12 PDT 2011
You can use the same names we default to on a clean TFS 2010
__

Author: Stephen.Beausang_734
Date: Tue Aug 23 03:38:12 PDT 2011
Team Coding uses the Schema Name – Object Name naming to track revision
history, so removing the Schema name is not possible. Team Coding provides a
User Mapping (Mirroring ) capability that allows users to work on objects in
their own Sandbox schema , which might accomplish what you need to do. Are you
using this feature? Stephen
__

Author: tobias.anestrand_218
Date: Tue Aug 23 03:38:12 PDT 2011

Hi,

We have a problem with parallell development in diffrent database schemas.
When export to TFS all file name starts with schema_name.file_name.

Merging in TFS between diffrent schemas is not working becouse the file name i
diffrent.

Is it possible to remove schema_name from the file name when export to TFS.

__

susan1 · August 31, 2011, 6:02am

You can use the same names we default to on a clean TFS 2010

Guest · September 29, 2011, 1:45am

Message from: tobias.anestrand_218

I don’t think this will work.

When we have 2 development branches and want to merge all database changes
between branches.

I don’t understand why SQL Navigator or TOAD specifies all files with schema
name. This stops out development process becouse we cannot merge database code.

Historical Messages

Author: tobias.anestrand_218
Date: Wed Sep 28 23:45:24 PDT 2011
I don’t think this will work.

When we have 2 development branches and want to merge all database changes
between branches.

I don’t understand why SQL Navigator or TOAD specifies all files with schema
name. This stops out development process becouse we cannot merge database code.
__

Author: James Salerno
Date: Wed Aug 31 04:02:12 PDT 2011
You can use the same names we default to on a clean TFS 2010
__

Author: James Salerno
Date: Wed Aug 31 04:02:12 PDT 2011
Message from: susan1 You can use the same names we default to on a clean TFS
2010 _______________________________________ Historical Messages Author: James
Salerno Date: Wed Aug 31 04:02:12 PDT 2011 You can use the same names we default
to on a clean TFS 2010 __ Author: Stephen.Beausang_734 Date: Tue Aug 23 03:38:12
PDT 2011 Team Coding uses the Schema Name – Object Name naming to track
revision history, so removing the Schema name is not possible. Team Coding
provides a User Mapping (Mirroring ) capability that allows users to work on
objects in their own Sandbox schema , which might accomplish what you need to
do. Are you using this feature? Stephen __ Author: tobias.anestrand_218 Date:
Tue Aug 23 03:38:12 PDT 2011 Hi, We have a problem with parallell development in
diffrent database schemas. When export to TFS all file name starts with
schema_name.file_name. Merging in TFS between diffrent schemas is not working
becouse the file name i diffrent. Is it possible to remove schema_name from the
file name when export to TFS. __ _______________________________________
__

Author: Stephen.Beausang_734
Date: Tue Aug 23 03:38:12 PDT 2011
Team Coding uses the Schema Name – Object Name naming to track revision
history, so removing the Schema name is not possible. Team Coding provides a
User Mapping (Mirroring ) capability that allows users to work on objects in
their own Sandbox schema , which might accomplish what you need to do. Are you
using this feature? Stephen
__

Author: tobias.anestrand_218
Date: Tue Aug 23 03:38:12 PDT 2011

Hi,

We have a problem with parallell development in diffrent database schemas.
When export to TFS all file name starts with schema_name.file_name.

Merging in TFS between diffrent schemas is not working becouse the file name i
diffrent.

Is it possible to remove schema_name from the file name when export to TFS.

__

tobias.anestrand_218 · September 29, 2011, 1:45am

I don’t think this will work.

When we have 2 development branches and want to merge all database changes between branches.

I don’t understand why SQL Navigator or TOAD specifies all files with schema name. This stops out development process becouse we cannot merge database code.

Guest · October 31, 2011, 8:35am

Message from: tobias.anestrand_218

No we are not using User Mapping (Mirroring ). But I don’t think that will
sovle my problem.

I need to Merge database code from two or more branches, database code is in
diffrent schemas.

Historical Messages

Author: tobias.anestrand_218
Date: Mon Oct 31 06:35:06 PDT 2011
No we are not using User Mapping (Mirroring ). But I don’t think that will
sovle my problem.

I need to Merge database code from two or more branches, database code is in
diffrent schemas.
__

Author: tobias.anestrand_218
Date: Wed Sep 28 23:45:24 PDT 2011
I don’t think this will work.

When we have 2 development branches and want to merge all database changes
between branches.

I don’t understand why SQL Navigator or TOAD specifies all files with schema
name. This stops out development process becouse we cannot merge database code.
__

Author: tobias.anestrand_218
Date: Wed Sep 28 23:45:24 PDT 2011
Message from: tobias.anestrand_218 I don’t think this will work. When we
have 2 development branches and want to merge all database changes between
branches. I don’t understand why SQL Navigator or TOAD specifies all files
with schema name. This stops out development process becouse we cannot merge
database code. _______________________________________ Historical Messages
Author: tobias.anestrand_218 Date: Wed Sep 28 23:45:24 PDT 2011 I don’t
think this will work. When we have 2 development branches and want to merge all
database changes between branches. I don’t understand why SQL Navigator or
TOAD specifies all files with schema name. This stops out development process
becouse we cannot merge database code. __ Author: James Salerno Date: Wed Aug 31
04:02:12 PDT 2011 You can use the same names we default to on a clean TFS 2010
__ Author: James Salerno Date: Wed Aug 31 04:02:12 PDT 2011 Message from: susan1
You can use the same names we default to on a clean TFS 2010
_______________________________________ Historical Messages Author: James
Salerno Date: Wed Aug 31 04:02:12 PDT 2011 You can use the same names we default
to on a clean TFS 2010 __ Author: Stephen.Beausang_734 Date: Tue Aug 23 03:38:12
PDT 2011 Team Coding uses the Schema Name – Object Name naming to track
revision history, so removing the Schema name is not possible. Team Coding
provides a User Mapping (Mirroring ) capability that allows users to work on
objects in their own Sandbox schema , which might accomplish what you need to
do. Are you using this feature? Stephen __ Author: tobias.anestrand_218 Date:
Tue Aug 23 03:38:12 PDT 2011 Hi, We have a problem with parallell development in
diffrent database schemas. When export to TFS all file name starts with
schema_name.file_name. Merging in TFS between diffrent schemas is not working
becouse the file name i diffrent. Is it possible to remove schema_name from the
file name when export to TFS. __ _______________________________________ __
Author: Stephen.Beausang_734 Date: Tue Aug 23 03:38:12 PDT 2011 Team Coding uses
the Schema Name – Object Name naming to track revision history, so
removing the Schema name is not possible. Team Coding provides a User Mapping
(Mirroring ) capability that allows users to work on objects in their own
Sandbox schema , which might accomplish what you need to do. Are you using this
feature? Stephen __ Author: tobias.anestrand_218 Date: Tue Aug 23 03:38:12 PDT
2011 Hi, We have a problem with parallell development in diffrent database
schemas. When export to TFS all file name starts with schema_name.file_name.
Merging in TFS between diffrent schemas is not working becouse the file name i
diffrent. Is it possible to remove schema_name from the file name when export to
TFS. __ _______________________________________
__

Author: James Salerno
Date: Wed Aug 31 04:02:12 PDT 2011
You can use the same names we default to on a clean TFS 2010
__

Author: James Salerno
Date: Wed Aug 31 04:02:12 PDT 2011
Message from: susan1 You can use the same names we default to on a clean TFS
2010 _______________________________________ Historical Messages Author: James
Salerno Date: Wed Aug 31 04:02:12 PDT 2011 You can use the same names we default
to on a clean TFS 2010 __ Author: Stephen.Beausang_734 Date: Tue Aug 23 03:38:12
PDT 2011 Team Coding uses the Schema Name – Object Name naming to track
revision history, so removing the Schema name is not possible. Team Coding
provides a User Mapping (Mirroring ) capability that allows users to work on
objects in their own Sandbox schema , which might accomplish what you need to
do. Are you using this feature? Stephen __ Author: tobias.anestrand_218 Date:
Tue Aug 23 03:38:12 PDT 2011 Hi, We have a problem with parallell development in
diffrent database schemas. When export to TFS all file name starts with
schema_name.file_name. Merging in TFS between diffrent schemas is not working
becouse the file name i diffrent. Is it possible to remove schema_name from the
file name when export to TFS. __ _______________________________________
__

Author: Stephen.Beausang_734
Date: Tue Aug 23 03:38:12 PDT 2011
Team Coding uses the Schema Name – Object Name naming to track revision
history, so removing the Schema name is not possible. Team Coding provides a
User Mapping (Mirroring ) capability that allows users to work on objects in
their own Sandbox schema , which might accomplish what you need to do. Are you
using this feature? Stephen
__

Author: tobias.anestrand_218
Date: Tue Aug 23 03:38:12 PDT 2011

Hi,

We have a problem with parallell development in diffrent database schemas.
When export to TFS all file name starts with schema_name.file_name.

Merging in TFS between diffrent schemas is not working becouse the file name i
diffrent.

Is it possible to remove schema_name from the file name when export to TFS.

__

Stephen.Beausang_734 · October 31, 2011, 8:35am

Hello Tobias,

The current version of Toad does not support TFS branching and merging .

Without a more detailed understanding of your development scenario, I can only
give a very general answer. You probably need to perform an initial merge using
TFS in Visual Studio. Compile all of your objects in Oracle and get a base line
to use TFS. Team Coding can then create and initial source control version in
TFS. You could then use Mirroring (User mapping) to enable users to work in
their own schemas, and tracks changes made by individual users.

Stephen

tobias.anestrand_218 · October 31, 2011, 8:35am

No we are not using User Mapping (Mirroring ). But I don’t think that will sovle my problem.

I need to Merge database code from two or more branches, database code is in diffrent schemas.

Guest · October 31, 2011, 8:36am

Message from: tobias.anestrand_218

Hi,

I don’t understand what you mean ?

Could you please describe this.

Historical Messages

Author: tobias.anestrand_218
Date: Mon Oct 31 06:36:30 PDT 2011
Hi,

I don’t understand what you mean ?

Could you please describe this.
__

Author: tobias.anestrand_218
Date: Mon Oct 31 06:35:06 PDT 2011
No we are not using User Mapping (Mirroring ). But I don’t think that will
sovle my problem.

I need to Merge database code from two or more branches, database code is in
diffrent schemas.
__

Author: tobias.anestrand_218
Date: Mon Oct 31 06:35:06 PDT 2011
Message from: tobias.anestrand_218 No we are not using User Mapping (Mirroring
). But I don’t think that will sovle my problem. I need to Merge database
code from two or more branches, database code is in diffrent schemas.
_______________________________________ Historical Messages Author:
tobias.anestrand_218 Date: Mon Oct 31 06:35:06 PDT 2011 No we are not using User
Mapping (Mirroring ). But I don’t think that will sovle my problem. I need
to Merge database code from two or more branches, database code is in diffrent
schemas. __ Author: tobias.anestrand_218 Date: Wed Sep 28 23:45:24 PDT 2011 I
don’t think this will work. When we have 2 development branches and want to
merge all database changes between branches. I don’t understand why SQL
Navigator or TOAD specifies all files with schema name. This stops out
development process becouse we cannot merge database code. __ Author:
tobias.anestrand_218 Date: Wed Sep 28 23:45:24 PDT 2011 Message from:
tobias.anestrand_218 I don’t think this will work. When we have 2
development branches and want to merge all database changes between branches. I
don’t understand why SQL Navigator or TOAD specifies all files with schema
name. This stops out development process becouse we cannot merge database code.
_______________________________________ Historical Messages Author:
tobias.anestrand_218 Date: Wed Sep 28 23:45:24 PDT 2011 I don’t think this
will work. When we have 2 development branches and want to merge all database
changes between branches. I don’t understand why SQL Navigator or TOAD
specifies all files with schema name. This stops out development process becouse
we cannot merge database code. __ Author: James Salerno Date: Wed Aug 31
04:02:12 PDT 2011 You can use the same names we default to on a clean TFS 2010
__ Author: James Salerno Date: Wed Aug 31 04:02:12 PDT 2011 Message from: susan1
You can use the same names we default to on a clean TFS 2010
_______________________________________ Historical Messages Author: James
Salerno Date: Wed Aug 31 04:02:12 PDT 2011 You can use the same names we default
to on a clean TFS 2010 __ Author: Stephen.Beausang_734 Date: Tue Aug 23 03:38:12
PDT 2011 Team Coding uses the Schema Name – Object Name naming to track
revision history, so removing the Schema name is not possible. Team Coding
provides a User Mapping (Mirroring ) capability that allows users to work on
objects in their own Sandbox schema , which might accomplish what you need to
do. Are you using this feature? Stephen __ Author: tobias.anestrand_218 Date:
Tue Aug 23 03:38:12 PDT 2011 Hi, We have a problem with parallell development in
diffrent database schemas. When export to TFS all file name starts with
schema_name.file_name. Merging in TFS between diffrent schemas is not working
becouse the file name i diffrent. Is it possible to remove schema_name from the
file name when export to TFS. __ _______________________________________ __
Author: Stephen.Beausang_734 Date: Tue Aug 23 03:38:12 PDT 2011 Team Coding uses
the Schema Name – Object Name naming to track revision history, so
removing the Schema name is not possible. Team Coding provides a User Mapping
(Mirroring ) capability that allows users to work on objects in their own
Sandbox schema , which might accomplish what you need to do. Are you using this
feature? Stephen __ Author: tobias.anestrand_218 Date: Tue Aug 23 03:38:12 PDT
2011 Hi, We have a problem with parallell development in diffrent database
schemas. When export to TFS all file name starts with schema_name.file_name.
Merging in TFS between diffrent schemas is not working becouse the file name i
diffrent. Is it possible to remove schema_name from the file name when export to
TFS. __ _______________________________________ __ Author: James Salerno Date:
Wed Aug 31 04:02:12 PDT 2011 You can use the same names we default to on a clean
TFS 2010 __ Author: James Salerno Date: Wed Aug 31 04:02:12 PDT 2011 Message
from: susan1 You can use the same names we default to on a clean TFS 2010
_______________________________________ Historical Messages Author: James
Salerno Date: Wed Aug 31 04:02:12 PDT 2011 You can use the same names we default
to on a clean TFS 2010 __ Author: Stephen.Beausang_734 Date: Tue Aug 23 03:38:12
PDT 2011 Team Coding uses the Schema Name – Object Name naming to track
revision history, so removing the Schema name is not possible. Team Coding
provides a User Mapping (Mirroring ) capability that allows users to work on
objects in their own Sandbox schema , which might accomplish what you need to
do. Are you using this feature? Stephen __ Author: tobias.anestrand_218 Date:
Tue Aug 23 03:38:12 PDT 2011 Hi, We have a problem with parallell development in
diffrent database schemas. When export to TFS all file name starts with
schema_name.file_name. Merging in TFS between diffrent schemas is not working
becouse the file name i diffrent. Is it possible to remove schema_name from the
file name when export to TFS. __ _______________________________________ __
Author: Stephen.Beausang_734 Date: Tue Aug 23 03:38:12 PDT 2011 Team Coding uses
the Schema Name – Object Name naming to track revision history, so
removing the Schema name is not possible. Team Coding provides a User Mapping
(Mirroring ) capability that allows users to work on objects in their own
Sandbox schema , which might accomplish what you need to do. Are you using this
feature? Stephen __ Author: tobias.anestrand_218 Date: Tue Aug 23 03:38:12 PDT
2011 Hi, We have a problem with parallell development in diffrent database
schemas. When export to TFS all file name starts with schema_name.file_name.
Merging in TFS between diffrent schemas is not working becouse the file name i
diffrent. Is it possible to remove schema_name from the file name when export to
TFS. __ _______________________________________
__