MySQL - SQL Server Conversion

Budget $100 - $500 USD
Bids 7
Average Bid $196

We have a database in MySQL with 15 tables. Each table has various records, indexes, primary/foreign keys, etc.

We need to convert this to SQL Server and also add the necessary stored procedures to insert/retreive data into the tables.

To do this we need:

i) Each of the 15 tables converted to MSSQL Server (2000)
ii) Tables are interlinked (ie: value in one column may reference fk in another table)
iii) We need 4 stored procedures to retreive data data from the tables. These sp's must retreive all data
iv) We need and additional 4 stored proecures to retrieve data from the tables. These take on various parameters and only records matching the restrictions must be returned
v) We need an additional 4 stored procedures to insert data into the database.
vi) Note there will be small differences when converting from the MYSQL database to the SQL database. For example, in MYSQL one column current references another fk - in the converted there may not be an fk and it is just a regular in column. All discrepencies will be clearly documented upon project awarding.


Deliverables must be delivered upon completion in the following order:

i) SQL script to setup tables

ii) SQL script for sp's to create data

iii) Test sql script to insert data into the database. For the purpose of testing, 1000 rows must be inserted into each table

iv) SQL script for sp to get data

v) For the purpose of testing, 50 rows for each table must be retreived with various parameters




## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.


2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

MySQL


SQLServer

- All SQL scripts must execute free of errors + warnings

- All SQL scripts to follow a very explicit naming convetion

- All SQL scripts to assume current user logged in will own objects

* * * IMPORTANT - We need a document (IN WORD) which outlines explicitly how to use each stored procedures, valid parameters & return values

Post a Project Like This

This project was awarded to

SebastianSDS

Sebastian pretty much managed this project among others quite well. We were pretty demanding with the small details but he understood what we wanted and delivered within a reasonable amount of time. Since he know understands our system we hope to use him in the future and he truly deserved the 10 plus some bonus cash for going beyond the original specifications. His now loads our inventory of nearly 200,000 item in less than 15 minutes. This used to take days. Thanks, Media PitStop
About the Freelancer
SebastianSDS Profile Picture

