I also had a strange encounter with this problem. After empting the logfile with the backup with no-log option, i was able to shrink the file in sql2000 with the...

>How about adding the column (at the end), renaming the table and constructing a view with the correct name AND the correct column order?

um, the reason for having the sequence...

🙁 and i needed a 'yes' answer in conjuction with a sql-script format... no enterprise manager. But thanks for the fast answer Kelly!

quote:

---

Unfortunately i have a fieldtype which is used very often and it's not correctly converted by MYdbPAL, so a lot of...

I was looking for a tool like this for some time. I'm primairely interested in the conversions between rdbms types, e.g. creating Oracle and informix ddl scripts from a SQL2000...

Thanx for the feedback, some ?? are !! now here 😉

Simon,

Having no seperate DB for olap, all reports are are run in the oltp environment.

Hence some big tables are well-indexed.

Cleared the 'contradiction' ?

hi, I'm not too worried about one table being to big, but on a database with more than 600 tables I would assume that a 2/1 ratio is rather big....

For example, i've been looking at DBdiff and dbscripter, products on http://www.dkgas.com/ . The tools can e.g. connect to an mssql and generate a script for oracle,...