<HTML><BODY>
<DIV>yes, but this does not get round the need for the DB to have
pre-populated data as in my original email.</DIV>
<DIV>I COULD I guess import form an Access DB or even from Excel (which is
prob. better) but if I am using MSDE which I prob. will in a lot of cases I
suspect, it becomes a little more difficult, AND also I want to try to do a
lot of this with no user intervention.</DIV>
<DIV>I realise I will prob. have to do some custom stuff for this, and thats
fine.</DIV>
<DIV> </DIV>
<DIV>Jeremy<BR></DIV>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">-----Original
Message-----<BR>From: "Stephen Bertram"
<stephen.bertram@ensynergy.co.nz><BR>To: "NZ Borland Developers Group
- Delphi List" <delphi@ns3.123.co.nz><BR>Date: Tue, 12 Oct 2004
09:02:59 +1300<BR>Subject: RE: [DUG] Distributing MSSQL DBs<BR><BR>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">You’re correct
Conor, but there are often issues as the database retains the original
security settings and unless the client environment is compatible you can
spend hours on the phone to the client tweaking things to make the data
available.<?xml:namespace prefix = o /><o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p>
</SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">We script the
structures and data out to a SQLscript which can create the database and
tables if required and then update or insert the rows. A little more
trouble, but it makes installation and maintenance of common data across the
clients a snip. If written carefully it can be db independent which
allows operation across a wide range of environments (MSSQL, Ingres, Sybase,
Oracle, …..)<o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p>
</SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">$0.02<o:p></o:p>
</SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p>
</SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Stephen<o:p></o:p>
</SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p>
</SPAN></FONT></DIV>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN lang=EN-US
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN>
</FONT></B><FONT face=Tahoma size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt;
FONT-FAMILY: Tahoma"> delphi-bounces@ns3.123.co.nz
[mailto:delphi-bounces@ns3.123.co.nz] <B><SPAN style="FONT-WEIGHT: bold">On
Behalf Of </SPAN></B>Conor.Boyd@sungard.com<BR><B><SPAN style="FONT-WEIGHT:
bold">Sent:</SPAN></B> Tuesday, 12 October 2004 8:40 a.m.<BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> <?xml:namespace prefix = st1 />
<st1:PersonName w:st="on">vss@vss.co.nz</st1:PersonName>;
delphi@ns3.123.co.nz<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN>
</B> RE: [DUG] Distributing MSSQL DBs</SPAN></FONT><SPAN lang=EN-US><o:p>
</o:p></SPAN></DIV></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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.</SPAN>
</FONT><o:p></o:p></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">SQL Server 2000,
but I suppose there's something similar in any version.</SPAN></FONT><o:p>
</o:p></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Not sure what you
mean by removable database, I'm afraid.</SPAN></FONT><o:p></o:p></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">HTH,</SPAN></FONT>
<o:p></o:p></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Conor</SPAN></FONT>
<o:p></o:p></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN lang=EN-US
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN>
</FONT></B><FONT face=Tahoma size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt;
FONT-FAMILY: Tahoma"> Jeremy Coulter [mailto:<st1:PersonName w:st="on">
vss@vss.co.nz</st1:PersonName>] <BR></SPAN></FONT><FONT face=Arial
color=blue size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: blue;
FONT-FAMILY: Arial"> </SPAN></FONT><SPAN lang=EN-US><o:p></o:p></SPAN>
</DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: 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.</SPAN></FONT><SPAN lang=EN-US><o:p></o:p>
</SPAN></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial">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.</SPAN></FONT><o:p>
</o:p></DIV></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial">I will then just re attach it, although I need to
investigate this bit some more.</SPAN></FONT><o:p></o:p></DIV></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV></DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial">Anyone do anything like this now?</SPAN></FONT><o:p>
</o:p></DIV></DIV></DIV>
<DIV>
<DIV><FONT size=2>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<BR>This communication contains information that is confidential and the
copyright of ensynergy Limited or a third party. <BR><BR>If you are not the
intended recipient of this communication please delete and destroy all
copies and telephone ensynergy Limited on +64 9 3551591 immediately. If you
are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of ensynergy
Limited. <BR><BR>Any views expressed in this communication are those of the
individual sender, except where the sender specifically states them to be
the views of ensynergy Limited. <BR><BR>Except as required by law, ensynergy
Limited does not represent, warrant and/or guarantee that the integrity of
this communication has been maintained nor that the communication is free of
errors, virus, interception or interference. <BR></FONT></DIV></DIV>
</BLOCKQUOTE>
</BODY></HTML>