Write small application

$250-750 AUD

Completed

Posted

over 5 years ago

$250-750 AUD

Paid on delivery

We need someone to help develop a small application/script that makes detaching, copying, pasting and re-attaching SQL databases simpler. The idea is to simplify updating SQL databases across different computers that are not on the same network. 1. Currently, our clients need to manually open Microsoft SQL Server 2008 R2/SQL Server Managment Studio as administrator. 2. Then connect to a database. 3. Then right-click on CxMaterials_11 and select Tasks - Detach - Drop (See image 1 & 2) 4. Then right-click on CxSystemData_11 and select Tasks - Detach - Drop 5. Then Select File/Save All 6. Then copy the database folder (normally found on C:\Planit\Solid_11\Database or C:\Cabinet Vision\Solid_11\Database 7. Then move the database to a new location (shared folder or USB) 8. Then re-attach CxMaterials_11 & CxSystemData_11 (see image 4) 9. Then repeat this process on computer B by detaching the current database, renaming it using a time and date stamp, and replacing it with the database folder from step 6. Then re-attaching this new database in SQL. 10. The final thing we need is to automate exporting some registry files from computer A and importing them on computer B (see image 5) This would be best as a purpose-built application with a simple user interface. Must run on Windows operating system. I am open to this running as a script for a syncing application that can already automate the copy, transfer, paste functions such as [login to view URL]

Project ID: 17473895

About the project

30 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@JohnTang

Hello Sir, Wow, very complex steps for moving the data for 2 databases. I have an idea for you. Why we don't make it with the synchronization for database. With Microsoft Sync Framework 2.1 ? One thing we must be sure that 2 database can be on the same LAN or VPN which is allowed communication both side. Let's give me more chance for discuss with you about the step and let's me completed the works.

$533 AUD in 5 days

5.0

(9 reviews)

5.1

30 freelancers are bidding on average $550 AUD for this job

@ehsankayani

Hi there, I have developed many automated scripts to perform similar tasks. You can see my profile for rating similar projects. Thank you

$555 AUD in 10 days

5.0

(231 reviews)

8.2

@rinsadsl

Hi, I can do a small c# application to attach and detach your db without any manual interaction. Please check my profile and review for further information

$833 AUD in 10 days

4.9

(115 reviews)

7.4

@fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can dev your app Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice

$277 AUD in 10 days

4.8

(84 reviews)

7.3

@expertcoder1vw

Hello, My guess is that you are "using a software that uses a SQL database" on one computer (production), and then copying that same database for use on other computers (copies), and that you need to repeat the process of copying it over each time, as well as some scripting. Well I am able to write a Windows application that will automate this for you, so that you will have to do as minimum work as possible. I can deliver this in 1 week to 10 days. Good quality work done, and I will be available in future for support. To get started, please accept my bid, and make some time to discuss with me your exact requirements. Thank you! Bests, Steve

$700 AUD in 10 days

4.9

(103 reviews)

7.1

@logicpowered

We are very interested in this database application project. I have read your project description and very much confident in completing all these requirements. Kindly initiate messaging so we can discuss further.

$555 AUD in 10 days

4.8

(39 reviews)

7.5

@Angel521

Hello I'm very interesting your sql automation project. I have experiences in this kind of project. I am able to implement your requirements with high quality. Please discuss more details over chat. Thanks.

$722 AUD in 10 days

5.0

(50 reviews)

6.4

@vbhavesh448

I have developed backup and restore function directly from software to Microsoft SQL server database on all most of the software I develop for my clients. Also, we can go for synchronizing database by keeping one central database and other will take a copy of it. If want manual import solution we can use backup restore functionality and for automated, we can use database synchronization. Let connect and discuss some important aspects so, I can suggest you the proper way and we can discuss on the solution you want. Thank you

$388 AUD in 25 days

4.9

(31 reviews)

6.2

@carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have Microsoft certifications in .Net development and sql server. I also have a lot of experience in desktop and web development. Regards

$555 AUD in 10 days

4.8

(42 reviews)

5.5

@Ahmed818

Hello, sir i am interested in you project i am ready to help you i think i can finish all within 7 days sure will deliver source code waiting your answer Thank you

$400 AUD in 7 days

4.9

(81 reviews)

5.4

@solucionesnet

hi, I have a ready made application to backup and restore ms sql databases from ftp server, I only need to add the new functions, please chat me to send some application pictures

$440 AUD in 5 days

4.7

(45 reviews)

5.8

@vnezapno

I propose the Electron Framework as the project base. You will be able to install the application on any Windows-based computer and it will look and work great. Portable version also will be possible. PM me so we can discuss project details. ---- I always look carefully at the task and bid only personally, not just copy-pasting whatever promotional text If you see this sentence - you can be sure that I'm interested in your job and ready to go

$644 AUD in 10 days

4.2

(3 reviews)

3.5

@NarendrababuG

Hi I have 8 years experience in .Net and Sql and currently working for Microsoft. I can do this , Ping me if you are happy with my bid. Thanks

$511 AUD in 10 days

0.0

(0 reviews)

0.0

@Geniusteam

Hello, Can we discuss in detail ?Do you have any timeframe? We welcome you to join hands with us as we think we are capable enough to start this project and we give you surety of answering all your queries. We are waiting to discuss in detail about the project so that we can provide you quality oriented results. We are a team of 100+ developers doing mobile and web application development. We have more than 12 years of experience Thanks Genius Team

$555 AUD in 20 days

0.0

(0 reviews)

0.0

@SaranyaBMVP

We can a create a jobs or ll use ssis to complete this task. Relevant Skills and Experience One year experience in SQL server

$500 AUD in 10 days

0.0

(0 reviews)

0.0

@thietnp

Hello, I’m an experienced developer and I think I’d be a great fit for your requirement. I’m good at Desktop Application, UI/UX, SQL. I have made many software/tools (implemented in C/C++/Win32/MFC/Qt/C#) for Japanese client. I'm interested in your post, your description is quite clear. Please hire me, I confident to complete this task with high quality. Best regard, Nguyen Phu Thiet

$500 AUD in 14 days

0.0

(0 reviews)

0.0

@kamilladyko

Hi! You provided detailed information how the application should work. Few questions: 1. The users should be able to choose connection/database name? 2. Do you want to use application on one PC to connect to another or every PC would run this app? 3. Registry automation, do you want to copy exported registry by hand to another pc? Points 2 and 3 would not be a problem if the computers are in the same network.

$333 AUD in 10 days