Devam Ediyor

MS -ACCESS TO MS SQL SERVER CONVERSION

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.

Beceriler: ColdFusion, Microsoft Access, MySQL, SQL

Daha fazlasını görün: sql data conversion, so ben, server scripts, data conversion sql, c.c. enterprises, bit problem, t-sql with, t-sql in, sql experience, ms access sql, boolean sql server, ms access 2010, t-sql;, SQL Server, sql server scripts, sql server c, sql script , sql import, SQL Access, MS SQL, ms access, ms access database with scripts 2, mdb, import sql, image conversion

İşveren Hakkında:
( 5 değerlendirme ) Abudhabi, United Arab Emirates

Proje NO: #712281

Seçilen:

ITStone

Hi, I have 5+ years' experiences in enterprise application development, and family with SQL, SQL Server 2000, ACCESS, ORACLE, MYSQL, HQLDB and some other databases, I could accomplish this for you. Please send m Daha fazlası

2 gün içinde 40$ USD
(2 Değerlendirme)
1.2

14 freelancers are bidding on average $88 for this job

mastersact

Sir, I have vast experience working on migration of systems to SQL Server. I can wrap up this task in a day with all requirements you asked for. Please see PMB for details and consider my bid. Thanks & Regards.

1 gün içinde 50$ USD
(2 Değerlendirme)
3.2
adarshnagaraj

Hi I have extensive experience in MS SQL Server right from v7.0 to 2008. I have done DB import between Access and SQL server many a times. Please check PMB. Regards

in 2 gün içinde100$ USD
(1 Değerlendirme)
1.6
mobzdesign

please check PMB for details, Thank you

in 3 gün içinde150$ USD
(0 Değerlendirme)
0.0
snehweb

We have expertise in this type project

in 5 gün içinde150$ USD
(0 Değerlendirme)
0.0
Carlin4J

Hi, Gladguy. I am confident about Access and MSSQL. I can handle it. Please provide in details. Thank you

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
punshar71

i have more than 10 years of exp in Database and Data Warehouse tools and technologies. please shar the details thorugh PM asap

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0
paleboyeh

Hi, I am a dba with an experience of over 12 years with MS and non MS databases. The migration which you want to do is absolutely trivial and there are a lot of tools even from Microsft itself which you can use to a Daha fazlası

1 gün içinde 145$ USD
(0 Değerlendirme)
0.0
Vetall

I have a good experience in copying Access to MSSQL databases. See PMB.

in 3 gün içinde50$ USD
(0 Değerlendirme)
0.0
zorkifprog1

i have read and understand your requirements and i m ready to give my best..so what are we waiting for lets get started.

in 6 gün içinde90$ USD
(0 Değerlendirme)
0.0
mikericz

I have read your project posted, and it is interesting. I am an experienced programmer. I have been working with MS Access and MSSQL Server for some years. Please consider my bid. I will do my best for the project. Tha Daha fazlası

in 2 gün içinde100$ USD
(0 Değerlendirme)
0.0
amb2005shl

I can work for you

in 4 gün içinde40$ USD
(0 Değerlendirme)
0.0
MKHASAN32

I need work. Thanks

in 27 gün içinde31$ USD
(0 Değerlendirme)
0.0
BunbacGabriel

I have more then 12 years IT experience. I am MCTS SQL Server 2005. For more information look at my site: [url removed, login to view] Best Regards, Gabriel

1 gün içinde 87$ USD
(0 Değerlendirme)
1.4