I created metadata over a "set" of files.
My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database.
Unfortunately, when I attempt to define my primary key over the main file, I receive an SQL error message. I was able to determine that this is attributed to certain field names in the file beginning with special characters such as @, or $ which evidently SQL can not handle.
So, my question is, does anyone have a work around, or, do I need to rename all my fields in the relational database prior to creating the metadata?
Thank you for your feedback.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: