Backing up tables that are not available at the dts run time - 11-17-2006 , 06:49 PM
As a part of dts conversion, I need to convert tables between MS SQL
databases. The sourse database, however, is not available at the time
of running the script, so I have back it up in some way. At the moment,
I am using dts to trasform those tables into text files, and load them
at the conversion time. The question I have with this approach is how
to specify the folder (path) with those text files inside the script.
Another question is if there are better approaches to store tables
somewhere so that I can obtain them at the run-time.
Thanks a lot
Re: Backing up tables that are not available at the dts run time - 11-20-2006 , 06:20 AM
I am not sure I get the flow of you process.
What script are you running?
Are you simply taking a database from ServerA and moving all the data etc
to ServerB? ServerA is not available though to you.
If you are then it would be infinitely more simple to do a BACKUP and RESTORE
T +44 7966 476 572
F +44 2071 008 479
Re: Backing up tables that are not available at the dts run time - 11-20-2006 , 11:48 AM
Thanks for your reply. I'm running dts scripts, most of tables I'm
converting from client's Sybase database to MS SQL, but a portion of
data is prepopulated before the conversion, and it is copied from
another SQL database. However, only a portion of source SQL database
should be copied (around 20 tables). I think BACKUP and RESTORE doesn't
allow to select which tables to save and load, does it?
"""Allan Mitchell ΠΙΣΑΜ(Α):
Re: Backing up tables that are not available at the dts run time - 11-20-2006 , 03:25 PM
In addition to the portion of tables that I would like to copy from
one SQL database to another (around 20 out of 140 in a database), I
also need to copy stored procedures and user-defined functions. Again,
sourse database is not available at the run-time.
Do you have any suggestions how to do that?