Microsoft has updated the Import/Export Wizard from SQL Server 2000 that was used to help DBA and developers automate the repetitive tasks of moving and copying data from one location to another.
Import/Export Wizard
The simplest and most commonly used wizard in DTS 2000 was the Import/Export Wizard. It allowed DBAs, developers, and novice users to move data from a source of any type to a target of any type, very quickly, with no code and very little hassle. It also provided a starting point for learning how to build and design DTS packages. The Import/Export Wizard makes an encore appearance in SQL Server 2005 with some improvements including:
· Improved flat-file control for both source and destination.
· Real-time preview of data.
· Optimization of processing when a large number of tables and views is desired.
· Creation of a new database directly from the wizard.
Figure 1 shows the opening screen of the wizard while the next several figures show subsequent steps in the wizard.
Figure 1
Along with the new features, the user interface has been updated and should save time for those who frequently use the wizard.
One of the more pleasant improvements includes the capability of creating the target database directly from the wizard. In DTS 2000, the user would have to stop the Import/Export process, return to Enterprise Manager, and create the database. Now, the administrator can create and configure a new database using the dialog box shown in Figure 2
No comments:
Post a Comment