<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o xmlns:st1><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Jeremy</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>If the pre populated data is the same for all
installations you should just insert it as part of your script. In my
opinion a script offers the best / simplest installation.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>Rob Martin<BR>Software Engineer<BR> <BR>phone 03 377 0495<BR>fax 03
377 0496 <BR>web <A
href="http://www.chreos.com">www.chreos.com</A><BR>Wild Software Ltd</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=vss@vss.co.nz href="mailto:vss@vss.co.nz">Jeremy Coulter</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=delphi@ns3.123.co.nz
href="mailto:delphi@ns3.123.co.nz">NZ Borland Developers Group - Delphi
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, October 12, 2004 9:11
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [DUG] Distributing MSSQL
DBs</DIV>
<DIV><BR></DIV>
<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.<o:p></o:p></SPAN></FONT></P></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>
<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></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>
<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></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>
<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></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>
<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> <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></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>
<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></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT>
<DIV></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></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT>
<DIV></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></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT>
<DIV></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></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT>
<DIV></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></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 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></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>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<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></P></DIV>
<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></P></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<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></P></DIV>
<DIV></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>
<P>
<HR>
<P></P>_______________________________________________<BR>Delphi mailing
list<BR>Delphi@ns3.123.co.nz<BR>http://ns3.123.co.nz/mailman/listinfo/delphi<BR></BLOCKQUOTE></BODY></HTML>