you could setup a dts package, that does this, and then it would be as easy as a doubleclick to execute the package.
tw On Thu, 28 Oct 2004 14:54:05 -0400, Asim Manzur <[EMAIL PROTECTED]> wrote: > well I mean to say that. When I do changes on DEV and get approved by the client. > Then I have to move back all the table to the LIVE. > > So its pain everytime to login on the server, launch the enterprise manager and then > remove the old tables and wait for import/export and copy over all the data. > > So, I was thinking that DEV should match with live and update the difference or any > other better idea? > > > >EXACTLY and RANDOMLY? > > > >hmmm.. > > > >i would say you could do a backup and restore DTS package, maybe? > > > >tw > > > > > >On Thu, 28 Oct 2004 14:32:14 -0400, Asim Manzur <[EMAIL PROTECTED]> wrote: > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182871 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
