<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=147573719-11102004><FONT face=Arial
color=#0000ff size=2>You can use the Enterprise Manager tool to create a backup
of a database. Then use the same tool at your client to restore the
database. I use this all the time to copy databases between servers.
Works a treat.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=147573719-11102004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=147573719-11102004><FONT face=Arial
color=#0000ff size=2>SQL Server 2000, but I suppose there's something similar in
any version.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=147573719-11102004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=147573719-11102004><FONT face=Arial
color=#0000ff size=2>Not sure what you mean by removable database, I'm
afraid.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=147573719-11102004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=147573719-11102004><FONT face=Arial
color=#0000ff size=2>HTH,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=147573719-11102004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=147573719-11102004><FONT face=Arial
color=#0000ff size=2>Conor</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT size=2><FONT
face=Tahoma><B>From:</B> Jeremy Coulter [mailto:vss@vss.co.nz] <BR><SPAN
class=147573719-11102004><FONT face=Arial
color=#0000ff> </FONT></SPAN></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT size=2><SPAN
class=156412519-11102004><FONT face=Arial>Just following on from my question
yesterday, one of the things we are going to want to do is distribute an MSSQL
db to the customer. We need to do this as appossed to just creating the database
and tables on the fly, is that a couple of tables need pre-populated data in
them.</FONT></SPAN></FONT></DIV>
<DIV><SPAN class=156412519-11102004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156412519-11102004><FONT face=Arial size=2>I know you can
create a "Removable Database" in MSSQL, which pretty much takes a copy of the
database with out detaching it from the original SQL Server...I think thats how
it works.</FONT></SPAN></DIV>
<DIV><SPAN class=156412519-11102004><FONT face=Arial size=2>I will then just re
attach it, although I need to investigate this bit some
more.</FONT></SPAN></DIV>
<DIV><SPAN class=156412519-11102004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=156412519-11102004><FONT face=Arial size=2>Anyone do anything
like this now?</FONT></SPAN></DIV></BODY></HTML>