Question : First of all, my english is really bad, so sorry for my english mistakes. I have a MariaDB […]
Tag: etl
MySQL failing and very slow on importing a large file
Question : I have a 47 GB MySQL dump of a single table: http://dumps.wikimedia.org/commonswiki/latest/commonswiki-latest-image.sql.gz I ultimately want it into PostgreSQL, […]
Stored procedure deployment – push or pull into database? [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
Specifying Order of Executing Stored Procedures
Question : Issue: The order in which my stored procedures are called produces no errors if run independently, but when […]
Bulk Updates on Normalised data present across several PostgreSQL tables
Question : We have several websites from where we download csv files – say 100 such websites. We don’t have […]
MYSQL Huge Data migration (5TB) from old server to new server
Question : We have an old MYSQL server contains huge data ~5TB and wanted to migrate to the new server […]
SQL Server Data Tools for VS 2015 – Anyone using for SSIS development to multiple versions?
Question : According to this link, https://www.mssqltips.com/sqlservertip/4253/backwards-compatibility-in-sql-server-data-tools-for-integration-services/ the newest version of SQL Server Data Tools – “SSDT for Visual Studio […]
Linked Server only for Select Statements?
Question : In linked server concept can we run only select queries like below ? SELECT * FROM OPENQUERY([SERVER_NAME], ‘SELECT […]
How do I run a large script with many inserts without running out of memory?
Question : Question: I have a script with around 45 thousand insert from select statements. When I try and run […]
How to copy selected table data from sql server to mysql on a daily basis? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]