Options
Option to create or alter table
comworld
Posts: 2 New member
in SQL Compare
Hello,
I have the trial version and I have a question.
I currently have an empty database which is the first version of the database and I make every change in a copy of this database lets name it Test Database.
When I compare those two it creates or alter a table . My problem is that if I already update the database on my clients with a previous script it doesnt alter a table it just ignore it.
Because it is complicated and I don't know if I explain it well I will give you an example.
In empty database I dont have Login Table so when I create the script it has the Create Table[dbo].[Login] etc..
In my Test Database I alter the password field from int to nvarchar .
My script now has again the Create Table but with field password [nvarchar] instead of [int]
In my client now if I run the script it will see that the table exists and will not make any change to it.
I want to check if the table exists and if all the fields are the same and then alter if anything has changed.
I have the trial version and I have a question.
I currently have an empty database which is the first version of the database and I make every change in a copy of this database lets name it Test Database.
When I compare those two it creates or alter a table . My problem is that if I already update the database on my clients with a previous script it doesnt alter a table it just ignore it.
Because it is complicated and I don't know if I explain it well I will give you an example.
In empty database I dont have Login Table so when I create the script it has the Create Table[dbo].[Login] etc..
In my Test Database I alter the password field from int to nvarchar .
My script now has again the Create Table but with field password [nvarchar] instead of [int]
In my client now if I run the script it will see that the table exists and will not make any change to it.
I want to check if the table exists and if all the fields are the same and then alter if anything has changed.
Tagged:
Answers
Product Manager
Redgate Software
Product Manager
Redgate Software