Data Generator: how to copy data from multiple fields of a linked row?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
corneliusd
Posts: 24
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:
Contact corneliusd

Data Generator: how to copy data from multiple fields of a linked row?

Post by corneliusd » Thu 13 Aug 2015 05:09

I'm using dbForge Data Generator v3.0.32 and would like to copy several fields from a linked table during the random population of a linked record ID.

The database has a master table, named "Records", of customer records with IDs and names and lots of details. There's another table called "Constituents" that holds a copy of some of the fields in the Records table but with a little bit of additional information if the customer is considered a "constituent" to the organization.

An overview of the tables and fields under discussion follows:

Code: Select all

[Records]
ID (primary key, auto-increment)
Constituent_ID (varchar, nullable)
First_Name (varchar)
etc.

[Constituents]
ID (primary key, auto-increment)
Record_ID (int, foreign key to the Records table)
First_Name (varchar)
etc.
During the random data generation, Constituents.Record_ID gets a random value from the ID field of the Records table. What I want to do is copy over the First_name field from the Records table into the Constituents table for the row in the Records table identified by the Record_ID field. If there was a way to access the random Record_ID value just assigned, then I could write a SQL statement to copy that field.

The only way I can see to do it right now is run a separate SQL script after the data generation is finished. That's not terribly difficult, but it's no longer all together in one Data Generator file--I have to remember to manually run the SQL script separately.

One thought this gives me is that it'd be nice to hook up a SQL statement after each row of a table has been inserted with all the values that were just inserted--sort of an AfterInsert trigger, but not part of the table definition. Then I could use that and randomly generate only the Record_ID after which the custom SQL run using the Record_ID to grab the First_Name field--and whatever else I needed to properly fill the data.

Any thoughts on this idea?

Thanks,
David.
Top
.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by .jp » Fri 14 Aug 2015 14:49

Hello,

Thanks for the post.

You have an old version of dbForge Data Generator installed.
Currently, dbForge Data Generator, v3.5 is available for download, and you can updated to it for free.

In version 3.5, the "Foreign Key (manually assigned) generator, that references a column from parent table" is available in the Basic group.

If you select this generator for the [First_Name] column of the [Constituents] table, select the [First_Name] column of the [Records] column as a parent one, and disable Null values for them, you will receive the desired result on the condition of similar settings of Value Distribution Mode: Random by Seed or Sequential for the First_Name and Record_ID columns of the [Constituents] table.

Please let us know if this helps.

Best Regards.
Top
corneliusd
Posts: 24
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:
Contact corneliusd

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by corneliusd » Sat 15 Aug 2015 00:12

I think that version was being made available while I was asking this question!! ;-)

I noticed a new version right after I posted the question, but didn't have time to try it out right then. I have since updated and believe this will fix my problem. However, there's a new problem with the new version: it crashed upgrading the .DGEN file for the new version. When it's loading the script, which had about 5 tables involved, it gets 67% through the database describe process and fails with the following error text:

Code: Select all

=========================
 General
=========================
Application: dbForge Data Generator for SQL Server
Product: Devart dbForge Data Generator for SQL Server
Product Edition: Standard
Product Locale: English 
Assembly: datagenerator, Version=3.5.37.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Data Generator for SQL Server\datagenerator.exe
Global cache: False
Framework: 4.0.30319.34209

=========================
 Exception Information
