InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumSun, 05 Apr 2026 16:21:35 GMT20http://forum.strataframe.net/FindPost8116.aspxHi,</P><P>Is it possible to switch data source (SQL Server -&gt; Oracle / SQL Server -&gt; VFP)&nbsp;during runtime? How?</P><P>Thank youTue, 17 Apr 2007 10:14:32 GMTChanhttp://forum.strataframe.net/FindPost8175.aspxYes, you can swap data sources at runtime.&nbsp; You just need to call MicroFour.StrataFrame.DataBasics.DataSources.Remove("key") and then add a new data source to the collection with the same key, but of a different type (say, OracleDataSourceItem instead of VfpDataSourceItem).&nbsp; You'll just need to make sure that if a business object talks to both, that all of the data types match up.</P><P>You also might need to change the config on your business objects some: say if the Oracle needs the sequence name for primary key insertion.Tue, 17 Apr 2007 10:14:32 GMTStrataFrame Teamhttp://forum.strataframe.net/FindPost8170.aspxHi,</P><P>Any update?Tue, 17 Apr 2007 10:00:24 GMTChan