Tag Info

New answers tagged

1

You have three options. Use the gui of SQL Server Management Studio. Use BCP to export your data in a loop (see here) Use Powershell and script your export in a loop for example. Here an example in PowerShell: $Tables = invoke-sqlcmd -query "SELECT name FROM sys.tables WHERE name LIKE 'list[_]%'" -database "ETTEDB_list" -serverinstance "YOURSERVER" ...


0

The following transformations may help. I have not used the DBMS_XSLPROCESSOR.CLOB2FILE method, but I did use these to migrate an Oracle database from Solaris to Linux. I could not use data pump because of the version of Oracle that they were using and the fact that they used XML data types for column data types. DBMS_METADATA.SET_TRANSFORM_PARAM( ...



Top 50 recent answers are included