upsizing to sql

  • Thread starter Thread starter Robert Blackwell
  • Start date Start date
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
 
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)
 
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
 
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)
 
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?
Click to expand...

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
 
Thanks, I wish I would have done that sooner, I'm dl'ed the trial of sql
server and the tools etc.
 
Back
Top