Project scenario: The front-end is leyui back-end sqlserver and maraDB for paging. The two databases have different writing methods for back-end paging. Solution: front end: Define the table. The format of the table is created when the interface returns and bound according to the id. <div class=”layui-tab-item layui-show” style=”padding-top: 10px”> <div class=”layui-card-body” style=”padding:20px 0px;width: 100%”> […]
Tag: sqlserver
Use flink sqlserver cdc to synchronize data to StarRocks
Frontier: flink cdc is becoming more and more powerful and supports more data sources. This article introduces the implementation of flink cdc: sqlserver-》(using flink cdc)-》flink -》(using flink starrocks connector)->starrocks entire process 1. sqlserver environment preparation (you must use sqlserver versions below 16, flink cdc currently only supports sqlserver versions below 16) I am using the […]
SQLServer audit function configuration
1. Introduction to SQL Server audit function The SQL Server audit function (Audit) is a function only available after SQL Server 2008. Audit (Audit) is used to track and record events (Events) that occur in a SQL Server instance or a single database. The mechanism of audit operation is to capture events ( Event), writes […]
Configure SqlServer multiple data sources and switch access libraries according to the selected organization
###This article uses annotations. If you have any improvements, please let me know! ps: I’m a bit verbose~ Access a class without specifying a method, and dynamically switch according to the front-end selection! ! ! See clearly! ! ! For methods to specify which database to access, please refer to: Spring boot uses AbstractRoutingDataSource to […]
Export a view from sqlserver and import it into another database
Code Because there may be an inter-standard dependency relationship between imports, for example, table A references table B but is imported from table A, so the import of table A will fail at this time. To import table B first, I have adopted the method of multiple imports and failed. Put it into the new […]
SqlServer traverse files
This example realizes the traversal of Excel files under the folder and realizes the import function CREATE proc [dbo].[pr_traversing_folder_establishing the relationship between files and delivery orders] @Path nvarchar(260),@date char(8),@warehousing varchar(30)=’Langfang’ as /* Traverse the outbound list of folders on a certain day (8-digit date as the folder name), and the excel file, Establish file relationships […]
PHP (laravel+apache+SQLserver) configuration link SQLserver
1. Requirements: The laravel framework can connect to the SQLserver database 2. Environment: local service based on phpstudy under Windows laravel + apache + SQLserver Windows10 laravel5 + SQLserver2008/SQLserver2012 PHP7.3/PHP7.4 3. Required documents [Free] PHP (laravel + apache + SQLserver) configures the file resources required to link to SQLserver – CSDN Library Fourth, preparation 1. […]
Mysql to Sqlserver table creation script (based on java8)
Preface: The company requires the self-developed platform to support the sqlserver database, so it is necessary to convert the previously used mysql database to sqlserver, so that the subsequent platform can also run based on the sqlserver database. However, it is too painful to write sqlserver comments. Mysql can handle things with one comment, but […]
SpringBoot integrates mysql, postgres, sqlserver to realize multiple data source configuration cases
Let me share a small demo I worked on recently, about configuring multiple data sources to realize data push and data governance between different services. The first time I came into contact with the pg library and sqlserver, I was confused, and chose the way of JDBC + mybatis-plus to link. 1. First, introduce the […]
Coordinate Transformations – Read and convert coordinate systems of geospatial tables using GeoTools (SQLServer, PostgreSQL)
Foreword: When importing spatial data into the database through GIS software in business, due to different data sources and software settings, the spatial table coordinate systems that may be imported into the database are various. If you want to publish the database space table to GeoServer and unify the coordinate system, you just simply set […]