Comments
Sort by recent activity
yes we are using 5.2.0.32..
I meant running sql compare on the prod just to see what is different not to actually go thru with the sync. / comments
yes we are using 5.2.0.32..
I meant running sql compare on the prod just to see what is different not to actually go thru with the sync.
yes I'm using the "ADD WITH ENCRYPTION "
max lenght is 90
avg length is 30 / comments
yes I'm using the "ADD WITH ENCRYPTION "
max lenght is 90
avg length is 30
If I reading you reply correctly is that you are saying the left side db as the object encrypted. Actually both db's don't have this proc encrypted. If you see the name of the proc is actually a replication proc used by SQL server. And the procs are the same and we don't encrypt these since replication uses them. We encrypt the other procs that our company creates mandated by security..I know Iknow .... that is why the check box is on... but as you can see I have to pick thru all of them to select the ones I really want to move over....and the replication procs 3 per table and we have over 200 or so tables.....nasty...
Can you explain to me how sql compare works alittle ? I would like to know if there is any impact on running this on a production db while users are heavily using it? / comments
If I reading you reply correctly is that you are saying the left side db as the object encrypted. Actually both db's don't have this proc encrypted. If you see the name of the proc is actually a re...
not sure what you mean about scripts but here is the code from the sql difference windows
-- Stored Procedure
CREATE procedure [sp_MSdel_Activities] @pkc1 int
WITH ENCRYPTION as
delete [Activities]
where [ACTIVITY_ID] = @pkc1 @rowcount = 0 @microsoftversion>0x07320000
exec sp_MSreplraiserror 20598
GO
-- Stored Procedure
CREATE procedure [sp_MSdel_Activities] @pkc1 int
WITH ENCRYPTION as
delete [Activities]
where [ACTIVITY_ID] = @pkc1 @rowcount = 0 @microsoftversion>0x07320000
exec sp_MSreplraiserror 20598
GO
also if you can tell me how to get the average length of the object names I can supply that too. I can get the LEN of the objects names but how can I get average. / comments
not sure what you mean about scripts but here is the code from the sql difference windows
-- Stored Procedure
CREATE procedure [sp_MSdel_Activities] @pkc1 int
WITH ENCRYPTION as
delete [Activities]...
no since the schemas are the same. It's just more tables are selected more then I had selected on the original project. And another thing is you can edit the clone but you most run the compare to save it....that is no good incase I wanted to just set it up and run it later in the day. / comments
no since the schemas are the same. It's just more tables are selected more then I had selected on the original project. And another thing is you can edit the clone but you most run the compare to s...
I have tried the Create Clone button and once I click on the table&Views tab I see all the tables and there are more then I want to be checked. When I clone the original the projet had the correct tables checked.
I also open the sdc file in notepad and edited the db connection to the appropiate server I want to compare with but I can not open the file in the Data Compare or at least I don't know how since there is not a FILE-> OPen oprtion.
what can I do?
I have like 500 tables that I only want 180 something to compare. / comments
I have tried the Create Clone button and once I click on the table&Views tab I see all the tables and there are more then I want to be checked. When I clone the original the projet had the correct ...