MS -ACCESS TO MS SQL SERVER CONVERSION

IN PROGRESS
Bids
14
Avg Bid (USD)
$88
Project Budget (USD)
$30 - $250

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 problem.And 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 also.We 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.

Skills required:
Cold Fusion, Microsoft Access, MySQL, SQL
Hire gladguy
Project posted by:
gladguy United Arab Emirates
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire mastersact
$ 50
in 1 days
Hire adarshnagaraj
$ 100
in 2 days
Hire ITStone
$ 40
in 2 days
Hire MKHASAN32
$ 31
in 27 days
Hire Carlin4J
$ 100
in 3 days
Hire BunbacGabriel
$ 87
in 1 days
Hire snehweb
$ 150
in 5 days
Hire amb2005shl
$ 40
in 4 days
Hire mikericz
$ 100
in 2 days
Hire paleboyeh
$ 145
in 1 days