General discussion

Locked

Migrate access data to sql server.

By ananthap ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by JEPott In reply to Migrate access data to sq ...

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

Collapse -

by illilli In reply to Migrate access data to sq ...

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...

Collapse -

by LeighX In reply to Migrate access data to sq ...

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.

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums