Compiling in SQL Server

After converting the Sybase ASE database objects into equivalent SQL Server objects, you can compile the same in a SQL Server database running in the network. You can connect to a remote SQL Server using JDBC connectivity or use the ISQL option and compile the migrated files. You need to configure the target database connection settings to connect and compile the migrated objects. The steps involved in compiling the migrated objects is detailed below :

• Choosing the Required Objects for Compilation
• Connecting to the Target Database
  • Connecting to SQL Server using JDBC option
  • Connecting to SQL Server using the ISQL
• Compiling the Migrated Files
  

• Choosing the Required Objects for Compilation

Once the migration is successful, all the migrated objects/files are loaded in the right hand side tree of the main window. You can select the required objects/files to be compiled from the tree by clicking the corresponding file entries, multiple selection can be made by Shift+Click or Ctrl+Click. After selecting the required objects click on the Compile button in the GUI to compile the objects in SQL Server database. To compile all the objects/files loaded in the right hand side tree, choose the MSSQL(Root node) of the tree and invoke the Compile button

• Connecting to the Target Database

  When you compile for the first time (since the startup of the tool) in the target database, Destination DB Settings dialog will be prompted to specify the connection parameters required to connect to the database. You can use either the JDBC connectivity or the ISQL option to connect to the database. Both the approaches are detailed below

• Connecting to SQL Server using JDBC option

To connect to a SQL Server database in your network using JDBC, you have to specify the following parameters

Driver Name: This is the name of the Java Driver class (with fully qualified Package structure) that will be used to establish connection with the database. By default, the class named net.sourceforge.jtds.jdbc.Driver is used to connect to the database. This is the default JDBC driver provided along with the SwisSQL Sybase to SQL Server Edition. This class file with other related resources are bundled in Java Archive (JAR) files named jtds-1.0.3.jar.

Driver Jar/ ZIP:  The default jtds-1.0.3.jar driver is bundled with the SwisSQL Sybase to SQL Server Edition by default and it can be found under the <Product Home>/lib directory.

Note: You can also connect to SQL Server using any other SQL Server JDBC driver in which case, the required Jar files are to be loaded.

URL : Once you have specified the required JAR files, You have to specify the Host Name and the Database Name to connect to the required SQL Server database. Host Name refers to the machine name in which SQL Server database is running. Database Name refers to the target SQL Server database, where the migrated files will be compiled. Once the connection is established with the host, the migrated objects are compiled in the specified Database Name.

URL : jdbc:jtds:sqlserver://<Host_Name>:1433;DatabaseName=<Database_Name>

Eg: For the given Host Name and Database Name, the URL string will be as given below.

HostName - swissql-demo

Database Name - Northwind

jdbc:microsoft:sqlserver://DBTestPC:1433;DatabaseName= Northwind

• Connecting SQL Server using the ISQL

To connect to SQL Server using ISQL, select ISQL radio-button option. Now use the button next to the isql File field to browse through the local file system to specify the path of the ISQL executable that is bundled along with the SQL Server database. You need to specify the database name that you need to connect to in the DBName field. The database name has to be specified in the following format : <server_name:database_name> where server_name corresponds to the host where SQL Server is running and database_name corresponds to the database in which the objects are to be compiled. This should be followed by the user name and password information to connect to the database.

ISQL is a command line utility that help you to connect to SQL Server, by default it will be installed in C:\Program Files\Microsoft SQL Server\80\Tools\Binn. For more information on using ISQL command line utility refer

• http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_intro_3nsj.asp
  
• http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_isql_8r39.asp

• Specifying Login Information

You need to specify the user name and password to connect to the specified SQL Server database.

• User Name : Specify the User name for the target SQL Server database
• Password : Specify the password for the target SQL Server database

Click OK to save all Destination Settings. You are ready to Compile the migrated SQL Server objects.

This connection configuration has to be performed only for the first compilation being performed since the tool start up. For further compilation, the tool remembers the DB connection details. Users have the option of changing the configuration to any other database by changing the configuration details. You can change the DB Connection Settings by selecting Configure -> Compilation JDBC menu item to reconfigure the required connection settings to connect to other SQL Server database in your network.

• Compiling the migrated files

Once the connection to SQL Server is established, the tool compiles the selected objects in the target database. After successful completion of the compilation process, a result window pops up with details on the status of compilation of various objects/files and errors if any. The compilation errors are shown in the bottom half of the result window. You can save the compilation report in a flat file using the Save option for future reference from the result window.