Thursday, March 29, 2012

Alternate Methods of Exporting Data?

Hi all,
I have been fighting with the Copy SQL Server Objects task for a couple of
days. I have been trying to copy an entire database. I am trying to set
the Destination Database name dynamically ( I have used the Dynamic
Properties Task, Code, etc...)
Nothing works. I am continually prompted with an error that states that the
database is not in the databases collection. Of course not, it hasn't been
created yet...that's what the export is supposed to do and no matter of
Googling on the error has helped.
Anyone have any clues or suggestions for alternative ways to copy an entire
database AND provide the name dynamically for it?If this is a one time task, you could restore a backup copy of the database.
If you need to continually copy data you could look into both replication
and log shipping.|||Sorry, I didn't read your question carefully.
"Bianca Blount" <blountb@.noemail.com> wrote in message
news:u8OYoDWqDHA.976@.tk2msftngp13.phx.gbl...
> If this is a one time task, you could restore a backup copy of the
database.
> If you need to continually copy data you could look into both replication
> and log shipping.
>

No comments:

Post a Comment