BIO ForeignLanguages: .....FluentEnglish .....FluentItalian Description: .....Hi, my name is IacobSebastian and I'm a senior programmer. I have over 12 years inprogramming using various technologies. Also, because I was ateam leader, and after that a softwarearchitect for some years, I managed to get a lot ofexperience inaproachinglarge projectswith greatconsideration for details. .....I have years ofexperience in building all kind of backend applications like ERP,CRM, PIM,Inventory Management Software, Email MarketingApplication, etc. Myapplications are based on simplicity,easy to use, professional look and latest technologiesuse. .....My customers areacting in a wide area of activity, from real estate business tosuccess ebay power sellers. Many of them keep asking for myservices because they were pleased by my?€œcan-do?€way of see things and my will to offer thebest to my customers, the same will they have fortheir own customers. .....I?€™mseeking more challenging projects to develop, and probably my bidon your project will not be the most affordable. Anyway, if you areseeking for a coder that can take your business to the nextlevel, you should consider hiring me. .....Thanks for taking the time to read my resume, Iacob Sebastian Area of Expertise ExperienceWith: Google Maps, Geocoder, Geocache ATLAS ( ASP.NET AJAX Framework ) Netsuite API, Netsuite SMBXML, NetsuiteAuthentification, Netsuite System-To-System Auctionworks(Marketworks) interface,API Storefront.NET skinning, code customisation, allversions. AspDotNetStorefront skinning, XMLPackages,instalation , full codecustomisation,upgrade, allversions up to ML 7(.NET 2.0). Examples:www.azjewel.com (http://www.azjewel.com) www.bestbrands4less.com (http://www.bestbrands4less.com)www.skyranchgear.net (http://www.skyranchgear.net/) DotNetNuke Authorize.Net, Paypal, 2checkout, GoogleCheckout Oscommerce Microsoft Log Parser Symbol devices and SDK(smart devices with RFID,magnetic and barcode readers) Proactive devices and SDK(smart devices withRFID readers) CSK Storefront (.NET free storefront frompaypal) Community Server integration and SDK Dundas Charts Ebay Many others, just ask WebProgramming/Scripting Languages: ASP.NET 1.0, 1.1, 2.0 ASP PHP, Perl, Pyton Java Script Action Script(Flash) HTML, XHTML, DHTML CSS 1.0, 2.0 XML, XSLT, XPath Crystal Reports, Active Reports, etc AJAX MiscProgramming/Scripting Languages: .NET(1.0, 1.1, 2.0): (C#.NET, VB.NET,ASP.NET) ADO.NET(Ole DB, SqlClient, Oracle Client, Sqlbulk copy classes, ODBC) Windows Forms(MFC) Web Forms (ASP.NET) TCP/IP, UDP Remoting.NET XML (DOM, XSLT, XPath), Windows Services Web Services(SOAP, WSDL, DISCO, UDDI, WSE3.0) Threading MSMQ C++ VB6 VBA Java Pascal FoxPro and Visual FoxPro Database engines: SqlServer 2000 (MSDE, Personal, Standard,Enterprise) Reporting Services Optimisations Index Tunning Full text indexing DTS RDBMS Database Planning Sql Server 2005 MS Access 97/2000/XP/2003 .NET MySQL Oracle FoxPro Sybase dBase Administering: Windows 2000 Server(Standard, Enterprise),Windows 2003 (Standard , Enterprise) IIS installing and configuration Memory tunning Web sites instalation Database engines instalation andconfiguration Linux

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • lovleetvw Profile Picture

    lovleetvw

    India

    ## BIO Hi, I (Lovleet Jain) am the representative of Anchalia Systems. Anchalia Systems have the team of fully qualified IT professionals, who are dedicated to provide you the right solution, on time. We have a lot of experience in business application using client-server technology in VFP, VB.net, ASP.net, Access, PHP, MySql and SQL server 2000. We ensure you for giving all type of support after the delivery. We ensure you to give quick response in 24 hours in case you have any problem in our project. We are available 24/7 for any discuusion. We like to build ***long term relations***with our clients, so we would perform our best for our current as well as our prospective clients. We also provide good support for our already done jobs. Thanks for your time, for reading this. Our Team is Certified by the following MCSD, MCM, B.E., B.Com, etc. ## Area of Expertise <table cellspacing="1" cellpadding="0" width="100%" bgcolor= "silver" border="0"> </table>

    PHP, Perl, ASP, and C Programming

  • tylerfreevw Profile Picture

    tylerfreevw

    United States

    ## BIO I have been a computer programmer for over 15 years and I enjoy it thoroughly. Most recently I was Project Lead for a Water Quality Management System provided for a State Government. I have 3 goals for every project: * **Usability** - The best written software is useless unless it fulfills the needs of the client. I strive to ensure usability by: - Making sure that I fully understand the requirements. - Never sacrifice quality, ever. - Maintain frequent communication through project lifecycle (iterative design). * **Reliability** - No program is perfect, but some are less so than others. I take the following steps to provide reliability: - Unit Testing. Once the code is written I will test it against the spec's using a unit test procedure to ensure it operates as required. - Error Handling. I use "best practice" methods for trapping and handling error's to ensure that unexpected events are handled as "gracefully" as can be, and according to the specifications (i.e., logged, popup message, email notification, etc.). - Support. I stand behind what I write, and promise to provide one full year of support for anything that I have written, in a prompt and professional manner. * **Maintainability** - Because code written by one author often ends up being maintained by another, it is important (and considerate) to make code as maintable as possible. I will provide maintainability as follows: - Notation. I will use the "best practice" method applicable to the language that I am codeing in. For VB (6.0 and earlier) I will use hungarian notation. For C# or other .NET languages I will use Camel notation for variables, Pascal notation for methods. - Formatting. White space and indenting will be used as appropriate for code readability. - Inline Comments. All code will include inline comments as applicable to document program flow and descriptions of processing. ## Area of Expertise **Visual Studio .NET -** C#, VB.Net, ASP.Net, Web Services, Web Forms, et al. I have written several applications in .Net and converted others. I have developed Template Based websites, Web User Controls, Data Access classes, Business Objects, and Others. .Net is a powerful tool, and much can be accomplished with it, in a rapid fashion. I currently use Visual Studio .NET 2003. **Visual Studio 6.0 -** VB is one of my greatest strengths. Until the advent of .NET, VB was arguably the most versatile of the RAD tools available, and proved to be able to do just about anything. I have written Windows Controls (OCX's), middle tier class libraries (ActiveX DLL's), Add-Ins, MMC Snap-Ins, Out-of-process servers, full blown forms based applications and administration tools. **ASP-** I've used Visual Interdev to develop several web based applications. I am very familiar with ASP, and have used the following technologies with it: XML (MSXML Dom), XSLT, vbscript, java script, HTML, DHTML etc. **SQL Server 2000 -** SQL Server has been the back end for a number of applications that I have worked on. I am extremely familiar with writing stored proc's, views, and udf's. I am comfortable with both Enterprise Manager, and Query Analyzer and the command line tool OSQL. **Other Technologies -** I am an experienced DOS batch file writer and familiar with the command line interfaces for SQL, SourceSafe, ClearCase and others. I have used a number of different proprietary script languages and I am adept at learning new skills and languages. **Tools/Software -** Crystal Reports, Rational Rose, XML Spy, Visio, MS Office

    PHP, Perl, ASP, and C Programming

  • SebastianSDS Profile Picture

    SebastianSDS

    Romania

    BIO ForeignLanguages: .....FluentEnglish .....FluentItalian Description: .....Hi, my name is IacobSebastian and I'm a senior programmer. I have over 12 years inprogramming using various technologies. Also, because I was ateam leader, and after that a softwarearchitect for some years, I managed to get a lot ofexperience inaproachinglarge projectswith greatconsideration for details. .....I have years ofexperience in building all kind of backend applications like ERP,CRM, PIM,Inventory Management Software, Email MarketingApplication, etc. Myapplications are based on simplicity,easy to use, professional look and latest technologiesuse. .....My customers areacting in a wide area of activity, from real estate business tosuccess ebay power sellers. Many of them keep asking for myservices because they were pleased by my?€œcan-do?€way of see things and my will to offer thebest to my customers, the same will they have fortheir own customers. .....I?€™mseeking more challenging projects to develop, and probably my bidon your project will not be the most affordable. Anyway, if you areseeking for a coder that can take your business to the nextlevel, you should consider hiring me. .....Thanks for taking the time to read my resume, Iacob Sebastian Area of Expertise ExperienceWith: Google Maps, Geocoder, Geocache ATLAS ( ASP.NET AJAX Framework ) Netsuite API, Netsuite SMBXML, NetsuiteAuthentification, Netsuite System-To-System Auctionworks(Marketworks) interface,API Storefront.NET skinning, code customisation, allversions. AspDotNetStorefront skinning, XMLPackages,instalation , full codecustomisation,upgrade, allversions up to ML 7(.NET 2.0). Examples:www.azjewel.com (http://www.azjewel.com) www.bestbrands4less.com (http://www.bestbrands4less.com)www.skyranchgear.net (http://www.skyranchgear.net/) DotNetNuke Authorize.Net, Paypal, 2checkout, GoogleCheckout Oscommerce Microsoft Log Parser Symbol devices and SDK(smart devices with RFID,magnetic and barcode readers) Proactive devices and SDK(smart devices withRFID readers) CSK Storefront (.NET free storefront frompaypal) Community Server integration and SDK Dundas Charts Ebay Many others, just ask WebProgramming/Scripting Languages: ASP.NET 1.0, 1.1, 2.0 ASP PHP, Perl, Pyton Java Script Action Script(Flash) HTML, XHTML, DHTML CSS 1.0, 2.0 XML, XSLT, XPath Crystal Reports, Active Reports, etc AJAX MiscProgramming/Scripting Languages: .NET(1.0, 1.1, 2.0): (C#.NET, VB.NET,ASP.NET) ADO.NET(Ole DB, SqlClient, Oracle Client, Sqlbulk copy classes, ODBC) Windows Forms(MFC) Web Forms (ASP.NET) TCP/IP, UDP Remoting.NET XML (DOM, XSLT, XPath), Windows Services Web Services(SOAP, WSDL, DISCO, UDDI, WSE3.0) Threading MSMQ C++ VB6 VBA Java Pascal FoxPro and Visual FoxPro Database engines: SqlServer 2000 (MSDE, Personal, Standard,Enterprise) Reporting Services Optimisations Index Tunning Full text indexing DTS RDBMS Database Planning Sql Server 2005 MS Access 97/2000/XP/2003 .NET MySQL Oracle FoxPro Sybase dBase Administering: Windows 2000 Server(Standard, Enterprise),Windows 2003 (Standard , Enterprise) IIS installing and configuration Memory tunning Web sites instalation Database engines instalation andconfiguration Linux

    PHP, Logo Design, Web Security, and Delphi

  • jeivw Profile Picture

    jeivw

    Bulgaria

    ## BIO We are hi-technology software development company working in the field of Database development and Management Information Solutions, WEB-based data processing systems, ActiveX and COM components development. We are in database business from 14 years. We are specialized in database development with Microsoft products: Visual Studio (Visual FoxPro (All versions), Visual Studio.Net(All versions) and Back Office (Win NT/2000, SQL Server, Exchange Server , IIS and etc.) as well as in implementing WEB solutions using technologies like ASP.NET, XML/XSLT and ISAPI/COM+. We already have experience in development of insurance, financial, real estate, POS, billing, accounting, inventory, warehouse application. We develop projects off-site or partially off-site and software support we do via Internet. Our talented programmers will satisfy your requirements. 25% of stuff is involved in Research and Development of new technologies, which keep us on the top of the software development. Combination of new technologies with experienced database architects and developers is guarantee for reliable design. ## Area of Expertise * Databases * Visual FoxPro * SQLServer * Oracle * MySQL * PostgreSQL * .NET Framework and related * Visual C# * Visual Basic.NET * .NET Toolkit for Visual FoxPro * .NET/COM interoperability * Web development * PHP * ASP * ASP.NET * ISAPI extensions * XML/XSLT * DHTML, xHTML, HTML5 * CSS * Solutions portfolio * insurance * financial services and accounting * real estate * POS and billing * inventory and warehouse

    PHP, Perl, ASP, and C Programming

  • ixyst Profile Picture

    ixyst

    Singapore

    ## BIO Bio

    PHP, Perl, ASP, and C Programming

  • altiusecrea Profile Picture

    altiusecrea

    India

    ## BIO Altius e Creations has expertise in developing web portals,sites and application software using current technologies,creating and developing flash objects and hi tech animations. Our company has an excellent software development and web solution team. ## Area of Expertise ***Our Skills and Experiences * Web development ** Portals,PHP, Perl, and ASP scripting for web sites,High tech Flash Intros and sites. HTML, including DHTML, CSS, and SSI. XML with PHP JavaScript,JScript, and VBScript. **Extensive, current experience with the following programs and technologies: **ASP,PHP Macromedia Dreamweaver Adobe Photoshop 3D Studio Max Flash Flash MX Corel Draw **Programming and Technology Experience Extensive, current experience with the following programming languages, compilers, and API's: **Microsoft Visual C++ Borland C++ Java C Foxpro Sybase, Access and MySQL databases. Microsoft Visual Basic. BASH shell scripting(Linux/Unix).and Vi editor under Linux and unix          

    PHP, Perl, ASP, and C Programming

  • syskonvw Profile Picture

    syskonvw

    United States

    ## BIO Hello ## Area of Expertise All platforms

    PHP, ASP, Engineering, and SQL