Hi All,

I am working on databse migaration assignment, we are using MS accesss 2003 database and planing to moving to SQL Server 2000, but I have got some really difficult problems

for examples,

Date format is totally different in Access like yy/mm/dd
Some of the fields in table are combination of two or more primry key
Blanks and empty fields

Any idea or suggestion to move every thing with out losing my job

;)
regards
Ayaz

First move the data as it is from the access database them do your clean up on the SQL 200 database. In the case of the date, if is a valid date you can change the format. For example, to convert your date you can update the column like this
CONVERT ( datetime ( 12 ) ] , yourdatecolumnhere [ , 101 )


Jaime E. Maccou

would it make any difference if company use MSAccess for frontend and SQL behind any technical issues

you should not have any issues as far as the database is concerned. are you using access adp or using an odbc connection on the access front end.

Jaime E. Maccou