sql server msde: Making a copy of an SQL 7 database into an MSDE environment -- sql server msde

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

dkalling
12/29/2004 11:26:49 AM

sql server msde:

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.

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

Andrea Montanari
12/30/2004 12:17:45 PM

hi Dave,
"dkalling" <dkalling@cnx2.com> ha scritto nel messaggio
news:04c001c4eddc$579de490$a401280a@phx.gbl
[quoted text, click to view]

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/columnists/nboyle/fixingbrokenlogins.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.shtm http://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