SQL (6.5) Database Object Transfer Tips

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 ‘*’.

Previous article
Next article

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles