SQL (6.5) Database \ Object Transfer Tips

January 8, 2000

1. To avoid permission problems:

A. Register to the Source and Destination Servers as ‘SA’.

B. Make sure the Destination Database exists and is large enough to contain all the objects and data that you will transfer.

C. On the Destination Database give Database Create Permissions to the database user who is the owner of the objects that will be created. To do this right click on the database, select Edit, and select Permissions.

2. If your objects, for example, Stored Procedures contain a comment box (for documentation purposes) each commented line must contain a /* at the beginning of each row and a */ at the end of each row.  A comment box with the /* only on the first row and the */ only on the last row will return a syntax error on the ‘*’.