Transfer of content from BD#1 to BD#2
1 .Content transfer is required to make comparable tables from BD#1 to BD#2
2ndThe transfer of content is supposed to be carried out by work at the BD level, that is, it is not desirable to use the code change on the site.
ThreeWhen transfer, the current version of the BD (BD#2) requires not to replace the content, but to combine
4 .To optimize the process, only text information is expected to be transferred, for ads up to the age until the end of 2020 (for 2021 already hand transferred)
and 5.Not required to transfer images from ads (only text information)
6 .Most likely, working with BD will require interaction with sales tables and users (fields by them.Parameters of the car are maximum in both versions.
7 .On the output is expected to get not separate tables, but the ready BD to download, as you need to process the tables sales and users accordingly as noted in the user task and all the ads with the old and new version should be combined, each ad must belong to the corresponding user
The algorithm of work can be represented as:
1 .In BD#1 for all ads, the fields responsible for the images are cleaned, i.e. if they remain all without the images.
2ndThe slay tables in BD#1 form links for example of those used in BD#2 (i.e. the slay tables for BD#2 for example)
ThreeCompare the TTH fields that are used in BD#2 (if necessary, they are linked to the right look, but they must be identical)
4 .The structure of the user table is checked (if required, it is matched to BD#2), it is checked that specific ads belong to each user.
and 5.Adapted content is added to the corresponding tables of BD#2, a double check is carried out, a complete summary of BD#3 is formed (for the performer this essentially means the update of the tables of users and sales).
Client's review of cooperation with Dmitry Thorzhevsky
Transfer of content from BD#1 to BD#2The task is performed according to the specified TZ, the quality of the work done at the highest level, I recommend!
-
130 Hello to you.
I can help you with your task.
Great experience in design and work with BD.
But we need to study the structure of the BD.
Per at a personal meeting (I am from Dnepr)
-
1330 62 2 1 Hello to you,
I can transfer / combine data in 2 bases.
-
747 25 0 Good day . Ready to perform the task. I have a lot of experience working with BD mysql. The deadlines are indicated with the stock as the structure of the tables and the volume of the data are not indicated.
-
266 1 0 Ready to take your task. I hope it will not take a lot of time. With the stock I say that 2 days.
-
636 35 0 Good day . Interested in your project. After the implementation of the transfer I can offer as an option to download the scripts from the table and download the script into a new bd with possible checking.
Before the start of the work, it is necessary to discuss more in detail and clarify the task.
Working through the seafood
-
3340 101 4 3 I can say there is a lot of experience in solving such tasks.
To evaluate the structure of both BDs.
Current freelance projects in the category Databases & SQL
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 12 hours 36 minutes back ∙ 12 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 2 days 12 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 2 days 23 hours back ∙ 5 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 6 days 6 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 8 days 10 hours back ∙ 61 proposals |