Find Jobs
Hire Freelancers

update remote database from local SQL server

$10-30 USD

Cerrado
Publicado hace alrededor de 4 años

$10-30 USD

Pagado a la entrega
I have a database on the website and I need to bulk update a table using data from local SQL server. Need to suggest the best way and make script on local side.
ID del proyecto: 24055304

Información sobre el proyecto

31 propuestas
Proyecto remoto
Activo hace 4 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
31 freelancers están ofertando un promedio de $36 USD por este trabajo
Avatar del usuario
Hello, I am here with a total of twenty years of development experience. I can fulfill all job responsibilities with my experience. I will create a bridge between your local and website database, so you can do the bulk update whenever you want. Please tell me more about your website database and local database so I can make the plan accordingly. I am waiting to have favorable words from your side. Please initiate a chat to discuss more, and I will give more details about my projects. Regards, Anis
$100 USD en 3 días
5,0 (66 comentarios)
7,3
7,3
Avatar del usuario
I have deep and proven experience in T-SQL and SSIS development. My expertise in implementation, troubleshooting and tuning of complex queries and SSIS packages is on highest level. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday duties were: development of different types of reports, dashboards, KPIs, ETLs and functional modules for application`s data layer, Investigation and resolution of performance and locking issues on high loaded production environment. You could accept me and i will share my expertise with you.
$111 USD en 2 días
5,0 (50 comentarios)
5,4
5,4
Avatar del usuario
Hi, I represent Cidrec Technologies Pvt. Ltd. We are a closed group of dynamic and versatile young individuals of different skill sets to make a complete team. For this particular project I want to briefly describe about our Senior Software Engineer, Nikhil. “Nikhil is a Senior Software Engineer having 9.4 years of experience in multiple programming languages with cross domains. Possess excellent query writing and optimization skills. Team man, quick and self-learner, always open to gel with new languages. He has vast experience in development and support role with different working areas like telecom, e-commerce, retail. He is well versed in different programming methodologies like SQL Server, Oracle, PL/SQL, T-SQL, PHP, Angular JS, Shell Scripting, .Net, MVC. He is a keen learner of new technologies by his own and that's how he has worked with different programming languages in all his previous projects. Efficient at visualizing and mapping software solutions to mundane tasks, Nikhil is passionate about automation through technology. Working in start-up culture, he has proved his worth in taking challenging roles and delivering projects with 100% project goal within defined timeline.” Please try us once to know our potential.
$20 USD en 7 días
4,9 (18 comentarios)
5,3
5,3
Avatar del usuario
Assuming, you can connect to the database of your website from sql server management studio from your local computer; and you do have a separate database in your local server as well where you'll be updating your data. And you want that data to be updated in your website's database. The process can be either automated, if frequent updates has to be carried out, else manual update is quick and easy if updates are less frequent. Manual process 1) Create a table on website database and update that table with the data from your local server. It can be updated either via linked server or excel file import/export or direct copying of excel file to server or any medium you like. 2) Run the stored procedure on website's database. That will update your website's table from freshly copied data in our new table. Automated process 1) Table and stored procedure will be there and a SQL job on the website's database to check for new data and update your table. 2) One more sql job in your local sql server which copies data to the website's database. This can be done manually as well just for convenient as well.
$30 USD en 7 días
5,0 (63 comentarios)
5,3
5,3
Avatar del usuario
Hi, I have 11 years of experience in SQL Server development. For me the best way to insert you can either use triggers or you can use insert into on some conditions. Let us have quick discussion so I can work on it.
$80 USD en 3 días
5,0 (33 comentarios)
5,0
5,0
Avatar del usuario
The best way is to use SSIS ETL tool to extact any kind of data from one source and move into another destination.
$100 USD en 1 día
5,0 (29 comentarios)
5,0
5,0
Avatar del usuario
I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker
$30 USD en 7 días
5,0 (13 comentarios)
4,2
4,2
Avatar del usuario
i can suggest to update your database with bulk changes right now Working on Angular 9.0, .Net Core 3.1 Web Api and curious to work on VueJS or Vue Nuxtjs, MongoDB and all latest framework. Profile Descriptions and Responsibilities: Working on Angular 7.0, .Net Core 2.1 Web Api and curious to work on VueJS or Vue Nuxtjs, RFID Windows application Project ,NodeJs, Angularjs, MVC ,WCF, Entity Framwork, Canvasjs, Chessjs, Underscorejs, Angular Meterial, Mobile Application Ionic framework, Canvasjs Reporting, Jquery, JSON,WCF,Ms Sql Server, MVC or MVVM pattern , Asp.Net.etc. • Develop Web Application Product, UI layout, SPA with Angularjs,HTML5,CSS3, Bootstrap and resolve all issues & bugs with Agile Methodology.
$30 USD en 1 día
5,0 (11 comentarios)
3,2
3,2
Avatar del usuario
I have gone through the above-mentioned details very well. I have got plenty of experience in .net, mysql, microsoft sql server, vb.net kinds of works and I can assure you that I can reach your satisfaction level by providing you best results with .net, mysql, microsoft sql server, vb.net Looking for a positive response Thanks
$30 USD en 7 días
5,0 (1 comentario)
3,2
3,2
Avatar del usuario
Hi, lets connect and discuss your requirements. I will definitely work your requirements. I have good work experience in .net mvc,c#, MS-SQL Thanks
$30 USD en 1 día
5,0 (5 comentarios)
3,2
3,2
Avatar del usuario
Verified SQL expert, certified in the top 3% of all freelancers globally. Have written many complex queries powering international multi million dollar companies. There are a few ways we can do this, using either SQL export/import or functional programming to recreate the schema.
$30 USD en 3 días
5,0 (7 comentarios)
3,4
3,4
Avatar del usuario
Hi , Hope you are doing well. I am excited to work on this project.I read a description and i will complete the project in 1 day. I am web developer and having 3 years of experience.  Expert: 1. Wordpress , PHP, C# , HTML ,Javascript, MYSQL - MSSQL. Please give me an opportunity. Thanks
$20 USD en 1 día
4,9 (7 comentarios)
2,5
2,5
Avatar del usuario
Hi I am working from 8 years with sql server and services. Worked with sql server from version sql 2008 r2 to 2017. I am involved in data migration, clustering, always on, stored procedure, views, schema, table , query performance and other activities. I have worked with central and state government projects having one lacs users around and 10 stake holders. worked with database of 1 tb and millions of rows in a table. So worked in query performance, sql profiler also. I have done a lot work on migration also. I would like to go through in details about the project. Regards
$20 USD en 4 días
5,0 (7 comentarios)
2,5
2,5
Avatar del usuario
Can help you export the local version and subsequently import / merge with the online database. I am a senior web developer with 15 years of experience. We can get started right away and address your request. Please let me know if you have any questions. Thank you. Best Regards, Ken W.
$10 USD en 1 día
5,0 (3 comentarios)
1,4
1,4
Avatar del usuario
Self-motivated and proactive Quick-learner Resilient Flexible and adaptable Passionate about travel Ability to work outside the team / office environment Thorough, good attention to detail Enthusiastic
$10 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I'm Gaurav, I'm a certified Azure Architect with 10+ years experience in Azure and infrastructure development. I have experience with various Azure IAAS & PAAS components such as VM's, Virtual Network, Azure Storage Account, IAM roles, Azure AD, ADLS (Azure Data Lake Services) Gen2, Azure Data Factory Pipelines, Azure Data Warehouse, Azure DevOps and mony more. Very recently, I have done the migration of 20-30TB of data from AWS Redshift to Azure SQL Data Warehouse in real-time experience for one of my client using tools such as Azure Data Factory Pipelines, SQL Stored Procedures, AzCopy tool etc. I have also been part to designing and implementation authentication mechanics for Azure resources and Data Warehouse. Apart of this, I have also *Automated* the data load stuff reducing the time of load process from 16-20 hours to only 2 hours that to in just a click. I am also in teaching field since past 3-4 years. I think you will be much happy to understand all the things with live practical experience rather than just few theoretical concepts. I would be able to share you all my live experiences and all the experimented way and errors for this topic. So, feel free to get in touch with me for further query or concern. Thanks & Regards, Gaurav Kariya
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am able to work well on Microsoft Sql Server. I believe I can do it.I will try to fulfill my assignment as soon as possible.
$20 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am ready to do this project. Looking forward for your response. Thanks, Mohit
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have reviewed your project post, I can definitely help you to accomplish your requirement on your existing project. I am a very dedicated developer with 10 years of experience in Microsoft technologies. I have completed no of the project with these technologies. Looking forward to hearing from you soon
$20 USD en 2 días
0,0 (0 comentarios)
1,4
1,4
Avatar del usuario
I have good experience on SQL server and ssis. I have experience on creating database,tables,store procedures, functions and views. I have good knowledge on creating relationship using Constraints. I am interested to work on your project.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SAUDI ARABIA
jeddah, Saudi Arabia
4,9
115
Forma de pago verificada
Miembro desde abr 6, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.