How long is a piece of string?
You can of course use DTS to migrate the data. DTS per se is quick but the
driver + other factors will affect how quick the work can be done (Network,
load, CPU, Memory)
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Avi" <rememberoti (AT) yahoo (DOT) com> wrote
Quote:
Hi Experts,
One of my customers wants a copy of the database to be on Unix so he can
run
his analysis tools.
What is the fastest way to migrate data between SQL Server 2000/ Windows
2k --> Sybase 12.5.1 on Unix. I estimate my data to be around 10GB. What
can I expect in term of migration time. Both machines are relatively fast
with 4 CPUs
Thanks for your help,
Avi |