Administracija podatkovnih baz Jobs

Hello, We have setup a replication from MSSQL to MySQL. SymmetricDS auto creates the schema, but one table in source (MSSQL) contains trailing space => 'Artikelnr '. This gives an error with MySQL. This project is about fixing this issue so it automatically corrects it and creates the table. <!DOCTYPE database SYSTEM ""> <database name="dataextractor"> <table name=""> <column name="Artikelnr " type="VARCHAR" size="50"> <platform-column name="mssql2016" type="varchar" size="50"/> </column> Must be future proof so no one time manual fixes. A pastebin log file can be supplied for more info.

I am looking for an expert in coding SQL to help with a project. Specifically, I need help with debugging existing code, creating stored procedures and working with a MySQL database. The ideal candidate should have extensive experience in coding SQL, including working with databases, debugging code and writing stored procedures. An aptitude to problem solving is also essential.

server down have form bad drive. cannot boot back up. Need immediate assistant

As per our project scope, we need to save the data from the primary server to the secondary server. However, In the secondary server, the field of date-time is considered the same server system date-time. According to the requirement Need to pass the value of date-time parameters from the primary to the secondary server. Find strings in multiple tables of the Database. Hence, I would like to request you please do the needful for the same. please let me know if you have any concerns.

Creating B+ Trees and B- Trees and hashtable buckets.

Module Learning Outcomes The following LOs are achieved by the student by completing the assignment successfully 1. Evaluate techniques used to ensure security in a database-oriented information system. 2. Manage user access and user profiles within a complex and DBMS. 3. Conduct database audit. Assignment Objective 1. Understand the security attacks in the database. 2. Create database security auditing plan. 3. Implement user management controls to achieve security requirements. Write assignment

Hello I need mysql expert within DB and hosting.i have files,i will share it .it is simple work if you are check and solve my problem. Thank you

We have a MySQL DB, hosted on web server with Cpanel (phpmyadmin available) we need to make some optimisation and define some helping tables and views (all database is less than 10 tables) We should also define a periodic routine to take data from one table and translate it to other table inside the DB. Please bid if you have Vast experience with MySQL DB This is first job we will need in this DB, its a couple of hours work, Budget is 70$ for this project, we would like to work with a good supplier further more on our DB issues. Good Luck

Require a DBA , to manage server at client location

I need assistance with the Airtable base design. I have a data set of responses to a lengthy questionnaire. It is a flat “dataset” - one row contains all of the responses for each respondent. I want to do some basic analysis and run various scenarios - if we filter out all persons who respond X, Y, Z and A, B, C - what does the remaining group look like (measured by a response in the instrument (a self rating the respondents have did)). I’d like to set up the base so that I can adjust the criteria - the filter - and see how this effects the remaining pool.

I need the best of the best of the best dashboard customization to monitor (everything in the attached file) 1) Operational excellency. 2) Time delievery 3) Time of sales 4) Volume of sales 5) Strategic Delieverables 6) Cash Flow (expenses, returns, net profits) 7) income statemetn 8)expenditure statement 9) ....etc. monthly log, bi-monthly, every quarter, every six months, every year.

More details will be shared with the preferred freelancer only experts can bid . Please don't time waster's bid on it

I have SQL code that attempts dynamic SQL but it fails on error of 256 k limit. It also has INSERT INTO SELECT to set a current row; it then loops through current row; needs to set variables; builds dynamic sql; breaks loop when we have no more current row. I need this within a couple of hours, so i need an EXPERT. If you are certain that you are the Expert and can do this in a couple of hours, I'll pay you upon delivery. I do not have time to waste and I will not pay if you do not deliver the code. Hoping for that special someone who can kick snowflake butt. thank you super much for helping! Please look at attached code & table structures. If you get it to work let me know.

Oracle SQL Tuning, Tuning 4 oracle Exadata queries that's taking 3-4 minutes to run to make it to run in less than 30 seconds.

I am looking for an experienced Data Warehouse Consultant with banking knowledge and experience to provide Ongoing Support for a project I am working on. I have selected the SQL Server platform but it is not absolutely necessary should you have other options that can serve my needs better. I am aware that regulation in the banking industry may be an issue, but for this particular project, no specific regulations are necessary. This is an ongoing support role and looking for someone who can provide expertise and insight into the design, development and maintenance of the data warehouse.

