Budget $30 - $250 USD
Bids 14
Average Bid $88
Status Closed

We have MS Access MDB file with 20 tables with AutoNumber fields and other standard fields like bit,boolean,varchar,double,integer (no image fields so don't worry) and important data in it.

We need SQL from the MS ACCESS TABLE compatiable for MS SQL SERVER.


SQL Script 1 : When i run the sql it should create the tables with autonumber-autoincrement field and all other fields should be relavant to ms sql server(varchar,bit,boolean etc) MS Access fields data should go and sit in MS SQL Server table without any problem.


MS Access Table CUSTOMERID is an AUTONUMBER FIELD in MS SQL SERVER it should be autoincrement field

SQL Script 2 : When i run sql it should copy the data from MS Access to MS SQL Server with out any [url removed, login to view] also data should be appropriate with relations.

For Example :

IF in MS ACCESS CUSTOMERID is 25 then it should be CUSTOMERID 25 in ms sql server also and that field should be auto increment [url removed, login to view] dont need incrementing with script.


So, we need to create the table script without autoincrement field and

then after adding all the data with second script we should make the primary key and set autoincrement field


STEP1: CustomerID INT



Then each insert,create,alter query should be in this format

From here


<cfquery name="Query#Number#" datasource="#DSN#" result="AuthorsInsert">

INSERT INTO AUTHORS (FirstName, LastName) VALUES('Forta','Ben')


<cfdump var="#AuthorsInsert#">

<cfset Number=#Number# + 1>


Upto here

BID with confidence if you are good at SQL scripts,MS SQL SERVER PORTING and database.

Get Free Quotes For A Project Like This

This project was awarded to


This worker get all credits he can get. He really did everything I asked for. I am very happy with the work and will use him again. A++++++++++++++++++++++++++++++++
About the Freelancer
ITStone Profile Picture

I have over 5 years' experience in JAVA/J2EE, work as a Sr. software engineer & team leader in a insurance core system/software provider company. Additionally, I am also interested in Android platform, and family with Android application development relevant API, skills.

Looking to make some money?

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

Bids on this Project

  • adarshnagaraj Profile Picture


    Bangalore,  India

    o An IT professional with over 12 years of experience in all facets of software development life cycle, from initial conceptual design and development through testing, implementation and enhancements. o Extensive experience in Microsoft Technologies - VB.Net, C#, ASP.Net, Web Services, Winforms, SQL Server 2000-2008, Reporting Services, Visual Basic 6.0, ADO/ADO.Net, ActiveX, COM/DCOM, COM+/MSMQ, VBScript, VBA, Crystal Reports and MS-Access. Extensive knowledge in .Net development best practices like FxCop and Enterprise Application block. o Good understanding of OOAD, Dependency injection and patterns such as MVP. o Good Domain Knowledge of US/UK HealthCare Industry (Medical Coding, ICD, CPT,, EMR, HL7, HIPAA)

  • BunbacGabriel Profile Picture


    Constanta,  Romania

    Gabriel Teodor Bunbac Sharepoint Administrator Personal informations Birth date: 01-03-1976; Married status: married; Military status: done; Driver licence: B category. Profile Sharepoint Administrator: Microsoft Office SharePoint Server 2007, Microsoft SharePoint Portal Server 2003, Microsoft SharePoint Portal Server 2001, PI; C#, ASP.NET, Microsoft Visual Basic programmer. Data Base administrator and developer in Microsoft SQL, Microsoft Access; ISP System Engineer; Hardware Specialist. Education background 1999-2000 Politehnica University Bucharest Master - Advanced Automatic and Electric Engineer with 10 (range 1-10); 1994-1999 Politehnica University Bucharest System Science Engineer graduated the Automatic Control and Computer Science with 8.50 (range 1-10); 1990-1994 High School "TRAIAN" Constanta I graduated the High School “TRAIAN”, mathematics – physics section with 7.76 (range 1-10). Objectives Developing my knowledge in APPLICATION ADMINISTRTION, ISP SYSTEM ENGINEER, PROGRAMMER, DATA BASE ADMINISTRATOR AND DEVELOPER and GIS; Improving continuously my technical skills in all the domains based on every kind of IT solutions. Experience February 2007 – Rompetrol S.A. (Constanta) * I Install, configure and administrate remote the SharePoint Portal Server 2007 and Windows SharePoint Services 3.0 applications, Forefront, IIS, Microsoft SQL 2005 from production (8 servers) and test farms. The objective is to make them more reliable, optimized, secure and maintaining high availability to 98%; * I Install, configure and support remote Sharepoint 2001, Sharepoint 2003, PI; * I migrated Sharepoint 2003 to Sharepoint 2007; * I Trouble shoot application issues; * I Assist business users in the creation and management of their team sites; * I Work with other IT team members and business customers on SharePoint projects. February 2004 – February 2007 Impromex (Constanta) * I install and administrate equipments: Cisco, Telindus, Port Master3, Allied Telesyn; * I install and administrate internet lines; * I administrate servers: mail, dns, traffic, alert; * I install and administrate PBX units: Samsung IDCS500; * I develop applications in Microsoft Visual Basic, C#, ASP.NET and having as support Microsoft SQL, MySQL, Microsoft Access data bases; * I install and administrate computer networks; * I perform computers, networks, printers. November 1999 – February 2004 Mann Data Connection (Constanta) * I develop applications in Microsoft Visual Basic, C# and having as support Microsoft SQL, MySQL, Microsoft Access data bases; * I install and administrate computer networks; * I perform computers, networks, printers service; * I teach Microsoft Visual Basic programming and Microsoft Access data bases courses. May 1998 – November 1999 SoftChim S.A. (Bucharest) * I developed visual applications under Windows System based on Client/Server technology using Microsoft Visual Basic 6.0; * I have had experience in using Microsoft products creating Data Base applications (Microsoft Access, Microsoft SQL ); * I created a Client/Server application for data acquisition of an industry installation using National Instruments equipment; * I developed GIS applications on Autodesk World2 platform using VBA; * I used Arcview; * I made WEB pages; * I taught courses for beginners in IT: general information about computers (HARDWARE), about Windows 95 operating system and about all Microsoft Office 97 applications; * I administrated 16 stations of Windows NT network. January 1998 – May 1998 Extreme System (Constanta) * Hardware specialist (Service, Troubleshooting); * Network installation and administration; June 1996 – August 1996 Altair Soft (Constanta) * Assembling computers and installing networks (Windows ’95, Windows NT). Knowledge * Applications: Microsoft Sharepoint Server 2007/2003/2001, PI; * Programmer languages: - C#, ASP.NET; - Microsoft Visual Basic (4.0, 5.0, 6.0); - Borland Pascal; - Borland C/C++ ; - Assembler (Intel x86); * Data Bases: Microsoft SQL Server, MySql, Microsoft Access; * Operating Systems: Windows XP/2000/NT/98/95/3.11, Linux; * ISP: Cisco, Telindus, Port Master3, Allied Telesyn; * PBX units: Samsung IDCS500; * GIS applications: Autodesk World2, Arcview; * Graphic editors: Corel Draw, Adobe PhotoShop, Paint Shop Pro; * DTP systems: MS-Office, WordPerfect, QuarkXpress; * Internet WEB pages designer; * Electronics. Awards * 70-631 - MCTS: Windows SharePoint Services 3.0, Configuring; * 70-630 - MCTS: Microsoft Office SharePoint Server 2007, Configuring; * 5060A - Implementing Microsoft Windows SharePoint Services 3.0 (course); * 5061 - Implementing Microsoft Office SharePoint Server 2007 (course); * Accelerated Training for Database Administrators - SQL Server 2005 * MOC 2780 Maintaining a Microsoft SQL Server 2005 Database; And selected modules from the courses: * 2786: Designing a Microsoft SQL Server 2005 Infrastructure * 2787: Designing Security for Microsoft SQL Server 2005 * 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 * 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services * 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 * I won an award at Scientific Communication in 1999 with a graphical interface programmed in Object Oriented Programming based on Client/Server technology witch collected data from an industrial installation through a National Instruments data acquisition board. Foreign languages * English: advanced; * French: medium. Hobbies * Climbing; * Mounting Excursion; * Karate; * Bridge. * Lecture.

  • mastersact Profile Picture


    Delhi,  India

  • MKHASAN32 Profile Picture


    Dhaka,  Bangladesh

  • amb2005shl Profile Picture


    Faridabad,  India

    We are a web design, web development, Mobile Application Development, eCommerce, e-Learning Portal, Job Portal, graphic and logo design solutions Company based in India, We offer complete range of web technology related services providing our customers and enabling them to compete in the revolutionary e-Business arena. Our main service areas are: . Website Design and Development. . Graphic designing. . PHP Development. . E-Commerce Solutions. . Content Management Systems . Custom Web Application development. . Web Hosting & Domain Booking. . Search Engine Optimization. . Applications Development. Coding: - CSS3 / HTML / HTML 5 , PHP, , c# - Mobile Site Development Design: - PSD or PDF or JPG Conversion to HTML & CSS Template - Web Design Looking forward to hear you soon. Your Success Is Our Goal.

  • mikericz Profile Picture


    Valencia,  Philippines

  • zorkifprog1 Profile Picture


    Peshawar,  Pakistan

  • ITStone Profile Picture


    Shanghai,  China

    I have over 5 years' experience in JAVA/J2EE, work as a Sr. software engineer & team leader in a insurance core system/software provider company. Additionally, I am also interested in Android platform, and family with Android application development relevant API, skills.

  • Vetall Profile Picture


    Kharkov,  Ukraine

  • paleboyeh Profile Picture


    London,  United Kingdom