Closed

MS -ACCESS TO MS SQL SERVER CONVERSION

This project was awarded to ITStone for $40 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $250 USD
Total Bids
14
Project Description

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.
Details

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.

FOR EXAMPLE :
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.

YOU CAN DO THIS IF YOU HAVE SQL ENTERPRISES EXPERIENCE IMPORT FROM MS ACCESS

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
Eg : IN MS SQL SERVER
STEP1: CustomerID INT
STEP2: AFTER SECOND SCRIPT CUSTOMERID WILL HAVE DATA COPIED FROM MS ACCESS TABLE
STEP3: SET THE CUSTOMER ID AS PRIMARY KEY AND AUTOINCREMENT WITH 1


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')
</cfquery>
<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.

Looking to make some money?

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

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online