I want to create for this project a chatbot using rasa, do you have experience in AI chatbots

I am in need of a freelancer to help me with a project of migrating from my existing OpenProject Bitnami to OpenProject on Ubuntu. I am using Ubuntu 20.04 and will require help in setting up the new OpenProject installation. The successful freelancer will need to be knowledgeable in OpenProject and proficient in database migration for this project. I am looking for an experienced, reliable, and self-motivated individual who is able to provide quality work that meets my expectations. If you think you have the necessary experience to complete this project successfully, then I look forward to hearing from you. Thank you!

I need an experienced database professional to help me optimize the speed of my queries and configure a high availability setup on a MySQL database. The optimization will focus on the queries being used by default. The high availability setup should cover all aspects of disaster recovery and data protection, with appropriate failover protocols. The ideal candidate has extensive experience in database optimization as well as working with MySQL databases to ensure a successful outcome. If you have experience creating or working with databases using other technologies (NoSQL, for example), that could be beneficial too. The expected result of this project is a database that can run quickly and reliably, providing maximum uptime and eliminating costly downtime from system outages. The perform...

Upgrade Primavera PPM and database to 19c.

My project requires assistance in converting my existing Microsoft Access database to a MySQL database which will be used in our new Word Press Web Sites.. We would like to update the database on our local machine and after updating, the files would be uploaded to the Word Press Web Server. The resulting MySQL database needs to be hosted on a local server, and I would like an interface to interact with the MySQL database. The Microsoft Access database contains both text and numerical data. My project requires someone who can efficiently transfer the data from the Access database and correctly incorporate it into a new MySQL-based system.

I have an sql server which i pull service-related data from in power bi. its all organized in tables now. im looking for a person who can zoom call IMMEDIATELY right now for maybe an hour or two. Open to pay negotiations if you can REALLY help me. must know at least dax.

Our company is currently seeking a skilled Tableau Developer and Power BI Expert to join our team. As a data visualization specialist, you will be responsible for developing and implementing visualizations, reports, and dashboards to help us gain valuable insights into our data. Responsibilities: Design and develop data visualizations using Tableau and Power BI Create and customize dashboards to meet business requirements Generate reports and automate report generation processes Analyze data, create data models and integrate and transform data from multiple sources Optimize performance and troubleshoot issues Collaborate with stakeholders to identify business needs and design solutions Requirements: Proven experience in developing visualizations using Tableau and Power BI Strong knowled...

Need in about 3 hours. Urgent 2 minutes meeting . Malaysian only . Payment Rm100.00

Drawing B+ and B- trees and knowledge on hash table buckets can be really helpful. New freelancers needed

Here's a simple flow leading form a mobile base in website.i have sample.i need database also.

Hello, I am in need of a Virtual Assistant that can help me with data entry and database clean up. I have specific software requirements for the task, so experience with that type of software is necessary. The estimated timeline for completion of the task is 1-2 weeks. The Virtual Assistant will be responsible for managing appointments, data entry, database clean up, and answering customer questions as needed. The Virtual Assistant will also manage my databases, ensure that data is properly stored, updated, and indexed. The ability to communicate effectively is essential, as well as the ability to pay close attention to detail. The right candidate will work quickly and efficiently to ensure that this project is completed within the desired timeline. Thank you for your consideration.

Database Administration, proficient knowledge of Django create for this project a chatbot using rasa

Rasa Chat bot to GPT4 AI chatbots, for customer be an expert on python

Hello I would like someone to build me a bridge between My Odoo PostgresSQL database to an old in house oracle based database I want my sales orders that I do on Odoo to be posted on the oracle as sales orders also

I'm looking for an expert DBA to help with a project related to moving data from an existing MySQL-based database to a new database system. Both database have different structure, table and datatype. I'm looking for someone with experience and expertise in MySQL, as well as a strong knowledge of best practices when it comes to data migration. Ideally, the candidate should have experience working on project-based tasks and be able to provide clear timelines for completion of the project. If you think you would make a great fit for this project, please don't hesitate to apply!

I am looking for someone to help me with a project involving sql (Structured Query Language). I don't need help writing a query, but I don't have an existing database nor do I have the structure set up. I also do not need help creating stored procedures. The project does not involve any of these tasks. I simply need somebody to help me with sql for a particular project.

