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.
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
<cfquery name="Query#Number#" datasource="#DSN#" result="AuthorsInsert">
INSERT INTO AUTHORS (FirstName, LastName) VALUES('Forta','Ben')
<cfset Number=#Number# + 1>
BID with confidence if you are good at SQL scripts,MS SQL SERVER PORTING and database.
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 Fazla
Bu iş için 14 freelancer ortalamada $88 teklif veriyor
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.
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
Hi, Gladguy. I am confident about Access and MSSQL. I can handle it. Please provide in details. Thank you
i have more than 10 years of exp in Database and Data Warehouse tools and technologies. please shar the details thorugh PM asap
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 Fazla
I have a good experience in copying Access to MSSQL databases. See PMB.
i have read and understand your requirements and i m ready to give my best..so what are we waiting for lets get started.
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 Fazla
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