I want to upgrade the database to sql 2008 if possible.
Are there any known issues with using datapump on a sql 2008 database?
One big example I can think of is that there is no such thing as a "text" field anymore. they need to be "nvarchar(max)"
Is there some way I can make this happen in datapump?
any help is appreciated,
We run DataPump 10.5 on SQL Server 2008 RTM with no problems. "text" fields are deprecated, but still supported, some of the tables in the DWCHServer database have text columns and SQL 2008 works just fine with them.