Upgrade MSDE to MSSQL

Hi there,

If I want to upgrade from MSDE to MSSQL 2000, how can I do the upgrade?
Need I uninstall the MSDE?
Can MSSQL detect my MSDE and do necessary upgrade as well as exisitng database (my existing MSDE database) conversion?

Thanks in advance.

firstly...take the database ...then uninstall msde...

then install sql server..and finally attatch it back in

Do you have step by step guide?

Here is what I am trying to do. Is ti correct?

I have not installed the MSSQL yet.

1) Launch the MSDE sql server
2) Import and Export data
3) click Next
4) ...
source: Ms OLE DB provider for sql server
server: local
user Win NT authentication
choose database and click NEXT
There are 3 options, which I should choose?
a) copy table(s) from the source database
b) use a query specify the data to transfer (if I choose what quer should I use?)
c) Transfer object and data between SQL server 7.0 databases (test try and I CANNOT perform this option)

after this, I need help ..... Thanks.

right click on the database in enterprise manager..then click on the detatch database

then uninstall msde and then install sql server..
and right click on the "database" folder like icon and click attatch.. you should see a file named what ever the datbaes base was called b4 in sqlserver folder..somewhere.

thn select it .and click ok and ur done.!!!

I have done by removing MSDE and installing MSSQL 2000 with the following steps:

1) I uninstall the MSDE, this is because I cannot find what you say ... in my MSDE.
2) After uninstallation, I still have my previous data in the DATA folder
3) I install MSSQL 2000
4) NOW, I open the SQL Server SErvice Manager, and in the database -> right click -> All Tasks -> Attach Database ->

A pop-up window open, and I can select my previous database location and do what I suppose to do.

Yes, I did like this and it works for me.

------------------------------------
I have another question:

In step 4, in the pop-up window, I have 2 choices in "select database owner"
1) Administrator (My login name to windows 2000)
2) sa

I suppose to use sa, But I mis-select the first one, and the results my connection.

My question, after I attached the previous database (using wrong database ownership), how can I change it back to correct database ownership, in this case is sa?

Thanks in advance. For the time being, I will delete the database attachment first.

I don't think it mattars which account u use.. All your database should have DBO as the owner of the database..

SA and Administrator is about different security type

SA for SQL Server Auth
and
Administrator for SQL Server Auth and Windows Auth.

Oh NO, when I delete the attachment, it delete my database too! Luckily, it is just a small database database for testing.

attatchment as in the database file you've "attatched" to the database?

Regarding this, does you mean that whether I use Administrators or sa, I still can connect to my database?

FYI, my database connection is as follows:

SqlConnection connection = new SqlConnection
("server=localhost;database=weblogin;uid=sa;pwd=");

BUT, what I faced was I cannot connect to database?

yup..

if ur using Windows Auth..

use

Integrated Security = SSPI; somewhere in the conn str..


you can change the settings thugh..from win to sql and sql to win auth

I attach my database c:\mydata\weblogin.mdf and when I delete it (right click database weblogin in the SQL server service manager (This should be Enterprise Manager) and choose delete). my file database (weblogin.mdf has been deleted too.I don't understand what you mean

now im confused :|



how do you delete a database from sql server service manager?

so is ur file datbase deleted cuz u deleted it form EM ??

Yes, I delete database (choose database -> right click _> delete) in EM.

Does you mean that I can do this other place, besides EM? where?

sql server service manager
and
enterprise manager is totally different

Use Integrated Security = SSPI, somewhere in the connection string ...
does you mean this:

Dim QueryString AS String = "SELECT [ORDERS].[ORDERID] FROM [ORDERS]; Integrated Security = SSPI"

Thanks first.

that's query string

connection string is

uid=sa;pwd=;Integrated Security=SSPI; ...

So, I should you ...

Dim ConnectionString As String = "server=localhost;database=weblogin;uid=sa;pwd=;tru sted_connection=true;Integrated Security=SSPI"

So that I can both use the Win and Sql Auth. What is trusted_connection=true? Is it same with Integrated Security=SSPI?