April 23, 2007 at 7:41 am
Hi All,
I have to migrate MS Access 2003 to SQL server 2000 but I've few problems
like I want to know any concern about data loss
becuase few of the access table uses different date and time format
different functions and modules difference between both these data bases
just reminding that my company will use Access form as a front end for ever till day of judgement
any suggestion and help
Regards
Ayaz
April 23, 2007 at 11:11 am
You don't have to worry about date "format". A date is not really stored the way it looks to the user anyway. The main problem you will have as far as dates will be that some dates that might be entered incorrectly in Access will not import into SQL Server -- such as 1/1/1000 .
If you will be using linked tables, you can probably use the same Access functions and modules.
I'm not saying you won't have any problems, you might, and you need to do lots oftesting. One thing you should really watch out for is forms attached to tables without filtering. You should not allow the user to scroll through rows on forms. The form should be filtered first and opened to only 1 record.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 25, 2007 at 11:46 am
Hi, I have 6 data tables in MS-Access to upload into SQL2005. What is the quickest way to do this? This will be done about 4-5 times a year.
April 25, 2007 at 3:36 pm
It you want to automate it, create a SQL Server Integration Services (SSIS) package to do the work. You can schedule it as a job from SQL Server.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply