I have a brand new empty SQL Server 2008 R2 database. I am trying to either load data from an FGDB or create a new Feature Class using ArcCatalog. Every time I try to perform either function, I get an error: Wrong Column Type and 00210 error.
When I run the SQL Profiler, I can see that the following SQL executes correctly in SQL, but then I see a DROP TABLE immediately after this step:
I can see how you can create a table with geometry in a database, but don't see how you could have been populating it without enabling an enterprise geodatabase. Query layers are read-only. Were you using an Interoperability tool in the other database(s)?
With 10.1, I have been able to Import Feature Classes to brand new layers in SQL Server 2008 R2 without enabling enterprise Geodatabase. All I had to do was create a database, and then create a database connection in ArcCatalog. Once I had a connection, I could use the Import Feature Class to import FGDB layers to the database. I did not use inter-operability extensions, but I did have ArcInfo Advanced. There were no SDE tables in the database. Is this something you can try on your system?
What kind of "database connection" did you make? The one with the name "Database Connection" has two options, OLE DB and Spatial Connection. The latter is an ArcSDE connection (Direct Connect); It can only successfully connect if the database has been configured with an enterprise geodatabase.
Are you using an Enterprise SQL-Server instance or SQL-Server Express?
I figured out my problem. The SQL Server database was set to a case-sensitive collation sequence. Once, I changed the database to case-insensitive collation, I was able to create and load feature classes using a direct database connection without enabling the database as a geodatabase. Thank you for your assistance.