Posts Tagged SQL

Data Migration For Experience Developers

We have Read-Only, remote SQL access (server,db name, user, passwrd) to a MS SQL 2005 database and we need to:

Create a custom tool that can do the following on demand (one or two-clicks solution)

1. Read the data (obviously)
2. First time copy the data to a local host (or another remote host – Apache shared host / cPanel access only)
3. Update the new data or the changes to existing records
4. Find the relations between the tables / views
5. Select by criteria some records (Filter) (example: all the persons named "John" and Born after "1/1/1990")
6. Use the results in a ecommerce (osCommerce) as products for sale
7. …anything else that is needed to have:
– on-demand
– up-to-date
– filtered records
– available in the ecommerce as products
– Classified according to the DDC system (see below)

You will create the products database structure in a default osCommerce installation based on the categories in the resulted database.
This structure is based on the DDC System:
– http://en.wikipedia.org/wiki/Dewey_Decimal_Classification)
– http://en.wikipedia.org/wiki/List_of_Dewey_Decimal_classes

This structure has to REPLACE the default osCommerce "categories" structure and it IS INCLUDED in the database (as a field in the "products" table)

We have to result with a fully working and "browser visible" oscommerce shop and products.
(NO templates or other things to deal with – just the database)

You can decide the technology to use (example: php, C++, …)
If you have another strategic (instead of the "1,2,3,…,7" steps I propose) to have the same result we can discuss it.

The destination server is Apache, shared host, and we have cPanel access only! (not sql remote access)

If you need any additional info before or after you place your bid please ask me,
Thank you.

Note I am look for providers with minimum of 3 or more reviews and complete this project shortly.

Happy bidding….

Tags: , , , , , , , , , , , , , , , ,

Transform SQL Query To An Updating Stored Procedure

I have a SQL query that returns 2 columns whice are IDs from 2 tables on a one to one relationship.
I need this to update two table in a MS SQL database using a stored procedure, looping through each row of the query. The query currently matches 1:1 even if there is a dupe and it is important that it only updates 1 matching entry in each table even if there are dupes.

Please see attached sample query and notes.

Tags: , , , , , , , , , , , , , , , ,

C# Application Window With 4 Tabs – PriceSheets

This project is for development of a single window form with four tabs. The purpose of this window form is to allow users to maintain product price sheets. A product price sheet contains a list of products with different types of pricing. This window will use SQL Server database tables. The attachment contains alot of details and please note that the design shown in the screen prints will be provided along with some code as mentioned. I always pay extra for early completion and improvements. Provider will be provided with SQL Server tables mentioned in SPEC, visual studio project and specification.

TAB1 – This tab is where the user will create new price sheets, delete existing prices sheets or open existing price sheets for editing from a Gridview control.

TAB2 – This tab is where the user will selects the products that apply to the selected price sheet. This tab cannot be selected until a price sheet is selected from TAB 1. This tab will consist of a TREEVIEW displaying a hierarchy from a SQL server table (this code will be provided), 3 list box contols, a gridview to display products for the selected treeview node.

TAB3 – This tab is where the user will select an additional criteria to limit the price sheet to certain price types and/or receivers. This tab will contain 2 list box controls to allow users to select price types and receivers. The list of price types and receives will be obtained from a SQL Server Table.

TAB 4 – This tab is where can create a Price Catalog from the selections made in TABS 1 3. There will be 2 buttons. The [View] button will display the report in the window. The [Print] button will open the print dialog window for the user to print the report.

Delivery Expectation:
Provider will be provided with application window form show below so none or little design is needed.
Provider should be experienced with creating text reports.
It is recommended but not required that the provider user use DevComponents software. A full functional trial version can be downloaded here – http://www.devcomponents.com/downloads.aspx.
Must be developed in C# and compatible with Visual Studio 2010
All source code must be at least unit tested.
All source code must be provided including any stored procedures when final milestone payment is made.
Must be developed using two tier application layer. All the SQL Server calls will be made in Data layer called DAL. This will be provided.
Writing performance efficient code is critical for this window. This window must open within a 2 or 3 seconds.

Tags: , , , , , , , , , , , , , , , ,

SQL For Data Management

Assistance is needed in completing an SQL for Data Management project. The scenario and assignment requirements are attached.
Thank you.

Tags: , , , , , , , , , , , ,

