Software·43,780 discussions

Migrate access data to sql server.

Locked

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

Topic

Reply To: Migrate access data to sql server.

In reply to Migrate access data to sql server.

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

Reply To: Migrate access data to sql server.

In reply to Migrate access data to sql server.

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…

Reply To: Migrate access data to sql server.

In reply to Migrate access data to sql server.

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.

[Author]

Replies