Find Jobs
Hire Freelancers

Write some Software

$15-25 CAD / hour

Berlangsung
Dibuat lebih dari 8 tahun yang lalu

$15-25 CAD / hour

I need a Windows console application that can convert an existing set of dbf/DB2 files to both tab delimited output and tsql. In a best case scenario: 1. copy a db2 file (which may be currently in use by the database) to a temp folder \temp off of the application folder for now 2. read the copied db2 file and extract the database column names and data types 3. generate and execute tsql to create the table (target Microsoft SQL 2008 and higher) 4. generate and execute tsql to insert the data the 'bulk insert' might not work due to us running on a different system so something like sqlbulkcopy might be a better option 5. using the same process, export the data to a tab separated file Note - Item 4: this table will need to pair db2 types to standard sql types Note - Item 5: should go through the same parsing code as Item 4 so that if there are issues with the inserting we can dump the data to separated data to see what the issue might be, or dump the data for other uses The application should take the following inputs from the command line: A. specify connection string (this will execute item 4) B. specify output folder (this will write 3/4/5 to file) for later use - output files should use a consistent naming convention such as: <inputfile>[login to view URL], <inputfile>[login to view URL], <inputfile>[login to view URL] C. specify drop / create to drop and create the file D. target table name, if not specified it will use the db2 file name (example: [login to view URL] = testtable) E. input file (db2/dbf) Example: [login to view URL] -connectionstring="Server=address;Database=db;User Id=myUsername;Password=myPassword;" -drop -create -table="tablename" -outputfolder=c:\output [login to view URL] I will provide db2 file examples BUT the code needs to be flexible for other schemas and not hardcoded byte count etc. to the samples. Notes: - Must be written in C# - I require the source code without any licensing or other restrictions - Target can be .NET 4.5 - It most likely execute on a Windows Servers (2008 or higher)
ID Proyek: 9089286

Tentang proyek

6 proposal
Proyek remot
Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
6 freelancer menawar dengan rata-rata $21 CAD/jam untuk pekerjaan ini
Avatar Pengguna
We have a team of expert DB Architects,MS SQL & .NET developers with more than 10 years of rich industry experience & would be more than happy to work on the project. We have 100% completion rate,please check our reviews to have an idea about the quality of work we have delivered in the past. If given a chance I assure you of the best quality work within time and budget. Regards NK
$21 CAD dalam 20 hari
4,2 (2 ulasan)
3,5
3,5
Avatar Pengguna
Our main objective is to provide: client satisfaction which we know can be achieved through excellence in quality and service. Knowing the fact that new technologies are emerging, we have focused mainly on new technology upgrades and training. We have already completed more than 400 project 40 people working in team all are highly professional
$22 CAD dalam 3 hari
0,0 (1 ulasan)
0,0
0,0
Avatar Pengguna
I have worked in similar projects, like as get information from SQL Server using Stored Procedure and an schedule task using sqlcmd and convert into an T-SQL file to export data to MySQL. All of this was programmed in a C# Application.
$16 CAD dalam 10 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I have 13 Years of experience in ASP.Net, .Net, VB.Net, SQL Server, Ajax, Javascript, HTML, CSS, Jquery, Bootstrap, ERP System and many more. I can start working on this project right away. Please let me know your suitable time for detail discussion. Looking forward your positive response. thanks
$22 CAD dalam 40 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera CANADA
Calgary, Canada
5,0
9
Memverifikasi Metode pembayaran
Anggota sejak Sep 8, 2015

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.