=========================
Message: Unable to cast object of type 'System.Xml.XmlNode[]' to type 'Devart.DbForge.DataGeneration.Interfaces.IGeneratorOptions'.
Source: Devart.DbForge.DataGeneration
TargetSite: Void Restore(System.Collections.Generic.IEnumerable`1[Na2IM7RE6oNOSZxN48a.y5IxeqRdltRFTY0DHe4], Devart.DbForge.DataGeneration.DgSettings)
HelpLink: 
Type: System.InvalidCastException
Place: 2
Stack:
   at Xuf4GjRGr3gxj8ePGhf.yMLGuiRBA3FvtyW9Uur.Restore(IEnumerable`1 models, DgSettings settings)
   at gmQuLN6WXcEGUUpwRqt.o4Y5Rj6YWmUQl9DUCgg.RestoreObjectsState(IEnumerable`1 models)
   at gmQuLN6WXcEGUUpwRqt.o4Y5Rj6YWmUQl9DUCgg.QlHLmM1wv8(Object  , xq6woZ6S49TVIZ83jsX  )
   at kUiGi5K2vwfFVlqpjSq.e4lOFJKhsFSUCMmPjud.X8aZ1zH819O(xq6woZ6S49TVIZ83jsX  )
   at kUiGi5K2vwfFVlqpjSq.e4lOFJKhsFSUCMmPjud.YdpZ1b1aRCV(Object  , AsyncOperationEventArgs  )
   at Devart.DbForge.Compare.DatabaseComparison`1.OnDone(AsyncOperationEventArgs e)
   at Devart.DbForge.Compare.DatabaseComparison`1.AsyncOperationDone(AsyncOperationEventArgs e)
   at Devart.DbForge.Compare.DataComparison.AsyncOperationDone(AsyncOperationEventArgs e)
   at khc9AJSApYPwU1pGhX.uckeercAJ69bse5e7V.AsyncOperationDone(AsyncOperationEventArgs  )
   at Devart.DbForge.Compare.DatabaseComparison`1.ttLqF0pBLJ(Object  , AsyncOperationEventArgs  )

=========================
 Window Layout
=========================
Active document window: 'RE7_Sample_1000recs.dgen*' (Design)
Active window: 'RE7_Sample_1000recs.dgen*'
Active document 'RE7_Sample_1000recs.dgen'

Documents:
Name: 'RE7_Sample_1000recs.dgen', Caption: 'RE7_Sample_1000recs.dgen*', Visible: True, Active view: 'Design', Initial view: 'Design'

Toolwindows (visible or have been shown in current session):
Caption: 'Start Page', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed
Caption: 'Output', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked

=========================
 Connections
=========================
WarmThings.local - 'Data Source=(local);Initial Catalog=WarmThings;Integrated Security=True' Category: Development
RE7.localhost (open) - 'Data Source=localhost;Initial Catalog=RE7;Integrated Security=True'. Server version 10.50.4042

=========================
 Loaded Assemblies
=========================
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll 
datagenerator, Version=3.5.37.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.5.37.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/datagenerator.exe 
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll 
Devart.Shell.Interfaces, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Interfaces.DLL 
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll 
Devart.Shell.Studio, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Studio.DLL 
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll 
Devart.Shell.Utils, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Utils.DLL 
Devart.DbForge.Resources, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Resources.DLL 
Devart.Shell.Resources, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Resources.DLL 
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll 
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll 
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 
Devart.Shell.IocService, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.IocService.DLL 
DevExpress.Utils.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.Utils.v13.2.DLL 
DevExpress.Data.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.Data.v13.2.DLL 
DevExpress.XtraEditors.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraEditors.v13.2.DLL 
Autofac, Version=2.6.1.841, Culture=neutral, PublicKeyToken=09af7300eec23701 2.6.1.841 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Autofac.DLL 
DevExpress.XtraBars.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraBars.v13.2.DLL 
Devart.Shell.Controls, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Controls.DLL 
Devart.Shell.TextEditor, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.TextEditor.DLL 
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll 
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll 
Devart.Shell.TextEditor.Interfaces, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.TextEditor.Interfaces.DLL 
Devart.DbForge.Interfaces, Version=4.0.82.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.82.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Interfaces.DLL 
Devart.DbForge.DbObjects.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjects.SqlServer.DLL 
Devart.DbForge.DbObjects, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjects.DLL 
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll 
System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll 
Devart.Studio.Help, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Studio.Help.DLL 
SMDiagnostics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll 
Devart.DbForge.CommonServices, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.CommonServices.DLL 
Devart.DbForge.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.SqlServer.DLL 
Devart.DbForge.Provider, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Provider.DLL 
Devart.DbForge.Data.Interfaces, Version=5.0.19.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.19.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Data.Interfaces.DLL 
Devart.DbForge.Data.SqlServer, Version=2.0.105.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.0.105.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Data.SqlServer.DLL 
Devart.DbForge.Utils, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Utils.DLL 
Devart.DbForge.DataGeneration.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DataGeneration.SqlServer.DLL 
Devart.DbForge.DataGeneration, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DataGeneration.DLL 
Devart.DbForge.Resources.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Resources.SqlServer.DLL 
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null 1.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 
Devart.DbForge.UI, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.UI.DLL 
Devart.DbForge.Compare, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Compare.DLL 
DevExpress.XtraTreeList.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraTreeList.v13.2.DLL 
System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll 
DevExpress.XtraGrid.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraGrid.v13.2.DLL 
DevExpress.Printing.v13.2.Core, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.Printing.v13.2.Core.DLL 
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll 
DevExpress.XtraPrinting.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraPrinting.v13.2.DLL 
System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll 
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null 1.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 
System.ServiceModel.Internals, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll 
System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll 
System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll 
Devart.DbForge.LanguageService.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.LanguageService.SqlServer.DLL 
Devart.DbForge.LanguageService, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.LanguageService.DLL 
Devart.DbForge.Compare.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Compare.SqlServer.DLL 
Devart.Shell.Wizard, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Wizard.DLL 
Devart.DbForge.DbObjectControllers.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjectControllers.SqlServer.DLL 
Devart.DbForge.DbObjectControllers, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjectControllers.DLL 
Devart.DbForge.DbObjectModels.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjectModels.SqlServer.DLL 
Devart.Ole.UndoManager, Version=1.0.295.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.295.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Ole.UndoManager.DLL 
Antlr4.StringTemplate, Version=4.0.7.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.7.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Antlr4.StringTemplate.DLL 
Antlr4.Runtime, Version=3.5.0.2, Culture=neutral, PublicKeyToken=09af7300eec23701 3.5.0.2 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Antlr4.Runtime.DLL 
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Antlr3.Runtime.DLL 
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll 
Microsoft.CSharp, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll 
Ionic.Zip.Reduced, Version=1.9.1.2, Culture=neutral, PublicKeyToken=09af7300eec23701 1.9.1.2 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Ionic.Zip.Reduced.DLL 
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null 1.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 

=========================
 System Information
=========================
Processor architecture: amd64
Processor quantity: 2
Intel(R) Core(TM) i5-4690K CPU @ 3.50GHz  Intel64 Family 6 Model 60 Stepping 3
Intel(R) Core(TM) i5-4690K CPU @ 3.50GHz  Intel64 Family 6 Model 60 Stepping 3

Total physical memory: 6207Mb
Total available paginal memory: 10082Mb
Process available virtual memory: 8387686Mb
Process private memory size: 175Mb
Display1: 1920x1080, 100% DPI

Operating System Name: Windows 7 Professional
Operating System Version: Microsoft Windows NT 6.1.7601 Service Pack 1
UAC status: Enabled
UAC level: Notify when app try to make changes
Is user in admin group: True
Is run as admin: False
Is process elevated: False
Elevation type: Limited
Integrity level: Medium

Instances: 1
Culture: English (United States)
Process started at 08/14/2015 17:01:15
Report created at 08/14/2015 17:03:15
I think I'll just re-create the data generation and try your suggestion.

Thanks,
David.
Top
corneliusd
Posts: 24
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:
Contact corneliusd

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by corneliusd » Sun 16 Aug 2015 23:59

I've re-created the generation script and have a couple of questions that still have me stuck.

1. How do I update a parent table after a child record has been created? With my original table structure listed previously where [Records] is the parent table and [Constituents] is the child table, there are two fields in [Records] that need to be updated if/when a child record in [Constituents] is created. First, [Records].IS_CONSTITUENT needs to be changed from 0 (false) to -1 (true); and second, [Records].CONSTITUENT_ID needs to get the new [Constituents].ID.

2. How do I set fields based on the random value of other fields? There is a field called KEY_INDICATOR that needs to be set to either 'I' (for Individual) or 'O' (for Organization) depending on whether the record indicates a person or a business. If it's an individual, I need to set FIRST_NAME and LAST_NAME (randomly, of course) but if it's an organization, I need to set ORGANIZATION_NAME.

It looks like there are macros that can be used and I'm wondering if there is any scripting available, like checking the value of another column? That would be nifty!

I also noticed that I can generate a SQL script rather than execute it immediately, so this may be the way to solve my problems listed above as I can always add my custom SQL at the end.

Thanks,
David.
Top
alexa

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by alexa » Mon 17 Aug 2015 09:33

We are currently reviewing your questions and will answer you as soon as possible.
Top
alexa

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by alexa » Mon 17 Aug 2015 12:09

This issue will be fixed in the next product build. In the meanwhile, in order to fix this, please open the *.dgen document with some text editor, for example, Notepad and replace

Code: Select all

<DataGenDocument xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Version="3.0">
with

Code: Select all

<DataGenDocument xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Version="2.0">
Then, you'll be asked to convert the document. This time it should pass correctly.
Top
corneliusd
Posts: 24
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:
Contact corneliusd

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by corneliusd » Mon 17 Aug 2015 14:08

Thanks, it got a little further in the process, but still failed with this information:

Code: Select all

=========================
 General
=========================
Application: dbForge Data Generator for SQL Server
Product: Devart dbForge Data Generator for SQL Server
Product Edition: Standard
Product Locale: English 
Assembly: datagenerator, Version=3.5.37.0, Culture=neutral, PublicKeyToken=09af7300eec23701
R:\Retail8\RDI\dbForge Data Generator for SQL Server\datagenerator.exe
Global cache: False
Framework: 4.0.30319.18444

=========================
 Exception Information
=========================
Message: Unable to cast object of type 'System.Xml.XmlNode[]' to type 'Devart.DbForge.DataGeneration.Interfaces.IGeneratorOptions'.
Source: Devart.DbForge.DataGeneration
TargetSite: Void Restore(System.Collections.Generic.IEnumerable`1[Na2IM7RE6oNOSZxN48a.y5IxeqRdltRFTY0DHe4], Devart.DbForge.DataGeneration.DgSettings)
HelpLink: 
Type: System.InvalidCastException
Place: 2
Stack:
   at Xuf4GjRGr3gxj8ePGhf.yMLGuiRBA3FvtyW9Uur.Restore(IEnumerable`1 models, DgSettings settings)
   at gmQuLN6WXcEGUUpwRqt.o4Y5Rj6YWmUQl9DUCgg.RestoreObjectsState(IEnumerable`1 models)
   at gmQuLN6WXcEGUUpwRqt.o4Y5Rj6YWmUQl9DUCgg.QlHLmM1wv8(Object  , xq6woZ6S49TVIZ83jsX  )
   at kUiGi5K2vwfFVlqpjSq.e4lOFJKhsFSUCMmPjud.X8aZ1zH819O(xq6woZ6S49TVIZ83jsX  )
   at kUiGi5K2vwfFVlqpjSq.e4lOFJKhsFSUCMmPjud.YdpZ1b1aRCV(Object  , AsyncOperationEventArgs  )
   at Devart.DbForge.Compare.DatabaseComparison`1.OnDone(AsyncOperationEventArgs e)
   at Devart.DbForge.Compare.DatabaseComparison`1.AsyncOperationDone(AsyncOperationEventArgs e)
   at Devart.DbForge.Compare.DataComparison.AsyncOperationDone(AsyncOperationEventArgs e)
   at khc9AJSApYPwU1pGhX.uckeercAJ69bse5e7V.AsyncOperationDone(AsyncOperationEventArgs  )
   at Devart.DbForge.Compare.DatabaseComparison`1.ttLqF0pBLJ(Object  , AsyncOperationEventArgs  )

=========================
 Window Layout
=========================
Active document window: 'RE7_Sample_1000recs.dgen' (Design)
Active window: 'RE7_Sample_1000recs.dgen'
Active document 'RE7_Sample_1000recs.dgen'

Documents:
Name: 'RE7_Sample_1000recs.dgen', Caption: 'RE7_Sample_1000recs.dgen', Visible: True, Active view: 'Design', Initial view: 'Design'

Toolwindows (visible or have been shown in current session):
Caption: 'Start Page', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed

=========================
 Connections
=========================
RE7_SAMPLE.COLTV9\RE_EXPRESS (open) - 'Data Source=COLTV9\RE_EXPRESS;Initial Catalog=RE7_SAMPLE;Integrated Security=True'. Server version 09.00.5000
RE7_SAMPLE - 'Data Source=Coltv9\RE_EXPRESS;Initial Catalog=RE7_SAMPLE;Integrated Security=True'

=========================
 Loaded Assemblies
=========================
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll 
datagenerator, Version=3.5.37.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.5.37.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/datagenerator.exe 
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll 
Devart.Shell.Utils, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Shell.Utils.DLL 
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll 
Devart.Shell.Studio, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Shell.Studio.DLL 
Devart.Shell.Interfaces, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Shell.Interfaces.DLL 
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll 
Devart.DbForge.Resources, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.Resources.DLL 
Devart.Shell.Resources, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Shell.Resources.DLL 
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll 
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll 
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 
Devart.Shell.IocService, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Shell.IocService.DLL 
DevExpress.Utils.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/DevExpress.Utils.v13.2.DLL 
DevExpress.Data.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/DevExpress.Data.v13.2.DLL 
DevExpress.XtraEditors.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/DevExpress.XtraEditors.v13.2.DLL 
Autofac, Version=2.6.1.841, Culture=neutral, PublicKeyToken=09af7300eec23701 2.6.1.841 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Autofac.DLL 
DevExpress.XtraBars.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/DevExpress.XtraBars.v13.2.DLL 
Devart.Shell.Controls, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Shell.Controls.DLL 
Devart.Shell.TextEditor, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Shell.TextEditor.DLL 
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll 
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll 
Devart.Shell.TextEditor.Interfaces, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Shell.TextEditor.Interfaces.DLL 
Devart.DbForge.Interfaces, Version=4.0.82.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.82.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.Interfaces.DLL 
Devart.DbForge.DbObjects.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjects.SqlServer.DLL 
Devart.DbForge.DbObjects, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjects.DLL 
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll 
System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll 
SMDiagnostics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll 
Devart.Studio.Help, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Studio.Help.DLL 
Devart.DbForge.CommonServices, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.CommonServices.DLL 
Devart.DbForge.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.SqlServer.DLL 
Devart.DbForge.Provider, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.Provider.DLL 
System.ServiceModel.Internals, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll 
System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll 
Devart.DbForge.Data.Interfaces, Version=5.0.19.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.19.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.Data.Interfaces.DLL 
Devart.DbForge.Data.SqlServer, Version=2.0.105.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.0.105.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.Data.SqlServer.DLL 
Devart.DbForge.Utils, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.Utils.DLL 
Devart.DbForge.DataGeneration.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.DataGeneration.SqlServer.DLL 
Devart.DbForge.DataGeneration, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.DataGeneration.DLL 
Devart.DbForge.Resources.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.Resources.SqlServer.DLL 
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null 1.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 
Devart.DbForge.UI, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.UI.DLL 
Devart.DbForge.Compare, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.Compare.DLL 
DevExpress.XtraTreeList.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/DevExpress.XtraTreeList.v13.2.DLL 
System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll 
DevExpress.XtraGrid.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/DevExpress.XtraGrid.v13.2.DLL 
DevExpress.Printing.v13.2.Core, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/DevExpress.Printing.v13.2.Core.DLL 
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll 
DevExpress.XtraPrinting.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/DevExpress.XtraPrinting.v13.2.DLL 
System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll 
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null 1.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 
Devart.DbForge.Compare.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.Compare.SqlServer.DLL 
Devart.Shell.Wizard, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Shell.Wizard.DLL 
Devart.DbForge.LanguageService.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.LanguageService.SqlServer.DLL 
Devart.DbForge.LanguageService, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.LanguageService.DLL 
Devart.DbForge.DbObjectControllers.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjectControllers.SqlServer.DLL 
Devart.DbForge.DbObjectControllers, Version=6.0.1444.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1444.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjectControllers.DLL 
System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll 
Devart.Ole.UndoManager, Version=1.0.295.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.295.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.Ole.UndoManager.DLL 
Devart.DbForge.DbObjectModels.SqlServer, Version=5.0.175.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.175.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjectModels.SqlServer.DLL 
Antlr4.StringTemplate, Version=4.0.7.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.7.0 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Antlr4.StringTemplate.DLL 
Antlr4.Runtime, Version=3.5.0.2, Culture=neutral, PublicKeyToken=09af7300eec23701 3.5.0.2 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Antlr4.Runtime.DLL 
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Antlr3.Runtime.DLL 
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll 
Microsoft.CSharp, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll 
Ionic.Zip.Reduced, Version=1.9.1.2, Culture=neutral, PublicKeyToken=09af7300eec23701 1.9.1.2 R:/Retail8/RDI/dbForge Data Generator for SQL Server/Ionic.Zip.Reduced.DLL 

=========================
 System Information
=========================
Processor architecture: amd64
Processor quantity: 4
Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz  Intel64 Family 6 Model 42 Stepping 7
Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz  Intel64 Family 6 Model 42 Stepping 7
Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz  Intel64 Family 6 Model 42 Stepping 7
Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz  Intel64 Family 6 Model 42 Stepping 7

Total physical memory: 8089Mb
Total available paginal memory: 5599Mb
Process available virtual memory: 8387710Mb
Process private memory size: 136Mb
Display1: 1920x1080, 100% DPI

Operating System Name: Windows 7 Professional
Operating System Version: Microsoft Windows NT 6.1.7601 Service Pack 1
UAC status: Disabled
UAC level: Never Notify
Is user in admin group: True
Is run as admin: True
Is process elevated: True
Elevation type: Default
Integrity level: High

Instances: 1
Culture: English (United States)
Process started at 08/17/2015 07:06:12
Report created at 08/17/2015 07:07:05
I'm not terribly worried about upgrading it as I've already recreated a new one.

David.
Top
alexa

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by alexa » Mon 17 Aug 2015 14:57

Thank you for the reply and sorry for the confusion.

The provided instruction was to use it in the upcoming product build in order to reconvert the documents made with the old product build (which is the latest available one at the moment).
Top
corneliusd
Posts: 24
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:
Contact corneliusd

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by corneliusd » Mon 17 Aug 2015 15:03

Oh yes, I see that now. I should've read that more carefully.
Top
alexa

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by alexa » Tue 18 Aug 2015 10:53

We would like to let you know that we have released a new build 3.5.39 of dbForge Data Generator for SQL Server where the issue you reported is fixed https://www.devart.com/dbforge/sql/data ... nload.html

Thank you for your help in improving dbForge Data Generator for SQL Server.
Top
corneliusd
Posts: 24
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:
Contact corneliusd

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by corneliusd » Tue 18 Aug 2015 14:52

I tried the new build and got the same error:

Code: Select all

=========================
 General
=========================
Application: dbForge Data Generator for SQL Server
Product: Devart dbForge Data Generator for SQL Server
Product Edition: Standard
Product Locale: English 
Assembly: datagenerator, Version=3.5.39.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Data Generator for SQL Server\datagenerator.exe
Global cache: False
Framework: 4.0.30319.34209

=========================
 Exception Information
=========================
Message: Unable to cast object of type 'System.Xml.XmlNode[]' to type 'Devart.DbForge.DataGeneration.Interfaces.IGeneratorOptions'.
Source: Devart.DbForge.DataGeneration
TargetSite: Void Restore(System.Collections.Generic.IEnumerable`1[iwCP1o5j5lYf0Itf62j.Byhuvf5S7UcPcQhpuVl], Devart.DbForge.DataGeneration.DgSettings)
HelpLink: 
Type: System.InvalidCastException
Place: 2
Stack:
   at GoXW8A5sXeAG6m6opNV.dal8lS5WYXblNWXiOdc.Restore(IEnumerable`1 models, DgSettings settings)
   at kPSD6c2aCYy8uW9QuXD.uIv1wt2lOdSebI8MPBo.RestoreObjectsState(IEnumerable`1 models)
   at kPSD6c2aCYy8uW9QuXD.uIv1wt2lOdSebI8MPBo.kV7j4YDBlE(Object  , mBwcIr2gY9J3ckdK2tb  )
   at FaoKmqoEB1jg7b5gpFc.NUWX0UoGGqXFfcM8s0r.rLAW93Q7UAg(mBwcIr2gY9J3ckdK2tb  )
   at FaoKmqoEB1jg7b5gpFc.NUWX0UoGGqXFfcM8s0r.PGTW2bWtPWU(Object  , AsyncOperationEventArgs  )
   at Devart.DbForge.Compare.DatabaseComparison`1.OnDone(AsyncOperationEventArgs e)
   at Devart.DbForge.Compare.DatabaseComparison`1.AsyncOperationDone(AsyncOperationEventArgs e)
   at Devart.DbForge.Compare.DataComparison.AsyncOperationDone(AsyncOperationEventArgs e)
   at KAFC3LaKY03IvsFnox.iYL9UuuRZLKU3gOjjQ.AsyncOperationDone(AsyncOperationEventArgs  )
   at Devart.DbForge.Compare.DatabaseComparison`1.RMOw7uIYai(Object  , AsyncOperationEventArgs  )

=========================
 Window Layout
=========================
Active document window: 'RE7_Sample_1000recs.dgen*' (Design)
Active window: 'RE7_Sample_1000recs.dgen*'
Active document 'RE7_Sample_1000recs.dgen'

Documents:
Name: 're7.dgen', Caption: 're7.dgen', Visible: False, Initial view: ''
Name: 'RE7_Sample_1000recs.dgen', Caption: 'RE7_Sample_1000recs.dgen*', Visible: True, Active view: 'Design', Initial view: 'Design'

Toolwindows (visible or have been shown in current session):
Caption: 'Start Page', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed
Caption: 'Output', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Error List', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked

=========================
 Connections
=========================
WarmThings.local - 'Data Source=(local);Initial Catalog=WarmThings;Integrated Security=True' Category: Development
RE7.localhost (open) - 'Data Source=localhost;Initial Catalog=RE7;Integrated Security=True'. Server version 10.50.4042

=========================
 Loaded Assemblies
=========================
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll 
datagenerator, Version=3.5.39.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.5.39.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/datagenerator.exe 
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll 
Devart.Shell.Interfaces, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Interfaces.DLL 
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll 
Devart.Shell.Studio, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Studio.DLL 
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll 
Devart.Shell.Utils, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Utils.DLL 
Devart.DbForge.Resources, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Resources.DLL 
Devart.Shell.Resources, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Resources.DLL 
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll 
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll 
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 
Devart.Shell.IocService, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.IocService.DLL 
DevExpress.Utils.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.Utils.v13.2.DLL 
DevExpress.Data.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.Data.v13.2.DLL 
DevExpress.XtraEditors.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraEditors.v13.2.DLL 
Autofac, Version=2.6.1.841, Culture=neutral, PublicKeyToken=09af7300eec23701 2.6.1.841 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Autofac.DLL 
DevExpress.XtraBars.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraBars.v13.2.DLL 
Devart.Shell.Controls, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Controls.DLL 
Devart.Shell.TextEditor, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.TextEditor.DLL 
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll 
Devart.Shell.TextEditor.Interfaces, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.TextEditor.Interfaces.DLL 
Devart.Studio.Help, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Studio.Help.DLL 
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll 
DevExpress.XtraGrid.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraGrid.v13.2.DLL 
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll 
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll 
DevExpress.Printing.v13.2.Core, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.Printing.v13.2.Core.DLL 
Devart.DbForge.Interfaces, Version=4.0.82.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.82.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Interfaces.DLL 
Devart.DbForge.DbObjects.SqlServer, Version=5.0.183.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.183.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjects.SqlServer.DLL 
Devart.DbForge.DbObjects, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjects.DLL 
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll 
System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll 
SMDiagnostics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll 
Devart.DbForge.CommonServices, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.CommonServices.DLL 
Devart.DbForge.SqlServer, Version=5.0.183.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.183.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.SqlServer.DLL 
Devart.DbForge.Provider, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Provider.DLL 
Devart.DbForge.Data.Interfaces, Version=5.0.19.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.19.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Data.Interfaces.DLL 
Devart.DbForge.Data.SqlServer, Version=2.0.105.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.0.105.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Data.SqlServer.DLL 
Devart.DbForge.Utils, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Utils.DLL 
Devart.DbForge.DataGeneration.SqlServer, Version=5.0.183.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.183.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DataGeneration.SqlServer.DLL 
Devart.DbForge.DataGeneration, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DataGeneration.DLL 
System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll 
Devart.DbForge.Compare, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Compare.DLL 
Devart.DbForge.Resources.SqlServer, Version=5.0.183.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.183.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Resources.SqlServer.DLL 
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null 1.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 
System.ServiceModel.Internals, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll 
System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll 
Devart.DbForge.UI, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.UI.DLL 
DevExpress.XtraTreeList.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraTreeList.v13.2.DLL 
System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll 
DevExpress.XtraPrinting.v13.2, Version=13.2.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 13.2.8.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/DevExpress.XtraPrinting.v13.2.DLL 
Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null 1.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll 
Devart.DbForge.Compare.SqlServer, Version=5.0.183.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.183.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.Compare.SqlServer.DLL 
Devart.Shell.Wizard, Version=2.1.18.0, Culture=neutral, PublicKeyToken=09af7300eec23701 2.1.18.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Shell.Wizard.DLL 
Devart.DbForge.LanguageService.SqlServer, Version=5.0.183.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.183.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.LanguageService.SqlServer.DLL 
Devart.DbForge.LanguageService, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.LanguageService.DLL 
Devart.DbForge.DbObjectControllers.SqlServer, Version=5.0.183.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.183.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjectControllers.SqlServer.DLL 
Devart.DbForge.DbObjectControllers, Version=6.0.1452.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.0.1452.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjectControllers.DLL 
System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll 
Devart.DbForge.DbObjectModels.SqlServer, Version=5.0.183.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.183.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.DbForge.DbObjectModels.SqlServer.DLL 
Devart.Ole.UndoManager, Version=1.0.295.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.295.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Devart.Ole.UndoManager.DLL 
Antlr4.StringTemplate, Version=4.0.7.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.7.0 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Antlr4.StringTemplate.DLL 
Antlr4.Runtime, Version=3.5.0.2, Culture=neutral, PublicKeyToken=09af7300eec23701 3.5.0.2 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Antlr4.Runtime.DLL 
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Antlr3.Runtime.DLL 
Microsoft.CSharp, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll 
Ionic.Zip.Reduced, Version=1.9.1.2, Culture=neutral, PublicKeyToken=09af7300eec23701 1.9.1.2 C:/Program Files/Devart/dbForge Data Generator for SQL Server/Ionic.Zip.Reduced.DLL 

=========================
 System Information
=========================
Processor architecture: amd64
Processor quantity: 2
Intel(R) Core(TM) i5-4690K CPU @ 3.50GHz  Intel64 Family 6 Model 60 Stepping 3
Intel(R) Core(TM) i5-4690K CPU @ 3.50GHz  Intel64 Family 6 Model 60 Stepping 3

Total physical memory: 6207Mb
Total available paginal memory: 10349Mb
Process available virtual memory: 8387734Mb
Process private memory size: 131Mb
Display1: 1920x1080, 100% DPI

Operating System Name: Windows 7 Professional
Operating System Version: Microsoft Windows NT 6.1.7601 Service Pack 1
UAC status: Enabled
UAC level: Notify when app try to make changes
Is user in admin group: True
Is run as admin: True
Is process elevated: True
Elevation type: Full
Integrity level: High

Instances: 1
Culture: English (United States)
Process started at 08/18/2015 07:48:27
Report created at 08/18/2015 07:49:13
Sorry to have to report that!
David.
Top
corneliusd
Posts: 24
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:
Contact corneliusd

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by corneliusd » Tue 18 Aug 2015 14:59

If you'd like, we can take this offline and I can send you more details by email.
Top
alexa

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by alexa » Thu 20 Aug 2015 09:36

Could you please let us know if you changed Version="3.0" to Version="2.0" per our previous recommendation? If the error report pops up despite you changed it, could you please send us the *.dgen file for investigation?

You can send a reply straight to our support system at supportATdevartDOTcom
Top
corneliusd
Posts: 24
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:
Contact corneliusd

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by corneliusd » Mon 24 Aug 2015 15:22

Yes, I changed the Version= tag.

But like I said, I've recreated the script and so am not worried about getting the original script upgraded anymore.

Thanks,
David.
Top
alexa

Re: Data Generator: how to copy data from multiple fields of a linked row?

Post by alexa » Tue 25 Aug 2015 09:50

Thank you for updating us on this issue.

Please let us know if any questions arise.
Top
Post Reply

Return to “dbForge for SQL Server”