BizTalk Server Applications Integration - replacing XSD defintion other than using BTS Mapper tool

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > March 2005 > replacing XSD defintion other than using BTS Mapper tool





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author replacing XSD defintion other than using BTS Mapper tool
Jun

2005-03-04, 2:47 am

I have a technical question that I would like you or your
contacts could provide some answers.

We have ten interfaces built to connect to Oracle
Database. Due to the change of Oracle system, the schema
and table names are changed but the actual table
definitions have not been changed. To replace the
definition schema with the new one, it means all the
mapping rule will be lost in the mapping file (btm file).
Since all the source file can be edit in notepad, I
wonder if we could perform a globabl replace of the old
names with the new ones and still compile the code
without any error.

Any help will be appreciated.

Regards,

Jun
Tan Nguyen

2005-03-04, 5:49 pm

My guess is it should work by updating the .btm file but I did not try it.
Note that this is not a supported scenario from BizTalk Server. Let me
know how it goes if you decide to try it.

Another suggestion is:
1) Do a validate map.
2) Get the generated XSLT and update the old names.
3) Set the "Custom XSLT Path" property of the map to use the modified
generated XSLT.

Regards,
Tan Nguyen
Microsoft BizTalk Server

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Content-Class: urn:content-classes:message
| From: "Jun" <anonymous@discussions.microsoft.com>
| Sender: "Jun" <anonymous@discussions.microsoft.com>
| Subject: replacing XSD defintion other than using BTS Mapper tool
| Date: Thu, 3 Mar 2005 21:57:42 -0800
| Lines: 19
| Message-ID: <403401c5207f$143748b0$a601280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcUgfxQ35O0BvMtZRbCG45qKWmwF8g==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4942.400
| Newsgroups: microsoft.public.biztalk.appintegration
| Path: TK2MSFTNGXA02.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.biztalk.appintegration:7733
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.biztalk.appintegration
|
| I have a technical question that I would like you or your
| contacts could provide some answers.
|
| We have ten interfaces built to connect to Oracle
| Database. Due to the change of Oracle system, the schema
| and table names are changed but the actual table
| definitions have not been changed. To replace the
| definition schema with the new one, it means all the
| mapping rule will be lost in the mapping file (btm file).
| Since all the source file can be edit in notepad, I
| wonder if we could perform a globabl replace of the old
| names with the new ones and still compile the code
| without any error.
|
| Any help will be appreciated.
|
| Regards,
|
| Jun
|

Jun

2005-03-05, 8:46 pm

Thanks, Tan.

I will let you know once it is done.

Regards,

Jun
>-----Original Message-----
>My guess is it should work by updating the .btm file but

I did not try it.
>Note that this is not a supported scenario from BizTalk

Server. Let me
>know how it goes if you decide to try it.
>
>Another suggestion is:
>1) Do a validate map.
>2) Get the generated XSLT and update the old names.
>3) Set the "Custom XSLT Path" property of the map to use

the modified
>generated XSLT.
>
>Regards,
>Tan Nguyen
>Microsoft BizTalk Server
>
>This posting is provided "AS IS" with no warranties, and

confers no rights.
>
>--------------------
>| Content-Class: urn:content-classes:message
>| From: "Jun" <anonymous@discussions.microsoft.com>
>| Sender: "Jun" <anonymous@discussions.microsoft.com>
>| Subject: replacing XSD defintion other than using BTS

Mapper tool
>| Date: Thu, 3 Mar 2005 21:57:42 -0800
>| Lines: 19
>| Message-ID: <403401c5207f$143748b0$a601280a@phx.gbl>
>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| Thread-Index: AcUgfxQ35O0BvMtZRbCG45qKWmwF8g==
>| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4942.400
>| Newsgroups: microsoft.public.biztalk.appintegration
>| Path: TK2MSFTNGXA02.phx.gbl
>| Xref: TK2MSFTNGXA02.phx.gbl

microsoft.public.biztalk.appintegration:7733
>| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
>| X-Tomcat-NG: microsoft.public.biztalk.appintegration
>|
>| I have a technical question that I would like you or

your
>| contacts could provide some answers.
>|
>| We have ten interfaces built to connect to Oracle
>| Database. Due to the change of Oracle system, the

schema
>| and table names are changed but the actual table
>| definitions have not been changed. To replace the
>| definition schema with the new one, it means all the
>| mapping rule will be lost in the mapping file (btm

file).
>| Since all the source file can be edit in notepad, I
>| wonder if we could perform a globabl replace of the

old
>| names with the new ones and still compile the code
>| without any error.
>|
>| Any help will be appreciated.
>|
>| Regards,
>|
>| Jun
>|
>
>.
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com