Create a proxy database using the Sybase Control Center Administration Console.
Prerequisites
Consider these database attributes:
- Size :
- sp_estspace helps you estimate table and index space requirements based on the definition of a specific table. See the Adaptive Server Reference Manual .
- Space for planned views, stored procedures, defaults, rules, and triggers
- Size of the transaction log
- Space for anticipated expansion
- Database device location, and whether there is enough space on that device.
- Transaction log location – Sybase recommends that you store the transaction log on a different device than the data.
- In the left pane of the Administration Console, expand .
- Click Proxy Databases.
- Click the drop-down arrow and select New.
You see the Add Proxy Database wizard.
- On the Introduction screen, select the server in which to create a database.
- On the Database screen, enter the name of the database you want to create.
- (Optional) On the Devices screen, enter the size of the new database. If you do not enter a size, the default size allocated is 3MB. You can specify separately the amount of space to allocate to the log and data segments.
- (Optional) On the Default Location screen, enter the name of the remote location where you want to store your proxy database. Select For Proxy Update to get metadata automatically from the remote location while creating proxy tables.
- (Optional) Click Summary to view your selected options.