Making a copy of an SQL 7 database into an MSDE environment

We have developed an application for Small Business
Server (SQL) on a system that is running MSDE. All
programming and testing was conducted on a remote,
standalone system, and when completed, we were able to
move appropriate copies to the LAN via an external 80GB
Western Digital USB attached portable drive.
Is it possible to copy one or more or the SQL databases
(all tables) from the SBS SQL server to an MSDE system?
(ie a network attached laptop).
I would appreciate your assistance and comments.
Regards...Dave K.
hi Dave,
"dkalling" <dkalling@.cnx2.com> ha scritto nel messaggio
news:04c001c4eddc$579de490$a401280a@.phx.gbl
> We have developed an application for Small Business
> Server (SQL) on a system that is running MSDE. All
> programming and testing was conducted on a remote,
> standalone system, and when completed, we were able to
> move appropriate copies to the LAN via an external 80GB
> Western Digital USB attached portable drive.
> Is it possible to copy one or more or the SQL databases
> (all tables) from the SBS SQL server to an MSDE system?
> (ie a network attached laptop).
> I would appreciate your assistance and comments.
> Regards...Dave K.
as you can't use DTS to manage MSDE instances (and more you say that your
SQL Server is a version 7.0 server), you have to rely on backup/restore
and/or sp_detach_db/sp_attach_db solutions
please keep in mind you will probably experiencing orphaned users problems
after that operation(s), you can resolve using system stored procedure
sp_change_users_login
(http://www.sqlservercentral.com/colu...okenlogins.asp)
you can move users databases this way only from 7.0 version to 2000 version,
and not vice versa
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql