Can MSDE and SQL live on the same system?

Hey everyone,
We are running MSDE on a Windows 200 server and it has data in it. What I
would like to know is can we also install MSSQL 2005 on that server and have
assess to both databases. Is there anything we have to do to install it and
make sure it doesn't overwrite or delete the MSDE database?
TIA,
Claytonhi Clayton,
Clayton Sutton wrote:
> Hey everyone,
> We are running MSDE on a Windows 200 server and it has data in it. What I
> would like to know is can we also install MSSQL 2005 on that
> server and have assess to both databases. Is there anything we have
> to do to install it and make sure it doesn't overwrite or delete the
> MSDE database?
MSDE and SQL Server 2005 can coexist on the same computer... just pay
attention, at installation time, not to "upgrade" the MSDE instance to a SQL
Server 2005 one..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||Yes this is possible, you just have to install it as a default or named
instance, which doesn=B4t equal the instance name of the MSDE, although
I doubt that this is possible through the installer to crash the system
that way. They are using different ports, so co-existence on the system
is possible.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Just interesting, why you do not want a run both databases on sql 2005?
Andris
Clayton Sutton wrote:
> Hey everyone,
> We are running MSDE on a Windows 200 server and it has data in it. What I
> would like to know is can we also install MSSQL 2005 on that server and have
> assess to both databases. Is there anything we have to do to install it and
> make sure it doesn't overwrite or delete the MSDE database?
>
> TIA,
> Clayton
>|||An old app. that one dept. has been using for years was running on MSDE.
Now they are moving to a new program that uses MSSQL 2000/2005. However,
the old data is going to stay in the MSDE database (unless that dept. wants
to pay someone to do a data export/import into MSSQL). I just wanted to
make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE
and all of the old data therein.
Clayton
"Andris" <spameris@.gmail.com> wrote in message
news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
> Just interesting, why you do not want a run both databases on sql 2005?
> Andris
> Clayton Sutton wrote:
>> Hey everyone,
>> We are running MSDE on a Windows 200 server and it has data in it. What
>> I would like to know is can we also install MSSQL 2005 on that server and
>> have assess to both databases. Is there anything we have to do to
>> install it and make sure it doesn't overwrite or delete the MSDE
>> database?
>>
>> TIA,
>> Clayton|||I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches.
Simple backup/restore. With MSDE i think u can too, backup that db and
restore to MSSQL 2005. How i understand MSDE is some as MSSQL with some
restrictions on db size,replications etc. All who run un MSDE must run
un MSSQL. I have few msde servers who replicating with MSSQL, sometimes
i need open archive of these msde databases, i do this on MSSQL without
problems.
Sry my poor english
Andris
Clayton Sutton wrote:
> An old app. that one dept. has been using for years was running on MSDE.
> Now they are moving to a new program that uses MSSQL 2000/2005. However,
> the old data is going to stay in the MSDE database (unless that dept. wants
> to pay someone to do a data export/import into MSSQL). I just wanted to
> make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE
> and all of the old data therein.
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>Hey everyone,
>>We are running MSDE on a Windows 200 server and it has data in it. What
>>I would like to know is can we also install MSSQL 2005 on that server and
>>have assess to both databases. Is there anything we have to do to
>>install it and make sure it doesn't overwrite or delete the MSDE
>>database?
>>
>>TIA,
>>Clayton
>
>|||Hey Andris,
First thing, your english is fine. Don't ever apologize for that. Truth be
told, I can't spell :).
Backing up MSDE is a little tricky. Most backup software doesn't have a
connector for MSDE so backing up and restore becomes a little harder.
The command line command to back one up is:
C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk ='c:\mssql7\backup\dbname.bak'"
It took me forever to find that command, and I don't know what the command
is to restore it.
Clayton
"Andris" <spameris@.gmail.com> wrote in message
news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches. Simple
>backup/restore. With MSDE i think u can too, backup that db and restore to
>MSSQL 2005. How i understand MSDE is some as MSSQL with some restrictions
>on db size,replications etc. All who run un MSDE must run un MSSQL. I have
>few msde servers who replicating with MSSQL, sometimes i need open archive
>of these msde databases, i do this on MSSQL without problems.
> Sry my poor english
> Andris
> Clayton Sutton wrote:
>> An old app. that one dept. has been using for years was running on MSDE.
>> Now they are moving to a new program that uses MSSQL 2000/2005. However,
>> the old data is going to stay in the MSDE database (unless that dept.
>> wants to pay someone to do a data export/import into MSSQL). I just
>> wanted to make sure installing MSSQL on the same system as MSDE didn't
>> wipe out MSDE and all of the old data therein.
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message
>> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>Hey everyone,
>>We are running MSDE on a Windows 200 server and it has data in it. What
>>I would like to know is can we also install MSSQL 2005 on that server
>>and have assess to both databases. Is there anything we have to do to
>>install it and make sure it doesn't overwrite or delete the MSDE
>>database?
>>
>>TIA,
>>Clayton
>>|||For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server 2000
(the MSDE info), you can download a copy of Books Online (BOL) at
http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en.
Using the example syntax you provided, it would probably be something like:
osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM
DISK='c:\mssql7\backup\dbname.bak'"
Note, however, that I haven't tested that. :-)
--
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clayton Sutton" <none@.none.com> wrote in message
news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
> Hey Andris,
> First thing, your english is fine. Don't ever apologize for that. Truth
> be told, I can't spell :).
> Backing up MSDE is a little tricky. Most backup software doesn't have a
> connector for MSDE so backing up and restore becomes a little harder.
> The command line command to back one up is:
> C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk => 'c:\mssql7\backup\dbname.bak'"
> It took me forever to find that command, and I don't know what the command
> is to restore it.
>
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches. Simple
>>backup/restore. With MSDE i think u can too, backup that db and restore to
>>MSSQL 2005. How i understand MSDE is some as MSSQL with some restrictions
>>on db size,replications etc. All who run un MSDE must run un MSSQL. I have
>>few msde servers who replicating with MSSQL, sometimes i need open archive
>>of these msde databases, i do this on MSSQL without problems.
>> Sry my poor english
>> Andris
>> Clayton Sutton wrote:
>> An old app. that one dept. has been using for years was running on MSDE.
>> Now they are moving to a new program that uses MSSQL 2000/2005.
>> However, the old data is going to stay in the MSDE database (unless that
>> dept. wants to pay someone to do a data export/import into MSSQL). I
>> just wanted to make sure installing MSSQL on the same system as MSDE
>> didn't wipe out MSDE and all of the old data therein.
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message
>> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>Hey everyone,
>>We are running MSDE on a Windows 200 server and it has data in it.
>>What I would like to know is can we also install MSSQL 2005 on that
>>server and have assess to both databases. Is there anything we have to
>>do to install it and make sure it doesn't overwrite or delete the MSDE
>>database?
>>
>>TIA,
>>Clayton
>>
>|||Hey Steve,
Would that restore the DB to MSDE only. What if you wanted to restore it
into MSSQL 2000 or 2005? That's really what we are talking about, how to
move from MSDE to MSSQL 2000/2005. Get the data out of MSDE and into MSSQL.
Clayton
"Steve Dybing [MSFT]" <steve.dybing@.online.microsoft.com> wrote in message
news:uIP9O6QdGHA.1436@.TK2MSFTNGP05.phx.gbl...
> For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
> http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server
> 2000 (the MSDE info), you can download a copy of Books Online (BOL) at
> http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en.
> Using the example syntax you provided, it would probably be something
> like:
> osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM
> DISK='c:\mssql7\backup\dbname.bak'"
> Note, however, that I haven't tested that. :-)
> --
> Sincerely,
> Steve Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Clayton Sutton" <none@.none.com> wrote in message
> news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
>> Hey Andris,
>> First thing, your english is fine. Don't ever apologize for that. Truth
>> be told, I can't spell :).
>> Backing up MSDE is a little tricky. Most backup software doesn't have a
>> connector for MSDE so backing up and restore becomes a little harder.
>> The command line command to back one up is:
>> C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk =>> 'c:\mssql7\backup\dbname.bak'"
>> It took me forever to find that command, and I don't know what the
>> command is to restore it.
>>
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message
>> news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches.
>>Simple backup/restore. With MSDE i think u can too, backup that db and
>>restore to MSSQL 2005. How i understand MSDE is some as MSSQL with some
>>restrictions on db size,replications etc. All who run un MSDE must run un
>>MSSQL. I have few msde servers who replicating with MSSQL, sometimes i
>>need open archive of these msde databases, i do this on MSSQL without
>>problems.
>> Sry my poor english
>> Andris
>> Clayton Sutton wrote:
>> An old app. that one dept. has been using for years was running on
>> MSDE. Now they are moving to a new program that uses MSSQL 2000/2005.
>> However, the old data is going to stay in the MSDE database (unless
>> that dept. wants to pay someone to do a data export/import into MSSQL).
>> I just wanted to make sure installing MSSQL on the same system as MSDE
>> didn't wipe out MSDE and all of the old data therein.
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message
>> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>Hey everyone,
>>We are running MSDE on a Windows 200 server and it has data in it.
>>What I would like to know is can we also install MSSQL 2005 on that
>>server and have assess to both databases. Is there anything we have
>>to do to install it and make sure it doesn't overwrite or delete the
>>MSDE database?
>>
>>TIA,
>>Clayton
>>
>|||MSDE is SQL Server. So you can both attach and restore an MSDE 2000 database into SQL Server 2000 or
2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Clayton" <none@.none.com> wrote in message news:8GV8g.100380$JV1.10779@.fe05.news.easynews.com...
> Hey Steve,
> Would that restore the DB to MSDE only. What if you wanted to restore it into MSSQL 2000 or 2005?
> That's really what we are talking about, how to move from MSDE to MSSQL 2000/2005. Get the data
> out of MSDE and into MSSQL.
>
> Clayton
>
> "Steve Dybing [MSFT]" <steve.dybing@.online.microsoft.com> wrote in message
> news:uIP9O6QdGHA.1436@.TK2MSFTNGP05.phx.gbl...
>> For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
>> http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server 2000 (the MSDE info), you
>> can download a copy of Books Online (BOL) at
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en.
>> Using the example syntax you provided, it would probably be something like:
>> osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM DISK='c:\mssql7\backup\dbname.bak'"
>> Note, however, that I haven't tested that. :-)
>> --
>> Sincerely,
>> Steve Dybing
>> This posting is provided "AS IS" with no warranties, and confers no rights.
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
>> Hey Andris,
>> First thing, your english is fine. Don't ever apologize for that. Truth be told, I can't spell
>> :).
>> Backing up MSDE is a little tricky. Most backup software doesn't have a connector for MSDE so
>> backing up and restore becomes a little harder.
>> The command line command to back one up is:
>> C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk =>> 'c:\mssql7\backup\dbname.bak'"
>> It took me forever to find that command, and I don't know what the command is to restore it.
>>
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches. Simple backup/restore. With
>>MSDE i think u can too, backup that db and restore to MSSQL 2005. How i understand MSDE is some
>>as MSSQL with some restrictions on db size,replications etc. All who run un MSDE must run un
>>MSSQL. I have few msde servers who replicating with MSSQL, sometimes i need open archive of
>>these msde databases, i do this on MSSQL without problems.
>> Sry my poor english
>> Andris
>> Clayton Sutton wrote:
>> An old app. that one dept. has been using for years was running on MSDE. Now they are moving
>> to a new program that uses MSSQL 2000/2005. However, the old data is going to stay in the MSDE
>> database (unless that dept. wants to pay someone to do a data export/import into MSSQL). I
>> just wanted to make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE and
>> all of the old data therein.
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>>Hey everyone,
>>>
>>>We are running MSDE on a Windows 200 server and it has data in it. What I would like to know
>>>is can we also install MSSQL 2005 on that server and have assess to both databases. Is there
>>>anything we have to do to install it and make sure it doesn't overwrite or delete the MSDE
>>>database?
>>>
>>>
>>>TIA,
>>>
>>>Clayton
>>
>>
>|||From your post it sounds like you believe that MSSQL and MSDE are two
different database formats. They are not. MSDE is merely a scaled-down
version of SQL Server, and the file formats are identical.
I, personally, develop in MSDE on my development machine, and then I make
changes to the live database which is running on SQL Server. When I need a
new copy of the data, I download a backup file from the SQL Server database
and run it in my MSDE. The two formats are identical.
Thus, while installing MSSQL might create conflicts with running MSDE, the
*data itself* will remain untouched. Since your MSDE data is in SQL 7
format, there may be issues with running your data on a later version of
MSSQL, but those should be able to be resolved.
"Clayton Sutton" <none@.none.com> wrote in message
news:xIt8g.391355$4P2.48017@.fe03.news.easynews.com...
> An old app. that one dept. has been using for years was running on MSDE.
> Now they are moving to a new program that uses MSSQL 2000/2005. However,
> the old data is going to stay in the MSDE database (unless that dept.
> wants to pay someone to do a data export/import into MSSQL). I just
> wanted to make sure installing MSSQL on the same system as MSDE didn't
> wipe out MSDE and all of the old data therein.
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>> Just interesting, why you do not want a run both databases on sql 2005?
>> Andris
>> Clayton Sutton wrote:
>> Hey everyone,
>> We are running MSDE on a Windows 200 server and it has data in it. What
>> I would like to know is can we also install MSSQL 2005 on that server
>> and have assess to both databases. Is there anything we have to do to
>> install it and make sure it doesn't overwrite or delete the MSDE
>> database?
>>
>> TIA,
>> Clayton
>