Software

Ask something
Discussion Locked

Migrate access data to sql server.

0 helpful
3 replies

by ananthap

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to migrate some MS-Access 2000 (SP-1) databases to SQL server 2000 std edition.

Is it posibble to simply migrate the entire database? If not, I could also do it table by table?

I am new to SQL server and have some experience in MS-Access.

end

3 replies

by jepott

Here's some info from Microsoft on doing this: http://support.microsoft.com/default.aspx?scid=kb;en-us;237980

by illilli

Try these links in addition to the one above:

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0561.mspx

http://www.sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=2063

http://www.granite.ab.ca/access/sqlserverupsizing.htm

http://www.erobillard.com/LoadPage.aspx?pg=/articles/database/ConvertingAccessToSqlServer.xml

Of course, there are numerous resources available all over the internet to assist you. My friend google tells all...

by leighx

You will need to upsize your database from within access.
This is very easily done. open your DB and make sure tables under options is highlighted. Then Tools --->Database Utilities ---> Upsizing wizard. Then just follw the simple steps.

This discussion is closed to new replies.