![]() ![]() In the industry “SQL Server” is the version that runs on a remote server and is recommended for use with teams, while “SQL Server Express Edition” is the version that runs on a local PC and the database therefore is used only by the local user. There are many other databases out there that include the tag SQL but to my knowledge EPLAN is only officially approved for use with the Microsoft products. When I say SQL I am describing a product from Microsoft known as Microsoft SQL Server. There are also a few advanced situations like modifying the EPLAN or ERP part numbers where the SQL scripts can really show their power. ![]() In future posts I will try to show you some of these simple scripts that will help make it unnecessary to waste time massaging excel data before you import it. I am NOT an IT pro but I have learned a few SQL scripts that have made me reconsider some of my past practices. EPLAN certainly comes with tools that enable users to import and export data to/from databases, but they often rely on customizing a confusing config file and externally massaging data. SQL has real tools built right into the database manager and many IT professionals already know how to use these tools. I started using SQL for my parts database a few months ago and the more I use it, the more I like it. Intended Audience: EPLAN P8 users who want to try SQL Server Express ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |