Groups | Blog | Home
all groups > sql server dts > february 2004 >

sql server dts : Can Copy DB Wizard overwrite Master SPs?


Fiona
2/20/2004 1:31:12 PM
Jared F
2/20/2004 7:41:06 PM
Allan Mitchell
2/21/2004 7:51:39 AM
Are we talking about the Transfer Databases Task in 2000? AFAIK that didn't
allow you to take over system databases i.e. Master.
Or are welking about the Transfer objects task which does allow you to move
things from master?

The latter will not show you objects defined as being SYSTEM.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
overwritten, but I don't know for sure.

Fiona
2/23/2004 6:06:06 AM
Darren Green
2/24/2004 7:29:48 PM
In message <575DE80C-5186-4F73-9DE4-6858CFA510BD@microsoft.com>, Fiona
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

Not familiar with the Wizard, but I if it is a concern/problem why not
try one of the numerous database compare tools available, e.g.

Compare and synchronize the structure of SQL Server databases
(http://www.red-gate.com/SQL_Compare.htm)


Apex SQL Tools: SQL tools for Database comparison and synchronization
(http://www.apexsql.com/index_sqldiff.htm)


There are loads more, but they are two companies I can remember the Url
for to have a quick look. I like Red-Gate myself, but haven't really
done a proper market comparison.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
Darren Fuller
3/15/2004 1:33:49 PM
Also check out DB Ghost from Innovartis at http://www.dbghost.com for
database comparison, synchronisation AND change management.

Darren Fuller
SQL Server DBA MCSE

*** Sent via Developersdex http://www.developersdex.com ***
AddThis Social Bookmark Button