Aden, You can move the CFApplicationdb, CFAobjects, CFAVersiondb plus all your application db to oracle. Just use your existing SID in Oracle, set an ODBC datasource for it, set a ODBC datasource of your SQL server, and then use the impot and export utility or you can use the webtop (database migration) to do this.
I did mine. "Aden, David" wrote: > we have been doing some development in a SQLServer environment and are > about to move the backend into Oracle. > > Perhaps some data already exists on the pitfalls of this, but I'd like > to just use existing import tools to move the entire CODB from SQLServer > into Oracle. > > Is this possible or are there differences between the tables spectra > installs to Oracle as compared to what it installs to SQLServer? > > Anyone have experience with this or have pointers to articles that might > cover it? > > thanks! > > david > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
