2012年3月19日星期一

bcp out

hi all
I want to bcp out whole database (tables, sps, fns, triggers)
is this possible and is it possible to make it a job
tia
Zarko
BCP out is used only to export the data. You can use EM to script the table,
procedure and trigger etc. Or if you want to automate, look for sp_OACreate,
sp_OAMethod in BOL. There are several code snippets available in the internet.
Thanks
Chinna.
"Zarko Jovanovic" wrote:

> hi all
> I want to bcp out whole database (tables, sps, fns, triggers)
> is this possible and is it possible to make it a job
> tia
> Zarko
>
>

没有评论:

发表评论