WinCC Unified Installing SQL Server Express and first steps inserting data

Опубликовано: 04 Октябрь 2024
на канале: dnomaiD Code
5,690
49

Video tutorial on how to install Microsoft SQL Server and SQL Server Management Studio (SSMS), create and configure a database, establish an ODBC connection and use a Wincc Unified project (TIA PORTAL) to manage interactions with the database:
1. Download and install SQL Server from its official website.
2. Download and Install SQL Server Management Studio from its official website to easily manage and interact with your SQL Server databases.
3. Use SQL Server Management Studio for SQL Server to create a new database file.
4. Add a new table within this database and define its columns and data types. Configure the necessary user roles or permissions.
5. Download and install the Microsoft SQL Server ODBC driver from the web site or other reliable source.
6. Configure the ODBC data source by linking it to your SQL Server database through the Windows ODBC Data Source Manager.
7. Obtain a sample Wincc Unified (TIA PORTAL) project that includes SQL database operations such as Insert, Update and Delete.

Download SQL Server:
https://www.microsoft.com/es-es/sql-s...
https://learn.microsoft.com/es-es/sql...

Download code:
https://github.com/DnomaidGit/WinccUn...