VS FormView Insert

USING:
SQL 2005-2008
VS 2005 – 2008 – 2010 VB

Im having problem, and cant seem to find any solutions using Google, to be able to pre-fill textboxes in FormViewInsert mode, using data from Table A, and saving form contents into Table B.

I need a small demo created showing the process, along with detailed instructions. Need an example using both EXEC Stored Procedure and a query, and using Northwind database. Form will be called with a link using QueryString value or Session value. Link(s) on non related page may call the form, and thus would need ModeChange to insert.

Tags: , , , , , , , , , , , , , , , ,

Bike Compatiblity Site

Hi,

I have a client who requires a simple site that allows them to upload bike information. The system will then have a set of accessories so when the user selects the make, model and year from a drop down box it will then return compatabile accessories and items for this bike.

This system must be developed in ASP.NET C# and connected to an SQL Database.

Tags: , , , , , , , , , , , , , , , ,

C# Data Access Code

I need an application that reads a SQL database and produces in C# the data access layer code as well as stored procedures to perform CRUD operations.

All Foreign Keys, Indices, and Primary keys need to be read and treated appropriately.

please see this file for further details BEFORE BIDDING: www.websprite.ca/project_file.txt

Tags: , , , , , , , , , , , , , , ,

.net SQL Server EDI

Write a module which will use data in an exisiting SQL Server database, create NSF claims file and be able to read a NSF remits file and write the payments back into the database.
Alternatetively an EDI 837 claims file and EDI 835 remits file formats are also acceptable

claims format definition documentation:
https://mytools.gatewayedi.com/Help/documents/Claims/837P.pdf
https://mytools.gatewayedi.com/Help/documents/Claims/paddedNSF.pdf

remits format file spec:
https://mytools.gatewayedi.com/Help/documents/Remittances/NSFREMITSv2.01.pdf
https://mytools.gatewayedi.com/Help/documents/Remittances/835.pdf

Tags: , , , , , , , , , , , , , , , ,

New C# DashBoard WIndow

Description: This project is for development of a single window application form that will be used as a dashboard (home page) of a windows application. The window will consists of three panels each containing different information. This should be a very simple project and I have a provided alot details in the specification. No design is needed just code. As always, I will pay extra for design improvement suggestions that are used and suggestions that will improve performance efficienty.

Below is a summary of each PANEL.
Data Score Card. This panel will contain two PIES Charts and numerous data quality counts about the data
stored in SQL Server tables.
Recent Events. This panel will contain a listing of application events. This data is read directly from a SQL
Server database. Very simple.
Automotive Aftermarket News. This panel will contain news articals from a website. The link is below. http://alquemie.smartbrief.com/alquemie/servlet/encodeServlet?issueid=FC29073A-5FE7-4013-BE9D-4F1385EFED7E&sid=a2cfc691-9ba9-4980-bbd8-e3a5e01d2a46

Please see attached specification for more details.

Delivery Expectation:
Provider will be provided with application window form show in attached so no design is needed along with
all SQL Server tables.
It is highly recommended that the provider user use DevComponents software for the Charts. A full
functional trial version can be downloaded here – http://www.devcomponents.com/downloads.aspx.
Must be developed in C# and compatible with Visual Studio 2008
All source code must be at least unit tested.
All source code must be provided including any stored procedures when final milestone payment is made.
Must be developed using two tier application layer. All the SQL Server calls will be made in Data layer
called DAL. This will be provided.
Writing performance efficient code is critical for this window. This window must open within a 2 or 3
seconds.

The provider must have the following SKILLs and Experience.
1. C#, Windows Form
2. Proficient with SQL Server Scripting
3. Experience with charting
4. Experience with with pulling data from a website from a windws form and displaying text and link. RSS?

Tags: , , , , , , , , , , , , , , , ,

VISUAL FOXPRO – RE-WRITE ACTUAL PROJECT FROM DBF TO SQL

MUST RE-WRITE an ACTUAL PROJECT TO HAVE ACCESS FROM DBF TO POSTGREE SQL.

Tags: , , , , , , , , , , , , , , , ,

Q And A System

This project is to create a simple q&a system.
A zip file showing our file structure is included.
You will need to connect to our development database to retrieve user avatars and emails.
The project must be coded in vb.net.
You need to be conversant with vb, sql, and css.
The project is need in seven days time, so please only bid if you are able to work immediately.

