Conversion of database from Ms Access 2003 to SQL Server 2005
Can anyone tell me the steps to convert a database file from Ms access 2003 to SQL Server 2005 ?????
Reply to deepsand : Thanks for the reply, but the fact is that I am looking for the steps of conversion from MS Access 2003 to SQL Server 2005......... Whereas the search result in Google showed for MS Access 2003 to SQl Server 2005.......... So please if you can help.....
Still thanks a lot for the response....
The difference being what?
Originally Posted by BillyC
The salient point here is that your best source of assistance for this is, not here, but MS itself.
Last edited by deepsand; 08-22-2011 at 01:35 AM.
The easiest solution to your problem for conversion from MS Access database to SQL Server is to use the Upsizing Wizard. The Upsizing Wizard helps in.1) Preserves database structure, including data, indexes, and default settings. 2)Automatically converts Access validation rules and default settings to the appropriate SQL Server equivalents. 3) Maintains table relationships and referential integrity after you upsize.
To run the Upsizing Wizard in Access 2003, on the Tools menu, point to Database Utilities, and then click Upsizing Wizard. If you need more help you can check out at support.microsoft.com