Re: How to duplicate whole database from one machine to another machine in Windows 2000?

You may want to look at SQLPorter.

Its a real time saver for easy transfer of data between different sources from realsoftstudio.com

You dont have to be a database guru to do this. Hope this helps.

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0212292340.4ccb5cd2_at_posting.google.com>...
> > I should have mentioned it explicitly, but my technique was meant if
> > we want to hand over the task to a person not exposed to databases at
> > all, and we do not want to give him/her the SYS password also.
> > A few extra minutes spent copying for that person is sometimes better
> > than teaching him the intricacies.
>
> Hi Laxman,
>
> Handing over database migration tasks to someone who has not been
> exposed to databases at all is asking for a *BIG* trouble. Practicing
> Oracle on a home machine is much different then working with a
> production instance in the real world.
>
> If it is just a practice on a home machine...then no harm done, *BUT*
> if it is a real world scenario...then let the DBA handle these kind of
> tasks.
>
> Regards
> /Rauf Sarwar
Received on Sun Jan 05 2003 - 22:34:44 CST