Thanks for pointing out and remind me about the potential issues with date and time format. My experience is with SQL Server/SSCE/Access and also lately with SQLite.<br><br>Again thanks for the kind input.<br><br>With kind regards,<br>
Dennis Wallentin<br>-----------------------------------------------------------------------<br>Microsoft Excel Microsoft Valuable Professional (MVP)<br><br>XL-Dennis about .NET & MS Excel<br><a href="http://xldennis.wordpress.com/">http://xldennis.wordpress.com/</a><br>
<br>XL-Dennis Consulting<br><a href="http://www.excelkb.com/index.htm">http://www.excelkb.com/index.htm</a><br>-----------------------------------------------------------------------<br><br><br><div class="gmail_quote">
2011/1/10 william humphrey <span dir="ltr"><<a href="mailto:bill@bluewatermaritime.com" target="_blank">bill@bluewatermaritime.com</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Test data in SQL would work for any database including Valentina. Please test out different date and time formats too.<div><div></div><div><br><br><div class="gmail_quote">On Mon, Jan 10, 2011 at 8:37 AM, XL-Dennis GMail <span dir="ltr"><<a href="mailto:xldennis@gmail.com" target="_blank">xldennis@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="SV"><div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">OK and thanks for kind feedback. So there does not exist any specific tool targeting VDB.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Kind regards,</span></p><p class="MsoNormal">
<span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Dennis Wallentin</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">-------------------------------------------------------------------</span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Microsoft Excel Microsoft Valuable Professional (MVP)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">XL-Dennis Blog about .NET & VSTO & Excel:</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><a href="http://xldennis.wordpress.com/" target="_blank">http://xldennis.wordpress.com/</a></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">XL-Dennis Excel Consulting:</span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><a href="http://www.excelkb.com/index.htm" target="_blank">http://www.excelkb.com/index.htm</a></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">-------------------------------------------------------------------</span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> <span lang="EN-US"></span></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p><div>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">Från:</span></b><span style="font-size: 10pt;"> <a href="mailto:valentina-bounces@lists.macserve.net" target="_blank">valentina-bounces@lists.macserve.net</a> [mailto:<a href="mailto:valentina-bounces@lists.macserve.net" target="_blank">valentina-bounces@lists.macserve.net</a>] <b>För </b>Bart Pietercil<br>
<b>Skickat:</b> den 10 januari 2011 08:42<br><b>Till:</b> Valentina Developers<br><b>Ämne:</b> Re: Tool for generate test data?</span></p></div></div><div><div></div><div><p class="MsoNormal"> </p><p class="MsoNormal">
<a href="http://sourceforge.net/projects/dbmonster/" target="_blank">http://sourceforge.net/projects/dbmonster/</a></p><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">google for 'generate test data';</p>
</div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal"> </p><div><p class="MsoNormal">Bart Pietercil<br>CTO Cognosis NV </p></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal">On 10 Jan 2011, at 02:04, Barry G. Sumpter wrote:</p>
</div><p class="MsoNormal"><br><br></p><div><div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">One or two of the examples that come with Valentina does it.</span><span lang="EN-US"></span></p>
</div><div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">You can modify it to your own specs.</span><span lang="EN-US"></span></p></div><div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span><span lang="EN-US"></span></p>
</div><div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span><span lang="EN-US"></span></p></div><div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span><span lang="EN-US"></span></p>
</div><div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0cm 0cm;"><div><p class="MsoNormal"><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span><span style="font-size: 10pt;" lang="EN-US"> </span></span><span style="font-size: 10pt;" lang="EN-US"><a href="mailto:valentina-bounces@lists.macserve.net" target="_blank">valentina-bounces@lists.macserve.net</a><span> </span>[mailto:<a href="mailto:valentina-bounces@lists.macserve.net" target="_blank">valentina-bounces@lists.macserve.net</a>]<span> </span><b>On Behalf Of<span> </span></b>Dennis Wallentin<br>
<b>Sent:</b><span> </span>Monday, 10 January 2011 11:06 AM<br><b>To:</b><span> </span><a href="mailto:valentina@lists.macserve.net" target="_blank">valentina@lists.macserve.net</a><br><b>Subject:</b><span> </span>Tool for generate test data?</span><span lang="EN-US"></span></p>
</div></div><div><p class="MsoNormal"><span lang="EN-US"> </span></p></div><div><p class="MsoNormal"><span lang="EN-US">Hi all,<br><br>Does it exist any tool (third-party tool included) that create test databases and can fill them with larger amount of test data?<br>
<br>TIA,<br>Dennis<br clear="all"></span></p></div><p class="MsoNormal"><span style="font-size: 13.5pt;" lang="EN-US">_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a></span></p></div></div><p class="MsoNormal"> </p></div></div></div></div></div><br>_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
<br></blockquote></div><br><br clear="all"><br></div></div><font color="#888888">-- <br><a href="http://www.bluewatermaritime.com" target="_blank">http://www.bluewatermaritime.com</a><br>
</font><br>_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>With kind regards,<br>Dennis W<br>-------------------------------------------------<br>XL-Dennis about .NET & MS Excel<br><a href="http://xldennis.wordpress.com/" target="_blank">http://xldennis.wordpress.com/</a><br>
<br>XL-Dennis Consulting<br><a href="http://www.excelkb.com/index.htm" target="_blank">http://www.excelkb.com/index.htm</a><br>