Tags: , , , , , , , , , , , , , , ,

.Net, C#, AJAX, SQL Server 2005 – Freelancer ONLY

Looking for freelancer in Hyderabad to work on web based product. Freelancer need to travel to my location some times as required to understand the requirements.

Project screen design completed. Need to complete the functionality.

Must be based on Project completion.

send details to careers at parnanditech dot com.

Tags: , , , , , ,

Jaspersoft IReport SQL Designer/Writer

We are looking for a freelancer with a good, working knowledge on how to create a jaspersoft report that retrieves data from a ms-sql 2008 db over graphic elements and some static text. We may assign you several reports depending on your turnaround time and quality of work. You must be able to extract the visual elements from a PDF or PSD file, and dig into the SQL table to extract the structure. You will be given access to the SQL dev server. In return, you will provide the jrxml file, and may be asked to make changes and/or fix issues. We are using ireport v4.

In addition, we may provide you with working jasper reports that need either cosmetic adjustments or tweaking.

All are small to med complexity reports.
Please attach samples and short description of your experience and what you can do for us.

Tags: , , , , , ,

Outlook 2010 Addin To Enter Email Details Into SQL DB

Project for SUPERPT

This project is to create an Outlook 2010 addin that will extract information from an email and post certain information into our Helpdesk SQL database.

Full details to be sent

Tags: , , , , , ,

Excel Spreadsheet – Insert/Update SQL Server Not DBase

We currently have an Excel Spreadsheet which reads cells, then checks a foxpro dBase database if the data exists and if it doesnt, it inserts it into the FoxPro dBase Database.

The FoxPro dBase database has been REPLACED with a SQL Server 2005 instance and so the VBA must be adjusted to read the SQL Server Database.

Only 3 tables are inserted/updated in this process.

The changed VBA must therefor:

1) Setup the Connection to the SQL Server
2) Check is the record exists (as it does in the old code)
3) Depending if it exists, either insert or update (as it does in the old code)

This project is very very small. Changes are only expected in one 1 module.

Tags: , , , , , ,

New C# Window Form – Dashboard

This project is for development of a single window application form that will be used as a dashboard (home page) of a windows application. The window will consists of three panels each containing different information. This should be a very simple project and I have a provided alot details in the specification. No design is needed just code. As always, I will pay extra for design improvement suggestions that are used and suggestions that will improve performance efficienty.

Below is a summary of each PANEL.

Tags: , , , , , ,

Modify Google Base Feed (SQL Query) In Volusion

We are currently exporting our Google Base product data manually in Volusion. I would like to create a Saved Export with all the required columns and fields as required by Google.
Volusions Google Product Query only pulls the basic product info, i want to add all our already formatted columns to this query plus strip out all the uneccesary info from this query for $60

I would prefer a provider with some Volusion backend experience.

Tags: , , , , , ,

Php/JS/ajax Developer

Experienced php and javascript programmer to work on existing script and add some features.

Few hours of work for an expert programmer.

You must be able to

1)Work with procedural php code intermixed with html and sql(This is important).

2)Can code Ajax and javascript and write good sql.

3)Must have good understanding of security aspects and produce php code that is free of sql injection and xss attacks.

4)Can use svn

Type php/html/sql mix as first words in your bid.

You must have excellent work history and experience here.

This work will start today.

Probably as soon as i find the right developer.

Tags: , , , , , ,

Experienced Php And Javascript Programmer

Experienced php and javascript programmer to work on existing script and add some features.

Few hours of work for an expert programmer.

You must be able to

1)Work with procedural php code intermixed with html and sql(This is important).

2)Can code Ajax and javascript and write good sql.

3)Must have good understanding of security aspects and produce php code that is free of sql injection and xss attacks.

4)Can use svn

Type php/html/sql intermix as first words in your bid.

You must have excellent work history and experience here.

This work will start today.

Probably as soon as i find the right developer.

Tags: , , , , , ,

SSRS Project

We are seeking professional who are good at SSRS (SQL Server Reporting Service) in MSSQL 2008 R2.

Main tasks is to create dynamic reports(estimated 50 reports) and dashboards.(estimated 4 dashboards) with drill down capability.

We shall be providing you with our database schema and requirements.

We preferred to work on fix sum basis.

Tags: , , , , ,

