Sql Server Cape Town Projects
Looking for freelance Sql Server Cape Town jobs and project work? PeoplePerHour has you covered.
SQL Server Database Migration
I'm in need of an experienced professional who can assist me in transferring a large-scale database. Key requirements include: - Proficiency in handling and transferring databases, specifically SQL Server. - Experience in migrating large databases, in this case, exceeding 10GB. - Demonstrated knowledge in handling data and ensuring its integrity. - Ability to ensure smooth transfer with minimal downtime. Your role will involve transferring selected data safely, efficiently and without data loss. Prior experience with similar projects is highly advantageous.
11 days ago13 proposalsRemoteopportunity
Datatables.net (server-side), ASP.NET, VB, MS SQL
I have a requirement for a "simplified" version of an ASP.NET in VB page (default.aspx, default.vb) that: 1. Uses DATATABLES.NET with a repeater as the container for the data 2. Uses SERVER-SIDE processing in datatables.net with pagination, search, and sorting 3. Uses SQL Server to store the data (can use Northwind data as sample) 4. Uses (assuming) an .ashx Handler to manage/call/retrieve data from SQL in JSON
22 days ago19 proposalsRemote
Past "Sql-server-cape-town" Projects
Wordpress Plugin Errors
I recently upgraded the PHP on my server and now a couple of plugins have errors. I'm looking for someone with experience working with Wordpress plugins, PHP, sql and databases.
opportunity
Android TO-DO LIST working on LAN (REACT NATIVE / MS SQL SERVER)
I want to create an Android smartphone application that is a to-do list. The application will be installed on my smartphone and on my technicians' smartphone. I, who am the administrator, want to insert a job to be done into the application, for example "the printer in the technical office doesn't work, it needs to be repaired". I also need to be able to insert if it is an urgent job. Technicians who have the application, but are not administrators, should see the note and the time it was published. When each technician opens the note to see it, I have to see at what time they read the note. When a technician starts the job, he must tick it in the application and the start date and time must be recorded. When the technician has finished the work, he must report it in the application and the finishing date and time must be recorded. Only the administrator should be able to insert a job, modify it, or delete it. Technicians can only read the job, and report that they have started it and that they have finished it. The database that holds the application data will need to be on the company's MS SQL server. The application must only work on Android smartphones connected to the company's wireless LAN. No cloud data. The application will have to be developed with React Native. The backend will be developed with NODE.JS I attach a first draft of the screens
opportunity
Mobile App with React Native / Expo / CSV file (or SQL Server)
I need a Mobile App working on an Android Phone that reads barcodes and stores them inside the cell phone (connected to a LAN) After the operator has read each barcode, he must be able to enter a quantity. When the operator has finished reading the barcodes, he must press a button and the App must send the barcodes and the quantity in a CSV file to a shared folder on a computer on the LAN (or, if it is easier, write the data on a SQL Server table, in this case, I need also the code for the server if needed) The App must be developed with React Native / Expo
C# Developer
We are developing a LIMS platform using ABP.io in C#. We are seeking software developers to join our team and help develop new features. Requirements: - Excellent C# knowledge - Able to create high performing and clean code - Can take part in code reviews - Produce a full suite of tests for each new function - Microsoft SQL server - Working knowledge of Jira - Work within a remote team - Able to join regularly scheduled standups - Excellent knoweldge of working with Angular and writing front-end tests - UK Based. Nice to haves: - Experience working with abp.io framework Please apply with your experience, availability and location.
Stored Procedure setup on MY SQL
we need an automated daily process that moves data from SQL Server to MySQL using stored procedures, ensuring that the MySQL database stays synchronized with the SQL Server database The SQL server is hosted at clients location and our SQL server is hosted on AWS We have created a script that synchronises the data from the remote DB to our DB but it fails after synching about 1000 records out of 5000 Need someone who experience in stored procedures
Need help exporting database from sql server in windows
I am in need of assistance with exporting a MySQL database from SQL Server in a Windows environment. I am looking for a skilled freelancer who has experience with database management and SQL Server. Skills and experience required for this project: - Proficiency in SQL Server and MySQL - Knowledge of database export and import processes - Familiarity with Windows operating system - Experience with SQL Dump file format Project requirements: - Export the entire MySQL database from SQL Server - Ensure all tables and data are included in the export - Use the SQL Dump file format for the exported database Please note that I do not have any specific tables or data that need to be included in the export. The freelancer will be responsible for exporting all tables and data from the MySQL database. If you have the necessary skills and experience for this project, please submit your proposal. Thank you
Fare Calculator
Platforms: Asp.net, JavaScript, MS SqlServer, Google Services (required for the project). Develop a web application to calculate fares between pickup and drop-off locations using ASP.NET, JavaScript, MS SQL Server and Google services. The application will have three views using a MultiView control. The first view allows users to search for a pickup address using Google Autocomplete and verify the address. The second view searches for a drop-off address. The third view displays the pickup, drop off, total distance, estimated journey time and calculated fare. Fare calculation will be based on distance and a predefined rate structure. Both addresses will be searched and verified using Google Autocomplete restricted to UK addresses. The application aims to provide users with a simple and accurate way to obtain fare estimates for trips within the UK. The project will be assigned to the lowest quotation offered.
opportunity
Google app script - Google Sheets Automation
Google app script expert needed for stock price and data for world wide countries. Basically we have done for few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard worker. 6. No toxic working environment. We will pay $20-50/countries (negotiable) but we may fund more milestones for some few extra works. Possibly to double or tripple payments as bonus for urgent works. Each country is the same, you just need to replicate the codes which are already done but modifying some things like extensive stock according to set trigger for every country and also, check symbols are different in scrapped sources. SKILL : Google App Engine Google APIs Google Apps Scripts Google Systems
Web Scraping Data in to SQL database
I'm seeking a skilled freelancer to assist with a web scraping project on a specific website and leading up to a number of websites. The specific data fields that need to be extracted will be provided. Ideally, you'll have: - Advanced skills in web scraping and python -- Knowledge of MS SQL Server databases. - A demonstrable understanding of data extraction - A fast turnaround rate as this project is high-priority and needs completing as soon as possible. Experience in extracting both structured and unstructured data would be beneficial, as it's likely our sought-after fields will vary. The end goal is for me to eventually take over the code with your ongoing support and will most likely be a long term relationship. I can provide a full specification when needed. Please place your bids following this detailed outline.
Full Stack Web Developer
Proficient in HTML, CSS, JavaScript, and a server-side language (e.g., Node.js, Python, Ruby) Experience with front-end frameworks like React, Angular, or Vue.js Knowledge of back-end frameworks such as Express.js, Django, or Ruby on Rails Familiarity with databases and query languages (e.g., SQL, MongoDB) Experience with RESTful API development and integration Strong problem-solving and debugging skills Version control system proficiency, preferably Git Understanding of cloud platforms like AWS, Azure, or Google Cloud Excellent communication and collaboration abilities Job Description: We are seeking a skilled full stack web developer to join our team and contribute to the development of a WhatsApp Web application using the "whatsapp-web.js" library. As a full stack developer, you will be responsible for handling both the front-end and back-end aspects of the application, ensuring seamless integration and optimal performance. Responsibilities: Develop and maintain front-end components using HTML, CSS, and JavaScript frameworks. Design and implement server-side logic and APIs using a server-side language and framework. Integrate front-end components with the back-end using RESTful APIs. Create and maintain databases, ensuring efficient data storage and retrieval. Optimize the application for maximum speed, scalability, and security. Debug and resolve any issues reported by users or QA testers. Collaborate with the team to brainstorm and implement new features and functionalities. Stay updated with emerging technologies and industry trends in web development. Requirements: Proven experience as a full stack web developer or similar role. Proficiency in front-end technologies such as HTML, CSS, JavaScript, and front-end frameworks. Strong knowledge of a server-side language and framework for back-end development. Experience with databases and query languages. Familiarity with RESTful API development and integration. Proficiency in version control systems, preferably Git. Understanding of cloud platforms and deployment processes. Excellent problem-solving and debugging skills. Strong communication and collaboration abilities. Ability to work independently and meet project deadlines. If you are a passionate full stack developer who enjoys working on diverse projects, collaborating with multidisciplinary teams, and delivering high-quality applications, we would love to hear from you. Please provide examples of your previous work and any relevant links or portfolios when applying for this position.
opportunity
Website scraping tool
# Composite Use Case for myClerk.ai Web Scraping Tool Development ## Project Overview The myClerk.ai project aims to automate the collection, organization, and monthly update of documents from approximately 10,827 UK council websites, including 10,450 parish and town councils and 377 larger councils. This initiative seeks to make council documents easily accessible and searchable, covering essential materials such as constitutional documents, terms of reference, minutes, and planning documents. ## Objectives - **Automate Document Extraction:** Develop a scraping tool to automate the retrieval of PDF documents across varied council websites, accounting for the unique structure and content of each site. - **Efficient Data Organization:** Utilize council reference codes to systematically organize documents on a web server. - **Monthly Updates:** Implement a mechanism to capture new documents on a monthly basis without duplicating existing files. - **Link Monitoring and Notifications:** Create a system to track and report broken links and facilitate updates or notifications to site administrators. - **Data Categorization for Larger Councils:** Classify documents on larger council websites for more efficient retrieval and analysis. ## Database Structure The development leverages a hybrid database approach: - **Relational Database (PostgreSQL):** Hosts a comprehensive list of councils and their metadata, crucial for guiding the scraping tool to the correct websites for document extraction. - **Vector Database:** Reserved for storing processed text from PDFs for content-based searches, but note that this element is separate from the scraping tool task. ## Suggested Technologies - **Web Scraping and Data Organization:** Python, with libraries such as BeautifulSoup, Scrapy, and Requests for web scraping and automation. AWS S3 for document storage and PostgreSQL on AWS RDS for data management. - **Server and Hosting:** AWS Lambda for cost-effective routine downloading tasks and Amazon Aurora Serverless for RDS to dynamically adjust computational capacity. - **Notification System:** AWS Lambda and SNS for monitoring and identifying broken links, sending notifications for action. ## Crawling and Scraping Process - **Crawling:** Implement a depth-controlled crawler to navigate each council's website, identifying webpages with PDF links at all levels. - **Scraping and Downloading:** Post-crawling, the tool will scrape the identified PDFs, checking against previous downloads to avoid duplication. The tool is designed to adapt to the diverse web structures of council sites, ensuring comprehensive document retrieval. ## Monthly Update Cycle - The tool will perform a complete cycle each month, identifying and downloading new or updated documents based on changes in file details, thereby keeping the database current without accumulating duplicates. ## Development and Testing - Prior to full deployment, the scraper will undergo a testing phase on a selection of websites to refine its operation, gradually scaling up to include the full range of targeted sites. Timescale: basic model for testing to be delivered as soon as possible, a number of weeks can be allowed for the full model, including deploying it to the host web server and connecting to the database.
Simple web app - React + azure functions
I'm looking for a developer with React and Azure functions and Azure SQL experience to build a simple web app. The react web app will employ the SurveyJS library. It will: 1. Query Azure Functions backend to request latest survey definition file location and a response (session) id. 2. Fetch survey definition via CDN and initialise presentation using SurveyJS. 3. Fire and forget minimal post updates to backend reporting survey progress. 4. At defined moments (after key questions) POST the full (interim) survey response to backend. 5. At survey end POST final survey response. SurveyJS will handle all survey routing and presentation. Backend (Azure functions) will: 1. Ensure credibility of all requests (cors and/or other measures). 2. Query Azure SQL database to retrieve survey definition file location, initialise a response row in database and return id to client as requested. 3. Receive and update response status (last question completed) as notified by client. 4. Receive and update survey response data (JSON) directly to database when received from client. Additional client notes: The survey definition file may be of a significant size due to the size of the survey and number of language translations included (tbc). Therefore an unacceptable initial load time is anticipated, and an initial fast loading welcome page may be required while resources are loaded in the background. IP locale detection and locale/language switching on demand would be required for the welcome page. Locale/language setting would then be passed into SurveyJS for the actual delivery of the survey. It will handle all language and locale switching once the survey is running. Additional server side notes: A number of the survey questions will need to load their response options dynamically via REST API call. SurveyJS handles this itself on the client side. However the server-side endpoint will need to be implemented. This should be very simple as the SQL to fetch required data is already wrapped in stored procs on the DB. You will just need to validate the request and pass parameters supplied to the stored proc then return the results in the format required. All development will need to sit in our Git repo and be fully and automatically deployable to Azure.
Google app script - Google Sheets Automation
Google app script expert needed for stock price and data for world wide countries. Basically we have done for few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. We strive for succeed, so you need to able to be fast delivery, agile, and be responsible but also you must maintain a good working non toxic environment. We will pay $12/countries but we may fund more milestones for some few extra works. Each country is the same, you just need to replicate the codes which are already done but modifying some things like extensive stock according to set trigger for every country and also, check symbols are different in scrapped sources.
opportunity
Transferring of data from old to new website
I need someone to help us migrate date from one website to another and develop a user-friendly CMS to manipulate data. Old website www.universalvisas.com, new website www.visagroupltd.com, The new website is built on WordPress. we want to transfer all the visa requirements (countries, nationalities and visa information) from the old website to the new one). I have access to the plesk control panel, where the data is stored on a sql database on our dedicated server.
GPRC API programming
I need to get data from a server server via a gRPC API and store this data in a SQL Server hosted on Azure, where I can use this data in Power BI dashboards. I have the full documents and examples from the company who runs the server, I need a programmer to write the API and get it running and working for me.
Urgent Website Fix & SQL Server Update
About the Website: www.traduzz.com, built on the WordPress platform, requires urgent troubleshooting and maintenance. The website is facing issues with its WordPress template and requires an SQL server update. Scope of Work: WordPress Template Issue: a. Diagnose and rectify problems with the current template. b. Ensure smooth functionality across all web pages. c. Test and confirm resolution of all template-related issues. SQL Server Update: a. Safely back up the currently active SQL server. b. Create a new SQL server and import the previously backed-up database. c. Ensure the new server integrates smoothly with the website without causing any disruptions or loss of data. Requirements: Proven experience in troubleshooting and rectifying WordPress template issues. Hands-on experience with SQL server updates and database migrations. Must have prior experience working on similar projects and be able to provide references or case studies. Excellent communication skills and the ability to report progress regularly. Must be available for any follow-ups or potential issues post-completion of the project.
Experienced Python Developer Needed
We are currently seeking a highly skilled Python developer to assist in building the backend for our web application. The ideal candidate should have an in-depth understanding of Python, with experience in web application development. Key Responsibilities: - Develop and maintain the Python backend for our web application. Work with Python packaging and server packages, especially asyncio and Flask. - Implement asynchronous and multithreaded programming techniques to optimize performance. Required Skills: - Profound knowledge in Python programming. - Familiarity with Python packaging and server frameworks, particularly asyncio and Flask. - Expertise in asynchronous and multithreaded programming. - Ability to write clean, maintainable, and efficient code. - Experience in integrating backend services with front-end demands. Additional Skills (Preferred, Not Mandatory): - Knowledge of database systems and SQL. - Understanding of front-end technologies (e.g., HTML, CSS, JavaScript) is a bonus. - Experience with cloud services and server management. To apply, please submit your application with a brief introduction, your resume, and a portfolio showcasing relevant projects. As a special note, include the word "Bubble" in your application to confirm that you've read and understood the job post fully.
Migrating website from Windows Plesk server to Linux server
I urgently need someone with strong experience to help me migrate my website from the old host to my new godaddy hosting account. Unfortunately the website is currently down and showing a 403 error, however, I have already downloaded the website backup and SQL database files. I have tried myself but cannot do it because godaddy have stopped offering a shared windows server and I cannot seem to migrate the website from a windows plesk server to a cpanel linux one. The godaddy team advised me they are not compatible. I have tried to convert the files but was not successful.