How to Convert MS Access Database to SQL Server Database

Hello guys at this time i will show to you on how to convert your MS Access
Database to
SQL Server Database, to do this, just follow those few
steps below.

on your MS
Access database, go to Database Tools, go to Move Data tab,
then click
SQL Server

then
the Up-sizing wizard will prompt, allowing you to use an option, at this
time since
i am not using Existing Database, so i select Create new
Database, then Click Next
button,

since
i am converting to SQL Server, if you do this, you must enter your
current SQL
Server name, since i am using Developer Edition
of SQL Server, the server name
is only my computer name,
not like if i am using Express, my server name will look like
this
MRHUMBLE\Express, that is the one differences of Express and
Dev. Edition
and  for more knowledge about their differences i will
tackled those later,but now let focus
on this tutorial, then Enter
Database name, but now i am using the Default

then
it will look like this, select the table you want up-size, then click the
Left Arrow button
for you to Export on SQL Server, then
follow the next step below,

this
is the default up-sizing

then
here you go,,,,

after
hitting the OK button, you will came out with up-sizing
Report

as
you can see at the image above, the default Database Name, create by the
Wizard
is on my SQL Server, and together with the
Table.

Note: the Sql Server Database that i am using is SQL Server
2005 Dev. Edition and
MS Access
2007

The Hardest Thing to Do is to Do Nothing ^_^