Speak now
Please Wait Image Converting Into Text...
Embark on a journey of knowledge! Take the quiz and earn valuable credits.
Challenge yourself and boost your learning! Start the quiz now to earn credits.
Unlock your potential! Begin the quiz, answer questions, and accumulate credits along the way.
General Tech Technology & Software 2 years ago
Posted on 16 Aug 2022, this text provides information on Technology & Software related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.
Turn Your Knowledge into Earnings.
Which technology should be used if I want to move my data from SQL Server to MySQL server when data is entered to SQL Server row by row and getting feedback from MySQL server?
SQL Server
MySQL
Should it be 1. Linked-Server or 2. SSIS?
Also,
Each time I insert a row in SQL Server it should also insert into MySQL and when it is done successfully I should update a flag column in SQL Server to 1 for acknowledgement of data insertion.
What if I update MySQL table. Would it be reflected in SQL Server also?
Given the above comments, I'd recommend going with an SSIS package. If you go with the linked server option you are injecting database dependency between the replication and the MSSQL server objects. Linked servers are also a security liability, anyone with sufficient permissions on the MSSQL database can access the target database on the linked server. Choosing SSIS gives complete control over the datasources, execution, scheduling and effectively decouples the data transfer from the actual databases.
No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
General Tech 9 Answers
General Tech 7 Answers
General Tech 3 Answers
General Tech 2 Answers
Ready to take your education and career to the next level? Register today and join our growing community of learners and professionals.