Upsizing An Access Database To A SQL Server

[R Tanner]

Hi,

I have an access database that I want to put into a sql server
database. When I pull up the upsizing wizard, select 'Create New
Database', select 'Next', use '(local)' for the server, select 'Use
Trusted Connection', and select 'Next', I get the following message.

The upsizing wizard only works with Microsoft SQL Server (Versions
6.50 SP5 or higher). Please log in to a SQL Server data source.

I am connected locally in sql management studio. What should I be
doing differently to upgrade this database to sql server?

Sorry if I posted this in the wrong group...

[Aaron Bertrand [SQL Server MVP]]

Are you sure you are connected to a default instance and not a named
instance?


On 1/7/09 2:10 PM, in article

Post by R Tanner
Hi,
I have an access database that I want to put into a sql server
database. When I pull up the upsizing wizard, select 'Create New
Database', select 'Next', use '(local)' for the server, select 'Use
Trusted Connection', and select 'Next', I get the following message.
The upsizing wizard only works with Microsoft SQL Server (Versions
6.50 SP5 or higher). Please log in to a SQL Server data source.
I am connected locally in sql management studio. What should I be
doing differently to upgrade this database to sql server?
Sorry if I posted this in the wrong group...

[R Tanner]

On Jan 7, 12:32 pm, "Aaron Bertrand [SQL Server MVP]"

Post by Aaron Bertrand [SQL Server MVP]
Are you sure you are connected to a default instance and not a named
instance?
On 1/7/09 2:10 PM, in article

Post by R Tanner
Hi,
I have an access database that I want to put into a sql server
database. When I pull up the upsizing wizard, select 'Create New
Database', select 'Next', use '(local)' for the server, select 'Use
Trusted Connection', and select 'Next', I get the following message.
The upsizing wizard only works with Microsoft SQL Server (Versions
6.50 SP5 or higher). Please log in to a SQL Server data source.
I am connected locally in sql management studio. What should I be
doing differently to upgrade this database to sql server?
Sorry if I posted this in the wrong group...

Honestly, I have no idea, nor do I know how I could tell the
difference. I don't even know what that means. I'm sorry. I'm
learning Reporting Services right now, but I just recently learned
that I need to get my **s in gear and get this database going too, so
I'm kinda wingin it...

[Aaron Bertrand [SQL Server MVP]]

Well when you are "connected locally in sql management studio", what does
that mean? Do you have a query window open? Can you execute SELECT
@@VERSION? What does it yield? In the status bar of the query window, what
does it say?

I don't think winging it will get you far, and I don't think a newsgroup is
the best place to learn the absolute basics. You might consider a seminar
or training course or have a consultant come in and show you the ropes for a
day. A good book helps but sometimes that is just not fast paced enough.


On 1/8/09 9:12 AM, in article

Post by R Tanner
On Jan 7, 12:32 pm, "Aaron Bertrand [SQL Server MVP]"

Post by Aaron Bertrand [SQL Server MVP]
Are you sure you are connected to a default instance and not a named
instance?
On 1/7/09 2:10 PM, in article

Post by R Tanner
Hi,
I have an access database that I want to put into a sql server
database. When I pull up the upsizing wizard, select 'Create New
Database', select 'Next', use '(local)' for the server, select 'Use
Trusted Connection', and select 'Next', I get the following message.
The upsizing wizard only works with Microsoft SQL Server (Versions
6.50 SP5 or higher). Please log in to a SQL Server data source.
I am connected locally in sql management studio. What should I be
doing differently to upgrade this database to sql server?
Sorry if I posted this in the wrong group...

Honestly, I have no idea, nor do I know how I could tell the
difference. I don't even know what that means. I'm sorry. I'm
learning Reporting Services right now, but I just recently learned
that I need to get my **s in gear and get this database going too, so
I'm kinda wingin it...

[R Tanner]

On Jan 8, 8:24 am, "Aaron Bertrand [SQL Server MVP]"

Post by Aaron Bertrand [SQL Server MVP]
Well when you are "connected locally in sql management studio", what does
that mean? Do you have a query window open? Can you execute SELECT
@@VERSION? What does it yield? In the status bar of the query window, what
does it say?
I don't think winging it will get you far, and I don't think a newsgroup is
the best place to learn the absolute basics. You might consider a seminar
or training course or have a consultant come in and show you the ropes for a
day. A good book helps but sometimes that is just not fast paced enough.
On 1/8/09 9:12 AM, in article

Post by R Tanner
On Jan 7, 12:32 pm, "Aaron Bertrand [SQL Server MVP]"

Post by Aaron Bertrand [SQL Server MVP]
Are you sure you are connected to a default instance and not a named
instance?
On 1/7/09 2:10 PM, in article

Post by R Tanner
Hi,
I have an access database that I want to put into a sql server
database. When I pull up the upsizing wizard, select 'Create New
Database', select 'Next', use '(local)' for the server, select 'Use
Trusted Connection', and select 'Next', I get the following message.
The upsizing wizard only works with Microsoft SQL Server (Versions
6.50 SP5 or higher). Please log in to a SQL Server data source.
I am connected locally in sql management studio. What should I be
doing differently to upgrade this database to sql server?
Sorry if I posted this in the wrong group...

