Next week I have a database going into production
and now I need to set up a separate reporting database. This is no
except that I'll probably need to load data daily from production into
1) Can I trust the EM transfer manager to refresh
the data nightly in the reporting database correctly? Will it truncate
2) Must I be logged into the reporting database(destination) always or
should I incorporate that into a script? How?
3) Has any one experienced any problems using
transfer manager for this purpose?
4) What alternative should I use? bcp?