upsizing to sql


R

Robert Blackwell

When I upsized an access dbase, I was expecting it to output a filename.sql
but instead, I got filename.ldf and .mdf.

Also, when I upsized using the wizard I used my local host MSDE install and
checked "used trusted connection" cause I didn't know a user and login.

I can't figure out MSDE either, but I'd rather not go there until I figure
out if I upsized correctly etc. and how to get a .sql file out of it.

Did I go about this wrong or what?

Thanks
 
Ad

Advertisements

D

david epsom dot com dot au

You got a database. You need to start SQL Server / MSDE,
and add the database to the server.

If you want a SQL Script, SQL Server will be able to
generate one from the database.

(david)
 
R

Robert Blackwell

I'm not sure if I understand.

When you say I have a dbase already, are you referring to the ftestdbase.ldf
and testdbase.mdf file?

Can you walk me through how to "add" a dbase?

I tried this in the cmd prompt
osql -d testdbase -u user -p pass

But I can never tell if it's working because regardless of what I type, it
just shows all of the commands again.

If this helps at all, my "server" name I THINK is mycomputername\MSDE02

Thanks
 
D

david epsom dot com dot au

I am NOT a SQL Server Guru. When I watch, the server admin
starts the server tools, goes down to 'databases', right
clicks, and selects 'add' (or something like that).

In any case, you can't connect to the database until
after it has been added to the server. This is something
you have to do with the server. There is no point testing
the connection or anything else until that has been done.

At the moment you have a database file: SQL Server
needs to be told about that file, and SQL Server has
to start using that file as a database.

After you have added that database to the server's
collection of databases, then you should be able to
connect to the server and use that database.

(david)
 
T

Tony Toews

Robert Blackwell said:
When you say I have a dbase already, are you referring to the ftestdbase.ldf
and testdbase.mdf file?

Can you walk me through how to "add" a dbase?
Here's where you want to use the SQL Server Developer Tools which is a
GUI interface to the SQL Server/MSDE engine.

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
 
Ad

Advertisements

R

Robert Blackwell

Thanks, I wish I would have done that sooner, I'm dl'ed the trial of sql
server and the tools etc.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upsizing to SQL 2
Upsizing to SQL 1
Upsizing to SQL 2000 5
upsize to sql server 6
Help with SQL Upsize 0
Upsize to SQL - Query Criteria 4
Opinions on SQL Server upsize 13
SQL upsize 2 databases 2

Top