 | |
Nightly Data Structure Refresh
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Nightly Data Structure Refresh -
08-05-2005
, 04:25 AM
|
We are starting with the Access database and I am not sure how a backup and restore would work with this. The Transfer Objects Task only works from one SQL Server to another, correct? "Darren Green" wrote: Backup and restore? Transfer Objects Task ? -- Darren Green http://www.sqldts.com http://www.sqlis.com "Steve R" <SteveR (AT) discussions (DOT) microsoft.com> wrote in message news:116327AF-3861-4406-845A-020093FAF674 (AT) microsoft (DOT) com... We are receiving a reporting database from a vendor nightly. We want to upload this data and structures to SQL Server nightly. We want it to be as flexible as possible - if the vendor adds/deletes a table/column, the import job should handle that. Apparently, the Import/Export wizard in SQL Server and the Upsizing Wizard in Access both require you to specify what tables to import. This would prohibit the job from creating new tables/columns on the fly. Any suggestions for a solution to this problem? Thanks for the help... |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.