Write Stored procedure in SQL Server

Suljettu Julkaistu 7 vuotta sitten Maksettu toimituksen yhteydessä
Suljettu Maksettu toimituksen yhteydessä

We need a stored procedure in SQL Server to push multiple tables data to remotely hosted SQL Server database with roll back option. Both database and table structure is same.

Microsoft SQL Server

Projektin tunnus: #13177058

Tietoa projektista

47 ehdotusta Etäprojekti Aktiivinen 7 vuotta sitten

47 freelanceria on tarjonnut keskimäärin $135 tähän työhön

Agiletechstudio

Hi there! I have read your initial requirements however, I would like to discuss things in detail with you. We have a team of best experienced software engineers and business analysist, especially achieving optimized s Lisää

$111 USD 3 päivässä
(67 arvostelua)
7.5
sergioeliot3

Hi! My name is Sergio. I 'am very confortable working on Sql Server, writting queries, developming stored procedure, changing the tables structures, optimizing performance. I will be confortable taking on your de Lisää

$146 USD 4 päivässä
(48 arvostelua)
6.8
mpalgeo

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have Lisää

$155 USD 10 päivässä
(64 arvostelua)
6.0
arityinfoway

Hello Sir, I have gone through your requirements is write stored procedure in sql server. we brief and understand your idea and preference for job as you are looking for. I have more than 5+ years of experience i Lisää

$142 USD 3 päivässä
(9 arvostelua)
5.2
IMExpertEngineer

Hello, I'm ready to do this stored procedure job as I'm expert in database an sql server and I've passed all 3 exams of sql server as well. Please share the details of your requirements so that I could start job Lisää

$155 USD 3 päivässä
(6 arvostelua)
4.6
jagdishbhatt38

I have more than 7 years of experience in IT industry.I have worked on SQLSERVER and Oracle database.I can provide you the best solution.

$178 USD 3 päivässä
(22 arvostelua)
4.8
Splaszczyk

Hi i work as senior SQL Server DBA, but occasionally also perform development project. Well according to SQL Server documentation MERGE statement can't be used to satisfy this scenario because may not be used as target Lisää

$216 USD 10 päivässä
(3 arvostelua)
4.3
phiona06

Hi! I can help with your task. For connecting to remote server I can use system stored procedures (linked server). And then execute needed sql statement for pushing data. All this statements will be in one transaction Lisää

$133 USD 4 päivässä
(13 arvostelua)
4.0
vw7590795vw

Please review my profile. I have 7.3 years experience in SQL and 4.6 years experience in SSRS, SSIS. Please let me know more details and when we will start. Sky pe: jikenjd

$34 USD 1 päivässä
(15 arvostelua)
3.9
mahesh2761990

Hi Sir, I have written this kind of store procedure in past. I can do this task. we can discuss further. thanks in advance

$105 USD 3 päivässä
(3 arvostelua)
3.4
HDDevelopment

السلام عليكم خبرة في العمل علي قاعدة بيانات sql server

$111 USD 1 päivässä
(4 arvostelua)
3.0
dat2na

Greetings, I'm professional database expert with 8+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like Lisää

$222 USD 1 päivässä
(2 arvostelua)
2.8
swarm22

I read requirement , we can achieve this task using SSIS package. Have to first create source database connection -> Apply some logic , insert into staging -> Insert staging records to destination table.

$155 USD 2 päivässä
(1 arvostelu)
1.0
yubor

hi, i am professional database developer with expert level certification in mssql server (have mcse:data platform certificate). would be glad to help you with your project. regards, yuri.

$100 USD 5 päivässä
(1 arvostelu)
0.5
stillart

Hello, I have some questions about the project: do you have a linked connection to your remote server? the tables to push have to be created on the server? (in that case rollback could be difficult but we could drop th Lisää

$150 USD 3 päivässä
(1 arvostelu)
0.6
pgcan

Hi, There are certain situation those are to be handled in SP, 1. Data to be written in small batches e.g. 1K records per batch. 2. Handle "Identity Key" columns. 3. Handle data dependencies due to foreign keys. Lisää

$222 USD 3 päivässä
(0 arvostelua)
0.0
smihir94

Dear sir, i have worked with multiple software companies. I have developed various types of applications. along with mobile apps, I can also manage database and create web services. if you have low budget that won't be Lisää

$35 USD 1 päivässä
(0 arvostelua)
1.9
conankid

Hello, I have experience in SQL including SQL server and MySQL. Will be done this project without any problem. Please discuss with me and we can start to work right away. Have a nice day.

$100 USD 1 päivässä
(0 arvostelua)
0.0
teekamsingh

I will do this by making link server. Benefits of link server is you can change link server name any time without changing the stored procedure definition.

$55 USD 2 päivässä
(0 arvostelua)
0.0
haseeb528

I have 1.5+ years of professional experience in Microsoft SQL server programming. I can do this project in 5 days. I will help you in any issue regarding SQL server programming. Regards, Haseeb Iqbal

$150 USD 5 päivässä
(0 arvostelua)
0.0