tiistai 2. lokakuuta 2007

ingresII 2.6 import export

db dump :: INGRES :: EXPORT

c:\temp\copydb -uUSERNAME vnode::database
c:\temp\sql -uUSERNAME vnode::database copyout.log

copies to c:\temp -folder lots of ingres-tables / files.

db dump :: INGRES :: IMPORT

c:\temp\copydb -uUSERNAME vnode::database
c:\temp\sql -uUSERNAME vnode::database copyin.log

copies c:\temp -folder ingres-tables / files (*) back to db.
remember to check file folders in Copy.in -file to make sure they're ok.

Ei kommentteja: