Solved

Moving database from one syabse server to another.

Posted on 2004-09-14
2
425 Views
Last Modified: 2008-02-01
Hi,

    I am new to syabase. I am using ASE 12.5 and Windows Xp. We have a Sybase server which is running in remote. Whenever we need data from datadase, we connect to the remote server and get the data. Due to network traffic and other performance issues, we decided to keep the database in our local server so that the clients can access with less issues.

 Now how can i move database from remote server to local server? Is there any s/w or doccument for doing it?

  Is it possible to run morethan one instance of a server in same machine?

Thanks.

0
Comment
Question by:hemanexp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
ChrisKing earned 100 total points
ID: 12061545
Firstly:
> Is it possible to run morethan one instance of a server in same machine?
yes , just add/build another server with a new port number

> Now how can i move database from remote server to local server? Is there any s/w or doccument for doing it?
are you talking about a 1 off move, or a continuous replication of data from the primary server to the local server ?

if one off, then what platform is the current server running on.

if continuous, then Sybase RepServer is a great product, but expensive
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The conference as a whole was very interesting, although if one has to make a choice between this one and some others, you may want to check out the others.  This conference is aimed mainly at government agencies.  So it addresses the various compli…
In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question