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

pkellnerpkellner Posts: 5
edited September 15, 2015 7:28AM in SQL Data Compare 11
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.
Peter Kellner
http://peterkellner.net
MVP ASP.NET

Comments

  • Eddie DEddie D Posts: 1,648 Rose Gold 5
    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 Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.