Comments
Sort by recent activity
I got it working just fine in VS2008.
Be sure to change the path above to:
C:\Program Files.... instead of [image] \Program Files... / comments
I got it working just fine in VS2008.
Be sure to change the path above to:
C:\Program Files.... instead of \Program Files...
So, I never had this issue until I upgraded to 3.1.0.5208. I'm using a dedicated model and all of the icons change if I work with different query tabs but when I go back to the SQL Source Control tab, it refreshes and the icons indicating changes are removed. / comments
So, I never had this issue until I upgraded to 3.1.0.5208. I'm using a dedicated model and all of the icons change if I work with different query tabs but when I go back to the SQL Source Control ...
The only thing I did notice is that when we went to get latest, the migration script was not in the list of other objects on the Get Latest tab. So, that was probably the issue.
Needless to say, we ran it manually, and everything else worked so we are ok and now know for next time. / comments
The only thing I did notice is that when we went to get latest, the migration script was not in the list of other objects on the Get Latest tab. So, that was probably the issue.
Needless to say, w...
Yes, the database has the extended properties. / comments
Yes, the database has the extended properties.
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...