The Source Model represents the data dictionary of the source MS SQL Server or Sybase database being migrated. The Source Model is displayed in the Source Model page in the Navigator Pane. It displays the following migratable components of the source database:
A login provides access to an MS SQL Server server or Sybase database. After being granted a login, the user can connect to the server and use the master database. A login usually requires a password, although there are exceptions. For example, upon initial installation, the 'sa' login has no password. Passwords are not required for MS SQL Server or Sybase logins, although it is recommended that they be used on all servers.
The database concept is central to almost all implementation and administration tasks in MS SQL Server and Sybase. During the database design phase of a project, you define the tables that are of interest to your organization. From a logical perspective, these related tables are collectively considered a single database. From a physical perspective, however, you can implement these tables in one or many MS SQL Server or Sybase databases. The MS SQL Server or Sybase database is important because it determines how data is stored physically, that is how data is mapped to physical devices. Physical space is assigned to a database during database creation, and additional space can be assigned to the database when the need arises.
Check constraints and rules provide a mechanism for enforcing domain constraints for columns or user-defined types.
Foreign keys are the columns or sets of columns included in the definition of a referential integrity constraint.
Indexes are optional structures associated with tables, which can be created to increase the performance of data retrieval.
Primary key values defined on a key (a column or set of columns) specify that each row in the table can be uniquely identified by the values in the keys.
Stored procedures are T-SQL blocks that MS SQL Server and Sybase store in a database and that can be called from any application.
Tables are the basic units of data storage in a database. The tables of a database hold all of the user-accessible data. Table data is stored in rows and columns.
A user (sometimes called a user name) is a name defined in a database that can access objects. Every user is linked to a login, and a login must have a user in order to access any objects such as tables or views in the database. A group contains a number of users, all of which have the same access rights as those granted to the group.
Sometimes, the default data types such as CHAR or BINARY do not suit the task at hand. When this happens, it is useful to be able to define a data type for use in the database. The data types that you define are known as user-defined types. User-defined types can determine default values and whether a column of a particular type can contain a NULL value.
Views are custom-tailored presentations of the data in one or more tables. Views can also be thought of as 'stored queries'.