PDA

View Full Version : Migrate Access db to MSSQL


hangman
07-03-2004, 10:07 AM
Does anyone know how to migrate an ACCESS database to
MS SQL Server? I do have SQL Server Enterprise but can figure
out how to do it. Need some help..

Hangman

Scholten
07-04-2004, 07:29 AM
Use the upsize wizard in Access

bruce
07-04-2004, 11:54 AM
See these instructions

http://support.microsoft.com/default.aspx?scid=kb;en-us;325017&Product=acc2000

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrconvertingaccessdatabasewithupsizingwizard.as p

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnproasp/html/upsizingtosqlserver.asp



[b]quote:Originally posted by hangman

Does anyone know how to migrate an ACCESS database to
MS SQL Server? I do have SQL Server Enterprise but can figure
out how to do it. Need some help..

Hangman
</blockquote id="quote"></font id="quote">