x

how to import to SQLSERVER

Hi, I am using typical stand alone system in MS-Access, but for my company....who all are users all users are using client application and the database file (.MDF) I kept in Windows 2000 Server and i mapped the folder to client systems.

Now presently my requirement is ....

1) Is it possible to install SQLSERVER2008 on Windows 2000 Server?
2) how to export the data from MS-Access file (.MDF) to SQL Server 2008 by using SSIS package.

Any help pls....
more ▼

asked Mar 10, 2011 at 11:03 PM in Default

Murali gravatar image

Murali
906 101 117 120

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

If I had this project I would certainly take a look at the Access Migration tool (http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx). It splits an access file into two, one file being the forms and reports and the other being the data objects which it then uses to create a SQL database. All via a wizard. Obviously the process can have some effects you dont want but I would recommend trying it on a copy just to see if it gets you 90% of the way...

once you get the SQL Server installed of course..!
more ▼

answered Mar 11, 2011 at 01:28 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.7k 75 79 108

A similar question on migrating access to sql server: http://ask.sqlservercentral.com/questions/3262/migrating-access-to-sql
Mar 11, 2011 at 05:17 AM KenJ
(comments are locked)
10|1200 characters needed characters left

You cannot instal SQL 2008 on Windows 2000, you must use 2003 SP2 at least.

[Link to requirements][1]

As for importing the data, you don't need to export first, you should be able to use SSIS to connect directly to the access file and read the tables out.

The drivers should be included by default, although I am not certain about 64 Bit drivers for Access.

[1]: http://msdn.microsoft.com/en-us/library/ms143506.aspx
more ▼

answered Mar 10, 2011 at 11:11 PM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

thank you for the info
Mar 11, 2011 at 12:44 AM Murali
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1840
x939
x51
x4

asked: Mar 10, 2011 at 11:03 PM

Seen: 1001 times

Last Updated: Mar 11, 2011 at 05:21 AM