So my steps are:
1) Export a bacpac file from SQL azure to my desktop
The azure SQL is provisioned using Microsoft sync Framework 2.1
2) Import the bacpac to a local instance of SQL 2008 R2
This doesn't work and turns out in an error msg saying:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Could not import package.
Warning SQL72012: The object [PRIMARY] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Warning SQL72012: The object [testasdf_Data] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Warning SQL72012: The object [testasdf_Log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Error SQL72014: .Net SqlClient Data Provider: Msg 195, Level 15, State 10, Procedure zvgart_updatemetadata, Line 14 'get_new_rowversion' is not a recognized built-in function name.
Error SQL72045: Script execution error. The executed script:
CREATE PROCEDURE [zvgart_updatemetadata]
@P_1 NVarChar(4),
@sync_scope_local_id Int,
@sync_row_is_tombstone Int,
@sync_create_peer_key Int,
@sync_create_peer_timestamp BigInt,
@sync_update_peer_key Int,
@sync_update_peer_timestamp BigInt,
@sync_check_concurrency Int,
@sync_row_timestamp BigInt,
@sync_row_count Int OUTPUT
AS
BEGIN
SET @sync_row_count = 0; DECLARE @nextRowVersion bigint; SELECT @nextRowVersion = get_new_rowversion(); DECLARE @was_tombstone int; SELECT @was_tombstone = [sync_row_is_tombstone] FROM [zvgart_tracking] WHERE ([ZvgartId] = @P_1);IF (@was_tombstone IS NOT NULL
AND @was_tombstone = 1 AND @sync_row_is_tombstone = 0) BEGIN UPDATE [zvgart_tracking] SET [create_scope_local_id] = @sync_scope_local_id, [scope_create_peer_key] = @sync_create_peer_key, [scope_create_peer_timestamp] = @sync_create_peer_timestamp, [local_create_peer_key]
= 0, [local_create_peer_timestamp] = @nextRowVersion, [update_scope_local_id] = @sync_scope_local_id, [scope_update_peer_key] = @sync_update_peer_key,
(Microsoft.SqlServer.Dac)
------------------------------
BUTTONS:
OK
------------------------------