Comments
Sort by recent activity
We don't use SQL Compare so the only thing I could try would be to create a new database and link it to SQL Source Control. However, that will probably work since there is no data in those tables.
It could very well be that the revision that the database was at was later than the revision that I made the migration script for since there was additional revisions after the one I needed the script for. I did not check the revision number before the get latest was attempted. / comments
We don't use SQL Compare so the only thing I could try would be to create a new database and link it to SQL Source Control. However, that will probably work since there is no data in those tables.
...
UPDATE: So, I decided to setup the Migration scripts and I created a migration script for my specific revision. However, when the other developer tried to get latest, we got the same error.
I found out that even though the Migration script is created, it is not run when a Get Latest is executed. Is this correct?
We ended up running the migration script manually and then doing a Get Latest worked on the remaining objects.
Seems to me that SQL Source Control should know what revision you are on, and look for the migration scripts to run and run them automatically. If it is supposed to do this, then what am I doing wrong?
Also, it would be nice if I could run the Migration script from somewhere instead of editing it, copying all of the text and then pasting it in a separate window.
Thanks,
Greg / comments
UPDATE: So, I decided to setup the Migration scripts and I created a migration script for my specific revision. However, when the other developer tried to get latest, we got the same error.
I foun...
Yes, I made sure the folder was setup correctly. I think what you are trying to say in your 2nd paragraph is that I should've had the migrations folder setup before I check in my change that required a migration script? If not, then I don't follow.
My order of events were this: Made the schema change and checked it in. Setup the Migrations folder and created a script pointing to that revision. Then, I had the other developer setup his migrations folder and do a get latest. If I did something out of sequence let me know. I don't have an immediate need to to do another script so maybe it will work next time. / comments
Yes, I made sure the folder was setup correctly. I think what you are trying to say in your 2nd paragraph is that I should've had the migrations folder setup before I check in my change that requi...
Never mind...after 15 minutes it finally connected and linked. This is with 2.2. Are there any plans to improve performance with large databases in 3.x?? / comments
Never mind...after 15 minutes it finally connected and linked. This is with 2.2. Are there any plans to improve performance with large databases in 3.x??
I am using SQL Server 2000 SP3a.
However, I am using a user permission and not sa permissions because it is on a remote server. The user permission I am using however, has dbo access. So, I'm not sure what else I can do other than to delete the proc on the remote server, check the Add WITH ENCRYPTION option in SQL Compare and then syncronize the procs. That will copy the encrypted proc over to the remote server.
Thoughts? / comments
I am using SQL Server 2000 SP3a.
However, I am using a user permission and not sa permissions because it is on a remote server. The user permission I am using however, has dbo access. So, I'm not...
Yes I am checking with EM.
Lets try explaining this again.
Lets say I have Server1 and Server2. I am trying to copy an encrypted procedure to Server 2.
I go into EM on Server1 and the proc is encrypted. I check the proc on Server2 and it is not encrypted.
I run SQL Compare refresh and it tells me that the text is encrypted for the procedure on Server1 but not on Server2. I run Sync so that Server2 is the same as Server1. It runs with no error and then comes back and tells me that the procs are the same, yet they still show that the proc on Server1 is encrypted and the proc on Server2 is not. But yet SQL Compare says they are the same.
When I then check the procedure on Server2, it is still in plain text and not encrypted.
So, I'm confused. Thoughts? / comments
Yes I am checking with EM.
Lets try explaining this again.
Lets say I have Server1 and Server2. I am trying to copy an encrypted procedure to Server 2.
I go into EM on Server1 and the proc is encr...