Create function to compare between two db
Take 6 parameter (source server , source db , Destination server , Destination db ) and 4 parameter optionally
(source user name , source password , Destination user name , Destination password )
Compare between :
Create table if not found
Updated Default Value
Updated allow Zero Length
Updated Required Value
Updated table diff in orders of field Or Size
Updated Fields Created Index
Updated Fields Created key
Added Filed found in Source Not in Destination
delete field mot found
procedures
triggers
cluster
View different in text file. In two parts fount in source ant not fount at dis.
Found in dif ant not found in source.
We have two table compared with content data
Named by (SYS_CONV, SYS_PRG, SYS_PRG_PARA, SYS_ MSG)
if click update
update all diff in Destination DB.
Rem.
If optionally parameter null connect with db as windows authentication .
Hello
I can create an desktop application for you. I have gone through requirements completely and can assure you that i can deliver this in 3 days. However i need more inputs from you.
Can we talk further??
Hi,
This can be achieved by using link server between these two servers and sync data using stored procedures and triggers. Another approach is to use C# windows application that will synch data between these two databases using stored procedures.
I have 8.5 years experience in C# and SQL Server.
Hello sir. I can do this job. I have great experience with c# programming. If you need serious man who can start right now, then I am perfect choice.
Regards
vladang
Hi,
I am a .Net and SQL Server Programmer having more than 8 years of experience in MS technologies. I will be able to do as per your requirement. Looking forward to work with you.
Thanks.
Hi,
I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you'll come to us again and again to avail our services.
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project.
Thanks,
Murtaza
I have extensive experience in C# and working with a variety of Databases and will be able to deliver your requirements. I am assuming you are referring to the comparison of SQL Server databases?
Hello Sir,
I have 5 years experience in MS technologies. I have gone through the requirement. I can start work. Kindly check your PM.
Many Thanks\Manas
Hi,
I have 5 years experience of managing and administrating SQL Server Databases, I am expert in Creating Indexes, Views, complex Triggers, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.
let's get the job done!