LOCAL_XE LocalDbSetup error when columns in physical table not also in Tools
Hi All,
Wanted to pass this along. We just debugged an issue where step 6 of LocalDbSetup fails. As it turns out the issue was there was a column in our Sever table that was not also in Tools. Looks like and X column that got dropped.
First thought it was a bug but in thinking about it maybe not so. Dataexp is used to export data and no column list is given on the utility so basically it does select *. Then for the LOCAL_XE schema the definition in Tools is used to create the schema and hence the mismatch.