Updating my Database **SOLVED**

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Updating my Database SOLVED

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Updating my Database **SOLVED**

Page: [1]

Message

<< Older Topic Newer Topic >>

Updating my Database **SOLVED** - 6 October 2004

sgtpeppa

Posts: 6
Score: 0
Joined: 5 October 2004
Status: offline

Hey all,

what happens if I update my Database / Stored Procedure and their Interface changes? For example I add another out Parameter to my Storted Procedure, or I just add another column to my Table. Do I need to redo all the Importing, is there a way to Update the Schemas,.......

Thanks in advance,

Stephan

< Message edited by sgtpeppa -- 7 October 2004 >

Post #: 1

RE: Updating my Database - 6 October 2004

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

You have 2 options for this. If the change is huge you will have to regenerate the Schema. Or you could simply add the fields within the Schema. The Schema Editor Extensions provided for the Adapter will allow you to enter all of the necesarry values.

The Adapter Framework passes no information on the existing schema to the Adapter UI, and we can thus not interogate the Schema to modify it. Hopefully this will be changed in a future version of the Adapter Framework.

Cheers

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to sgtpeppa)

Post #: 2