'Build Inserts from Table' template

Any template questions or comments or suggestions

'Build Inserts from Table' template

Postby dnparsons on Thu Oct 13, 2005 11:03 pm

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.
David Neal Parsons
EntitySpaces
User avatar
dnparsons
Lieutenant General
 
Posts: 292
Joined: Sun Jan 09, 2005 2:10 pm
Location: Miami, Florida

Postby mike.griffin on Thu Oct 13, 2005 11:23 pm

Ya. I think that template is meant only for SQL Server?
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN


Return to General Template Questions/Comments

Who is online

Users browsing this forum: No registered users and 1 guest