Jeff Moden (4/6/2009)

---

Ummm.... you're gonna have to...

matlo_talli (4/6/2009)

---

Was wondering if SYS & SYSTEM too need to be migrated since both these schemas hold Oracle's internal tables/ data dictionary definitions etc. Is it imperative to migrate these...

xgcmcbain (4/6/2009)

---

Lowell (4/6/2009)

---

we don't know...it could be something in your code...maybe you have ignore_dups in your import?

if it's from an application,say from the client-server or web and a session times...

Was it an empty file? It needs to be. The UI that pops up basically creates an oledb connection string, and allows you test the connection. ...

Remember INNER JOIN is sometimes referred to as an equijoin. By design, it only returns results that satisfy both sides of the join. OUTER JOINs return all...

Got an idea. Move the access db some where else. Like c:

You in the users hierarchy, and that may be the problem.

Have you tried validating the oledb...

archan.arch (2/18/2009)

---

hello all..

i am just doing a study about data migration .i am interested to know about

migrating from oracle to sql.

what are pitfalls to look out for?

as in what...

You got me there. Did some quick checking and it was Sybase 10 that didn't support them until later (Syb 12). I was porting apps between Sybase/SQL Server...

J (2/13/2009)

---

FWIW,

I tend to avoid *= like the plague.

Although more verbose, "LEFT OUTER JOIN" is, in my opinion, much easier to follow when reading a long script.

I would say, if...

Ewan Hampson (2/17/2009)

---

The trouble with a...

Steve Jones - Editor (2/16/2009)

---

I'd like to be with you, but I'd also hate to see a big crash. Don't forget the guys with 6 or 7 zeros in their...

The real problem is not the bonuses. The real problem was (as it is in any bubble) that all the "adults" who are supposed to be in charge didn't...

You know who started threads on threads on religion!...

Clive Strong (2/12/2009)

---

I agree. It makes no sense and I strongly disagree that any money given by the governments should be used for bonus handouts. This should have...

It's not much more than a boondoggle. The stimulus really won't do that much, since most of it fails in getting the money out the door quickly, ...