Arpit Tyagidataminds.hashnode.dev·Nov 12, 2024Copy data from the Data Lake to the SQL Database, deleting any existing data each time before loading the new data:Step 1: Check the existing data in the employee table: Step 2: Change the data manually in the csv file in data lake: we need to check whether this change will be visible in the table or not (definitely at the end). Step 3: Settings in “Sink” opti...Discuss·7 likesAzure Data FactoryAzure Data Factory
Arpit Tyagidataminds.hashnode.dev·Nov 12, 2024Data Lake to SQL DB Data Movement ( or CSV to SQL Table data movement)Step 1: Do we have the table employee in SQL? Step 2: Use the dataset which is pointing to the file in Data Lake: Step 3: Set up the Source and Sink in the copy activity: Source - It will point to the dataset which is pointing to the employee file ...Discuss·8 likesAzure Data FactoryAzure
Pradeep ABpradeepab.hashnode.dev·Aug 14, 2024Copying an KMS Encrypted RDS PostgreSQL Snapshot from One AWS Account to AnotherIntroduction: This guide outlines the steps to copy an encrypted RDS PostgreSQL snapshot from one AWS account to another using AWS Key Management Service (KMS) custom keys. Follow these instructions carefully to ensure that the snapshot is successful...DiscussAWS
KITRUMkitrum.hashnode.dev·Jun 25, 2024How to Overcome 5 Common Data Migration ChallengesAs companies rely more on data to make decisions and improve how they serve customers, it is crucial to migrate data without hiccups. Think of it as the oil that keeps the engine of a business running smoothly. But here's the catch: data migration is...Discussdata migration
Rajender Singhsinghrajender.hashnode.dev·Jun 23, 2024Adding Minutes to Date & Time in VARCHAR Data Type (SQL Server)Today while working in one of my Data Migration project I came up with this problem where Date & Time data was in varchar format and I need to add minutes ( if more than 180 minute then settle for 30min) to it and spit it out as varchar in DD/MM/YYYY...DiscussSQL
Sourabh Guptaonlydataengineering.hashnode.dev·Apr 22, 2024How to Load Data from SQL Server to SnowflakeIn today's data-driven world, organizations often need to migrate their data from one system to another for various reasons, such as consolidating data sources, upgrading to a more modern and efficient platform, or enabling advanced analytics. One co...Discuss·75 readsSql server to Snowflake
Bob Blackburnbobblackburn.com·Apr 16, 2024How to Avoid these 10 Pitfalls during an Oracle to SQL Server MigrationMy first IT project was a data conversion for Fashion Bug. Since then, I have been on many conversions both as an in-house developer and as a consultant. The last few conversions have been moving Oracle Databases to SQL Server. Here are 10 pitfall mi...DiscussSQL Server
Anish GandhiProanishgandhi.com·Apr 4, 2024How to choose between the UUID and the sequential ID as the Primary key in Xano?At the initial stage of creating the data table, Xano will ask to choose the primary key as UUID or the sequential ID. There is no easy way I could find to change the existing table primary key from sequential ID to UUID which makes this decision mor...Discuss·384 readssequential id
Soumi Biswassoumib.hashnode.dev·Mar 20, 2024Maximizing eCommerce Efficiency: Advanced Strategies in Website and Data MigrationsIn general, efficiency rule the roost in current eCommerce market. A properly working website will be the last glitch that will save customers’ time in analog motion or stress them with the downtime. However, this process may seem difficult to make t...Discussecommerce website migration
Rodrigo Mansueliblog.mansueli.com·Sep 12, 2023Migrating from MongoDB to Supabase with PostgreSQLIn the realm of database management, making informed decisions can significantly impact your application's performance and scalability. This comprehensive guide will offer you one possible way of migrating from MongoDB to Supabase with PostgreSQL. Th...Discuss·1 like·269 readsMongoDB
