IE Manager | Internet Explorer Manager

Microsoft Access Database to Microsoft SQL database 2005?

I am not familiar with SQL 2005 and I guess it does not have an Enterprise Manager. I need to move an existing Access database from Access to SQL 2005 how can I do this. All I want to do is move the table’s and data not queries or anything else to SQL 2005.

Microsoft had the brilliant idea of not including DTS (the import/export wizard) with the express edition of SQL server. It is available under a new name called SSIS (SQL Server Integration Services) under the enterprise edition.

However, I did a bit of digging around and came across an article that will allow you to setup the DTS of SQL Server 2000 with the Express edition of 2005 and use it to import and export like before.

If you do not want to do this, you might be out of luck. Now if you have the enterprise edition or any other edition other than express, you should have the SSIS tools needed to import straight from the MS Access file.

The link below shows you how to setup the old SQL 2000 DTS wizard to work with express 2005.

Enjoy!

SQL Server 2000 video training – free sample