How can we help you today? How can we help you today?

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

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.
pkellner
0

Comments

1 comment

Sort by
  • 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
    Eddie D
    0

Add comment

Please sign in to leave a comment.