|
|
|
|
|
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 I am sure everyone has used the script generator in Enterprise Manager. It actually does a really good job. But, it gets very tedious if you need to generate scripts for all objects in 15 databases on the same server. DBArtisan 5.03 takes script generation to that next step by allowing you to extract scripts from multiple databases at the same time. You have full control over the objects that are scripted, how they are scripted, and where the output files are placed.
The Schema Migration utility is something that I use extensively. This functions similar to Transfer Manager on steroids. Transfer Manager works between 6.5 servers. It can't be used between 6.5 and 7.0 servers. There are times when you don't want to use the upgrade wizard to go from 6.5 to 7.0, but instead want to create a completely new environment. No problem you say. I have DTS! So you happily struggle through the package designer and kick off the package to migrate the data. The problem is it doesn't generate any scripts or any of the rest of the objects. You have that covered by generating scripts in Enterprise Manager which you run against 7.0. All of the objects and permissions are there and the data is happily transferring when you slam head first into a wall inside DTS. The problem you have encountered is that some of your 6.5 tables have text or image datatypes. DTS requires the use of an ODBC driver and it can't handle text or image datatypes unless they are the last column in a table. You now have a significant problem and have to resort to using BCP to move the data by hand. You could go through all of that pain, or you could use DBArtisan 5.03. In a single operation it will extract the schema, create on the other server, and migrate all of the data. It also has one other feature that no other vendor has accomplished. It can migrate schema and data between versions of SQL Server. Not bad, but something I would expect. Ever tried to migrate a schema from Oracle to Sybase? How about Sybase to MS SQL Server, Oracle to MS SQL Server, Oracle to DB2, etc.? If you have had to do that, you know you are looking at a significant amount of time and effort. DBArtisan 5.03 is the first tool that can not only migrate schema and data between different version of a DBMS, but can also migrate schema and data of common objects between different DBMSes! The keyword is common. A schema in Oracle has no direct correlation in MS SQL Server and a login/role has no correlation in Oracle and so you can to perform that migration.
The figure below gives you an idea of the kind of fine tuned control you can exert over a migration. DTS comes close with an object transfer, but it still lacks the flexibility and can only function between 7.0 servers.
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.
