October 16, 2008 at 9:01 am
Is anyone doing this? Our primary appliation runs on Oracle and our customer wants a 'up to the minute' copy of it in SQL server.
I have run a test and was able to get the SQL Server wizard to start replicating one table fairly easily. When I tried to do the entire database it seemed to get lost. I am sure it is because of my inexperience with this tool but am curious if anyone else has been able to get a 355 table Oracle database to replicate to SQL Server.
The database is about 400Gb in size.
Thanks
Larry
October 16, 2008 at 1:01 pm
Yes. In fact I've just finished tearing my hear out over exactly that scenario (though I had 315 tables to do).
You can't do it with SQL 2000 though. It requires 2005 or 2008
I had problems if I put more than 255 tables in a single publication. Odd, seeing as the stated maximum is 32767. I haven't yet tried it out in a test environment to see if it's a reproducible problem, or it it was a problem specific to the environment I was working in.
Try splitting the tables into 2 publications of around 175 tables each, and see if that works
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply