create a table prior to bcping data
From: Susan (anonymous_at_discussions.microsoft.com)
Date: 04/08/04
- Next message: Peter Feakins: "RE: Data Copy"
- Previous message: Dinesh T.K: "Re: SQL.LOG too big"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 8 Apr 2004 14:47:23 -0700
I need to do the following;
1. bcp out data from our reporting server
2. Move bcp file to our archival server
Sounds pretty straight forward.. but of course there is
more....
Since we are using this data for archival purposes, we
just want to store the bcp file. My concern is that there
are many schema changes to the source table and I wanted
to make sure that I had the correct schema needed to bcp
that file back into a table, say three years from now.
Is there a option in bcp or bulk copy that would create
the schema for you? Or can this be done via DTS?
Thanks in advance
Susan
Any help would be greatly appreciated.
Thanks
Susan
- Next message: Peter Feakins: "RE: Data Copy"
- Previous message: Dinesh T.K: "Re: SQL.LOG too big"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
