Tuesday, March 27, 2012

Export Database Structure (No Data)

Is there a transact SQL statement that can be used to only export the databa
se structure? I'm looking to schedule a nightly job to export the structure
.DTS has a task that will do just that.
Cheers,
Greg Jackson
PDX, Oregon|||And you can create and schedule a job that uses dtsrun.exe to run the =
DTS package whenever you want.
--=20
Keith
"Jaxon" <GregoryAJackson@.hotmail.com> wrote in message =
news:uVBZPOjUEHA.3540@.TK2MSFTNGP11.phx.gbl...
> DTS has a task that will do just that.
>=20
>=20
> Cheers,
>=20
> Greg Jackson
> PDX, Oregon
>=20
>

No comments:

Post a Comment