Sunday, February 19, 2012

How to copy object between SqlServer 2005

How to copy objects like View or Tables from on SqlServer 2005 to another?If you are talking about just hte DDL then script it out and run that script
on the other server. If you need data as well you can use the wizard in
SSIS.
--
Andrew J. Kelly SQL MVP
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:ey%23EdWOJGHA.1728@.TK2MSFTNGP14.phx.gbl...
> How to copy objects like View or Tables from on SqlServer 2005 to another?
>

No comments:

Post a Comment