Does sql data compare write out all data or do inserts/sel

pkellner

That is, is it reasonable to try and use sqldata compare to copy a 5 gig database (to azure).

if it is doing insert into (select..) then I'd think it's OK. If it's writing out raw insert statements, not so much.

Eddie D

Hi

Thank you for your forum post and sorry for the delay in replying.

SQL Data Compare will use an 'INSERT INTO' statement, similar to the following example:

PRINT(N'Add 3 rows to [HumanResources].[Shift]')
SET IDENTITY_INSERT [HumanResources].[Shift] ON
INSERT INTO [HumanResources].[Shift] ([ShiftID], [Name], [StartTime], [EndTime], [ModifiedDate]) VALUES (1, N'Day', '1900-01-01 07:00:00.000', '1900-01-01 15:00:00.000', '1998-06-01 00:00:00.000')
INSERT INTO [HumanResources].[Shift] ([ShiftID], [Name], [StartTime], [EndTime], [ModifiedDate]) VALUES (2, N'Evening', '1900-01-01 15:00:00.000', '1900-01-01 23:00:00.000', '1998-06-01 00:00:00.000')
INSERT INTO [HumanResources].[Shift] ([ShiftID], [Name], [StartTime], [EndTime], [ModifiedDate]) VALUES (3, N'Night', '1900-01-01 23:00:00.000', '1900-01-01 07:00:00.000', '1998-06-01 00:00:00.000')
SET IDENTITY_INSERT [HumanResources].[Shift] OFF

If you are worried about copying the 5GB of data, you can perform comparison and deployment in stages by selecting the tables for deployment or/and configure 'Where' clause for each table. It will mean repeating the comparison and deployment two or more times as required.

Many Thanks
Eddie