ColdFusion MS SQL Expert Needed To Assist Documenting Of Com

I have an immediate need for an IT consultant with MS SQL and ColdFusion experience, as well as good verbal and written communication skills.

My situation is that Im buying out a business partner who has been in charge of all the IT and programming for our ecommerce company. Hes a talented programmer, and he coded our website/ business system from scratch almost single-handedly. While the system is running behind the times, and will likely be replaced in mid-future, it is currently doing a good job running our business. I also have one other IT employee that is a junior coder, who is also a talented team member, but not as experienced, who will continue to remain employed by the company.

The business and personal nature of the events surrounding the buyout of this partner makes his relationship with me and the company tenuous at best. He is a disgruntled employee who will be exiting the business in about a month, and I need to get as much information from him regarding an inventory of the intangible intellectual property he manages before he exits. The terms of the buyout are such that once he is paid in-full at the closing, he will walk away with no obligation to assist in the transfer of information or to train others on his responsibilities.

While hes now still employed with the company, as President of the company I have the right to take inventory of the companys intellectual assets, and he has the obligation to comply in providing that which he manages (I have legal counsel assisting with this matter). Since my skills in business are not in the areas of IT, Im seeking an expert with similar skills as those of my exiting partner who can assist me now in creating a list of information that I should obtain from my partner before he leaves, that would be needed by a future replacement and by the remaining junior IT employee.

I am seeking a senior ColdFusion, MS SQL IT expert to work with me on this hopefully as soon as tomorrow. The work will consist of phone conversations with me, as well as my junior IT employee, and creating the lists of what is needed such as passwords, source code, offsite storage, onsite files, and the like. Depending on how my partner does or does not comply, additional phone conferences may also include the exiting partner and my legal counsel where you would represent the opinion of the IT expert. Once the partner responds to our requests, you would be needed to review his deliverables, assess their sufficiency, and articulate further requests if needed, and continue this process until satisfied that we have documented what is needed to facilitate a reasonably smooth transition of his job position to someone else when such an individual is hired.

Provided this project goes well, I will also be in need of someone of your skills on an ongoing basis for part-time programming and consulting work which perhaps you could provide.

If you are interested in this work and available immediately, please contact me a.s.a.p. Please start your email with the exact phrase "Im a Coldfusion and MS SQL expert" so I know youve read this job posting in its entirety.

Thank you,

Andrew

Tags: , , , , , ,

PDF Form FIll

PDF Form Filler
USING: VS2005, VS2008, VS2010
SQL 2005, SQL 2008
I-TextSharp
I currently have a VS Project that will map database fields to PDF fields. The project uses I-TexSharp
I

Tags: , , , , , ,

SQL Expert For Data Migration Test Wanted!

You want to work for the business-model of the future? We offer data migration testing in Hong Kong for insurance companies in Europe. If you are an expert in SQL, very familiar with the English language and a reliable team player, then join our offshoring start-up now.

Tasks:

o Understanding conversion rules from migration specification documents in the English language
o Comparing data from two data bases via programming migration/conversion rules in SQL
o Reporting and tracking migration/conversion errors in the English language
o Being a team player and helping colleagues by sharing your experience

You want to join? Our customers in Europe are waiting, so contact us now!

Tags: , , , , , ,

PSD Slicing And HTML Markup/MS-SQL

Our product is a personalised children

Tags: , , , , , ,

Web Application – XML Import To SQL Server DB

Requirement is for the import of a large (45mb) XML file into a SQL Server database. The web application will be coded in VB.NET and have 2 main components.

1) An upload facility for the XML file, with a visible progress bar indication. Speed of upload is not a major issue but most efficient mode of upload for a file this size is preferred. the client will simply browse to tthe file and click upload and see upload progress and complettion with any error message if not uploaded for some reason.

2) Extraction of the appropriate XML data and adding to the corrersponding SQL Server database fields.
This will require a check to identify new records and only add these to the database.

XML & DB sample can be provided.

This has to be in VB.NET.

Tags: , , , , , ,

Web Application – XML Import To SQL Server DB

Requirement is for the import of a large (45mb) XML file into a SQL Server database. The web application will be coded in VB.NET and have 2 main components.

1) An upload facility for the XML file, with a visible progress bar indication. Speed of upload is not a major issue but most efficient mode of upload for a file this size is preferred. the client will simply browse to tthe file and click upload and see upload progress and complettion with any error message if not uploaded for some reason.

