Hi to all.
I have a huge database (50 Gb) on SQL Server.
It takes more then 7 days for DTS to complete. I tried it both ways: Enterprise Manager and DtsRun command.
Is there any way to make it run faster, turn off som active default settings or something?
Any help appreciated!!!!
Thanx in advance,
Alex Frisman

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

50GB. I have heard from people who are stressing the drivers between Oracle
And SQL Server that they may be the fastest thing on the planet. I have see
the following recommended.

1. Export all tables to text file from SQL Server
2. Use SQL Loader from Oracle to put them into the Oracle system.

Was the copy you are doing a straight 1:1 or was there/is there any fancy
transformations going on.?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Alex" <afrisman (AT) retailexpert (DOT) com> wrote

1:1
just a LOT af data
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote