Upsizing wizard

[Pietro]

Hi,

I'm trying to upsize my database to SQL Server.
In the wizard I'm asked to put the server name, actually i don't know what
should i input.
I'm using SQL Server Express 2005 and Office 2007 My database is 2003
formatted.
Can anybody help?

 

[Rick Brandt]

Hi,

I'm trying to upsize my database to SQL Server.
In the wizard I'm asked to put the server name, actually i don't know
what should i input.
I'm using SQL Server Express 2005 and Office 2007 My database is 2003
formatted.
Can anybody help?

If you mean that the SQL Server instance is running on your own machine
that you also run Access in, then I would expect "localhost" is the
correct server name to use.

 

[Maurice]

Open your SQL Express edition (if you have the management studio installed)
and when the connect dialog shows up copy the servername from the textbox
shown on the dialog from SQL Express.

Most of the times it's something like: [name of computer]\SQLExpress

hth

 

[Tony Toews [MVP]]

I'm trying to upsize my database to SQL Server.

Also note that the SSMA may do a better job of upsizing your database.

There is a tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/