2) Extraction of the appropriate XML data and adding to the corrersponding SQL Server database fields.
This will require a check to identify new records and only add these to the database.

XML & DB sample can be provided.

This has to be in VB.NET.

Tags: , , , , , ,

Web Application – XML Import To DB

Requirement is for the import of a large (45mb) XML file into a SQL Server database. The web application will be coded in VB.NET and have 2 main components.

1) An upload facility for the XML file, with a visible progress bar indication. Speed of upload is not a major issue but most efficient mode of upload for a file this size is preferred. the client will simply browse to tthe file and click upload and see upload progress and complettion with any error message if not uploaded for some reason.

2) Extraction of the appropriate XML data and adding to the corrersponding SQL Server database fields.
This will require a check to identify new records and only add these to the database.

XML & DB sample can be provided.

This has to be in VB.NET.

Tags: , , , , , ,

SQL Back End/ACCESS Front End Needs Work

ACCESS/SQL
1.A way to deselect all customers or show select as a number not yes or no.
2.I cant create a new product without an error coming up.
3.When I try to delete a song product is comes up with an error.
4.Unsent and Unprinted should be in date ordered order. Starting with the oldest.
5.Make the OMS startup and operation faster and operate faster over the network. One eg.Typing a school name can now take a while to start (before it was fine).
6.Get backup working, script fails because mapped drive letter keeps disappearing.
7.When stock taking, a note warning if there are any unsent invoice with that component in it.
8.All emails appear in customer search
9.Cant change printer after printed (locked).
10.When adding a new song title to a component, it should automatically put that component code in the CompCode column.
11.A warning when someone trys to change a delivery from the past."Are you sure you want to change this delivery record from a previous day? Y/N "
12.A form that allows me to move any products in a single parent directory to a new SeqNumber. Basically so I can see all the products in that parent directory and move any one of them with ease.
13.Invoice imput (when another person is starting a new invoice) your invoice can jump to another when you add a product.

Tags: , , , , , ,

Daily Deal Web Site (Like Groupon)

# group buying platform in ASP.NET 3.5 + SQL Server 2008
# newsletter through mailchimp.com
# payment gateways trough bank of choice + PayPal
# pushing deal throughfacebook + twitter
# facebook like box
# support for online (url) + offline (printed coupons) affiliation
# deal RSS
# full CMS
# communication forms for cooperation with other companies
# creation of coupons in PDF
# intagration of Google Maps for daily Deal location
# reports + coupon list for partners
# Backend system for management of deals, users, affiliations, orders etc
# support for CAPTCHA in all forms

Tags: , , , , , ,

.NET Expert For Threaded Application Development

I am looking for absolute experts with experience in developing threaded web-applications in .NET

I need somebody with hands-on experience with managing and optimizing thread pools on an application and DB level. I have multiple ongoing projects in .NET 4.0 + SQL server for the right candidate. Currently I have an application that needs to be debugged and optimized to handle very high volume transactions and incoming requests and manage the thread pool effectively

Please submit details of your experience in this area via PMB

Tags: , , , , , ,

SQL Server 2008 Replication

Hi

I am looking for someone with prior experience to configure transactional replication between 2 SQL 2008 R2 Servers running on 2 non-domain Windows 2008 servers located within the same data facility.

This is a one time project that can lead to additional DBA work for whomever successfully completes the project. A staging area can be provided so you can run tests without touching the live production data until you are ready.

Please send information about past database work, specifically about prior replication work and a summary of what steps will be involved in completing this task.

Tags: , , , , , ,

DB Sync Between SQL Server And MySQL

Hello,

Im looking for someone that is capable to code a synchronization app that gathers the DB info from a MySQL server or XML and synchronizes with a local installed SQL server (version 2005).

The synchronization app should have the following functions:
– Schedule tasks.
– Setup of both connections to the servers.
– Set which DB is the master or define if its updated by the older DB.
– Merge data in case of changes in both DB.
– Log of errors.
– Set the scheme of the DB we want to update, so we can later use in others DB.
– Work in Windows XP, Vista, 7 and Server 2000

Before when you bid please include:
– Your price.
– Time to complete the project.
– Your portfolio.
– The language you will be using to code this software.

Thank you

Tags: , , , , , ,