1
Vote

Error when importing table with schemas

description

Hi,

This is when using MSSQL and i think other RDMS as well.


When you are importing tables with this tool and one of your tables contains a schema with sql server keyword, that application can't continue importing

What I did to resolve this was, instead of this:
"SELECT TABLE_SCHEMA  + '.[' + TABLE_NAME + ']' [Table] FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'"
I used this:
SELECT '['+ TABLE_SCHEMA +']' + '.[' + TABLE_NAME + ']' [Table] FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

comments

Fagro wrote Jun 1, 2014 at 4:50 PM

Hi,I don't have permission to push code or maybe i don't know how to use codeplex properly.