'Build Inserts from Table' template

[dnparsons]

I wanted to move some test data from MSDE to an Advantage db. Since I already had MyGeneration open, I thought I'd try the 'Microsoft SQL Server.Data.Build Inserts from Table' template. I ran into a couple of issues and went back to my old standby, DbaMGR2K.

From Template:

Code: Select all

INSERT INTO [AggregateTest]
([DepartmentID], [FirstName], [LastName], [Age], [HireDate], [Salary], [IsActive])
VALUES
(3, 'David', 'Doe', 16, '02/16/2000 00:00:00', 34, 1);

From DbaMGR2K:

Code: Select all

INSERT INTO [dbo].[AggregateTest] ([DepartmentID], [FirstName], [LastName], [Age], [HireDate], [Salary], [IsActive] )
VALUES ( 3, 'David', 'Doe', 16, '2000-02-16 00:00:00.000', 34.7100, 1 )

First, is the DateTime format. DbaMGR2K uses a more universally accepted ISO-8601 format.

Second, and more troubling, is that the Salary field (NUMERIC(8,4) NULL) is getting truncated to an integer.

I realize that this is probably more of an example template of the capabilities of MyGeneration, and I was trying to use it for more than it was designed, but I thought you might want to know my experience with it.

[mike.griffin]

Ya. I think that template is meant only for SQL Server?