Honestly, I have no idea, nor do I know how I could tell the
difference. I don't even know what that means. I'm sorry. I'm
learning Reporting Services right now, but I just recently learned
that I need to get my **s in gear and get this database going too, so
I'm kinda wingin it...

I'm pretty good with database design with access and I have done quite
a bit of vba coding and I know sql pretty well...and I am pretty good
with reporting services...so I'm hoping that will be enough to carry
me through...

when I execute select @@VERSION I get the following...

Microsoft SQL Server 2008(RTM) and a bunch of other mumbo jumbo but I
think you can surmise it is working...

[Aaron Bertrand [SQL Server MVP]]

I wasn't concerned that it wasn't working. I am trying to determine version
and where it lives. Part of @@VERSION is the edition, is it Express,
Developer, Workgroup, something else? And what about the status bar that I
asked about? Does it say MACHINE_NAME, or MACHINE_NAME\SOMETHING, or IP
address, or IP address\SOMETHING? How did you connect, what server name did
you specify, did you use Windows authentication or did you enter a SQL
username / password?

Post by R Tanner
I'm pretty good with database design with access and I have done quite
a bit of vba coding and I know sql pretty well...and I am pretty good
with reporting services...so I'm hoping that will be enough to carry
me through...
Microsoft SQL Server 2008(RTM) and a bunch of other mumbo jumbo but I
think you can surmise it is working...

[R Tanner]

On Jan 8, 9:56 am, "Aaron Bertrand [SQL Server MVP]"

Post by Aaron Bertrand [SQL Server MVP]
I wasn't concerned that it wasn't working. I am trying to determine version
Developer, Workgroup, something else? And what about the status bar that I
asked about? Does it say MACHINE_NAME, or MACHINE_NAME\SOMETHING, or IP
address, or IP address\SOMETHING? How did you connect, what server name did
you specify, did you use Windows authentication or did you enter a SQL
username / password?

Post by R Tanner
I'm pretty good with database design with access and I have done quite
a bit of vba coding and I know sql pretty well...and I am pretty good
with reporting services...so I'm hoping that will be enough to carry
me through...
Microsoft SQL Server 2008(RTM) and a bunch of other mumbo jumbo but I
think you can surmise it is working...

Oh sorry...
In my status bar for my query window, I have the following:

C:\Documents and Settings\robin.grossman\Local Settings\Temp
\~vs3C4.sql

In the object explorer it looks like I am connected to (local) and I
used windows authentication.

select @@VERSION returns the following:

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9
2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack
2)

[David Tinjaca - Hotmail.COM]

Hi, If you only need to migrate data, please import this database from SQL
server with the 'import & export wizard'.

If you Access database. have forms and other object you need to mapping
those again using linked tables or open a new access project adp, correct to
mssql and migrate the objects.

I understand that this process should be long...but should be work.


David Tinjaca
Bogota, Colombia

Post by R Tanner
On Jan 8, 9:56 am, "Aaron Bertrand [SQL Server MVP]"

Post by Aaron Bertrand [SQL Server MVP]
I wasn't concerned that it wasn't working. I am trying to determine version
Developer, Workgroup, something else? And what about the status bar that I
asked about? Does it say MACHINE_NAME, or MACHINE_NAME\SOMETHING, or IP
address, or IP address\SOMETHING? How did you connect, what server name did
you specify, did you use Windows authentication or did you enter a SQL
username / password?

Post by R Tanner
I'm pretty good with database design with access and I have done quite
a bit of vba coding and I know sql pretty well...and I am pretty good
with reporting services...so I'm hoping that will be enough to carry
me through...
Microsoft SQL Server 2008(RTM) and a bunch of other mumbo jumbo but I
think you can surmise it is working...

Oh sorry...
C:\Documents and Settings\robin.grossman\Local Settings\Temp
\~vs3C4.sql
In the object explorer it looks like I am connected to (local) and I
used windows authentication.
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9
2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack
2)

[Aaron Bertrand [SQL Server MVP]]

Post by R Tanner
Oh sorry...
C:\Documents and Settings\robin.grossman\Local Settings\Temp
\~vs3C4.sql

The status bar at the bottom? I think you are looking at the tab.

You should see something like this at the bottom right:

Loading Image...

[R Tanner]

On Jan 8, 12:48 pm, "Aaron Bertrand [SQL Server MVP]"

Post by Aaron Bertrand [SQL Server MVP]

Post by R Tanner
Oh sorry...
C:\Documents and Settings\robin.grossman\Local Settings\Temp
\~vs3C4.sql

The status bar at the bottom? I think you are looking at the tab.
http://www.aaronbertrand.com/voodoo/statusbar.png

Okay it says the following

Query Executed Successfully | MRW\robin.tanner(55) | master |00:00:00
| 1827 rows