I am looking for an experienced administrator for regular support for a real estate team. The successful candidate should have a strong background in working with real estate agents by offering assistance with admin tasks, email inbox management, agent outreach, phone calls and more. Someone who is meticulous and has excellent attention to detail and reliable organizational skills is necessary. Experience in a similar role would be preferable. The ideal person should be self-motivated and a team player. If you feel that you have the skills and experience to work in this position, please apply now.

We are looking for people who rant to work for two months project in order to create a Business intelligence program based on Power BI.

This server suffered HDD failure or HDD COntroller failure. Dell support has been less than useless in helping with this. The server had 8 VMs running, using VMWare. Will need someone local to our Area, Windsor - London - Sarnia, Ontario, Canada I'm looking to restore my existing server using VMware virtualization software. The business I am representing has been established for a while now, and is in need of a reliable server to store and manage our data. We require a knowledgeable individual who has experience working with Dell servers as well as VMWare for restoring our current system. If you think you are the right person to complete this task, please contact me so that we can discuss the details further. Thanks for your time.

I'm looking to hire a freelancer who can help me with Oracle SQL Query Tuning and improve Oracle Performance. I will be using Oracle Exadata Database and therefore the successful freelancer should have prior experience working with these versions. The specific work required is Ad-hoc Query Tuning so the applicant should include relevant past work and experiences as part of their application. Detailed project proposals are also appreciated. Scenario: 4 Oracle SQL Queries that we have taking time anywhere from 3-7 minutes and wanted these to be running in less than 30 seconds. So require some one with Oracle SQL Performance Tuning Expertise to rewrite the query or Add any DB Configuration or Indexes or other Performance enhancement tips to cut that runtime down to 30 seconds or less. ...

Drawing B+ and B- trees and knowledge on hash table buckets can be really helpful.

modifying store procedure on sql server

I have several realestate documents of realestate pin numbers and lot number owned by several owners. We are looking for someone to transpose from the paper print outs and list the owner names, the pin number and the lot numbers associated by owner. In other words, we are looking for the number of lots owned by each named owner. What owner names are associated to lots and pin numbers.

create digital planner to sell on etsy Brief: Dog groomers starting and scaling a new business. track expenses, coloums for product links etc Example - please dont message direct. i will only respond to bids. Thanks

Hi, We are looking for expert who could help us get data on existing report in SQL server reporting services & microsoft report builder, 2 reports are currently not returning data suddenly everything is intact, we are using SQL server 2016. SQL query in dataset is not returning data as of now. connection string / some connection dataset or queries needs to be checked. There is a table created by our team in SQL 2016. We need help in getting the data from database.

i need someone who is good at ERD, 3NF, Data dictionary, SQL scripts use of ER modelling

I need a good sql server programmer to be my right hand man , I have multiple projects small and big .I just need someone that knows SQL not bid if you haven't read the description ,you will be denied

I am looking for an experienced Oracle SQL and Python expert who is comfortable working at an intermediate level. The ideal candidate should have experience in a similar position, and should be able to demonstrate their ability to fulfill this role. The deliverables of the project will be SQL scripts that are built to accomplish a specific goal. This can involve automation of existing databases, as well as writing and improving existing ones. The successful freelancer will also be expected to perform data analysis and create reports from the results. For consideration, please include relevant experience, detailed project proposals and also past work in your application.

I'm looking for an Oracle SQL and Python expert to help with a personal project I am working on. I have existing materials that need to be modified and utilized for the given project. The amount of time needed for this project should not exceed 2 hours. This project is for personal use and does not involve starting a new enterprise or working for an existing business. I am a knowledgeable user of SQL and Python, but am looking for someone who may have more experience to give me some extra guidance in completing my project with these languages. If you are an experienced Oracle SQL and Python programmer, I would greatly appreciate your assistance. If you are able to help complete the project in under two hours, please reach out to me and let's discuss further!

Analysis of changes and massive update of data between two tables of agricultural parcels with a common field. Work environments: GIS, ms access, SQL and python.

We are looking for a database developer/compiler who can help us develop and maintain our databases. The ideal candidate will have experience with both SQL and NoSQL databases, and will be able to write efficient and reliable code. They will also be able to work with our team to ensure that our databases are up-to-date and meet our needs.