SQL-Compare script without schema qualifiers
Radhika
Posts: 2
Hi,
We want an SQL script to be generated from SQL-Compare without having schema qualifiers to the database objects.
For e.g. - currently the script that we are getting from SQL-Compare contains the schema qualifiers as:
CREATE TABLE [dbo].[test_table]
(.
.
)
We want it to be:
CREATE TABLE [test_table]
(.
.
)
Note that [dbo] is now removed from the create script. We can not find any setting in SQL-Compare that gives an option to remove this schema qualifier.
Please let us know if anybody has come across same problem and have found a solution for the same.
Thanks in advance,
Radhika
We want an SQL script to be generated from SQL-Compare without having schema qualifiers to the database objects.
For e.g. - currently the script that we are getting from SQL-Compare contains the schema qualifiers as:
CREATE TABLE [dbo].[test_table]
(.
.
)
We want it to be:
CREATE TABLE [test_table]
(.
.
)
Note that [dbo] is now removed from the create script. We can not find any setting in SQL-Compare that gives an option to remove this schema qualifier.
Please let us know if anybody has come across same problem and have found a solution for the same.
Thanks in advance,
Radhika
