|
|
|
|
|
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Just about everyone has struggled with BCP at some time or another and always wondered why someone couldn't put a friendly GUI on it. You can accomplish an unload of data via DTS, but it is very cumbersome and limited to a single table at a time. The unload capability in DBArtisan allows you to BCP out several tables in a single operation to a destination that you specify. You also have complete control over how the data is delimited in the output files. The unload feature will then BCP out the data from each of the selected tables into a file corresponding to each table. It will also generate an error file and a format file that can be reused.
The data load wizard performs the opposite operation. As you can see from the figure below, you have the option to drop and recreate indexes in order to speed the loading process. The load wizard has one curious limitation. You can only specify the loading of one table at a time. Just like the unload option, you should be able to load multiple tables in a single operation. The load and unload features are something that I almost never use mainly due to the loading limitations. If I am going to move multiple tables via BCP, then I will normally create a script generator to build all of the BCP commands and execute those through a .bat file. This gives me the ability to do a search and replace on out and replace it with in to perform the reverse operation. If future releases of DBArtisan include the capability to load multiple tables in a single operation, then I might be inclined to use this feature.
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
