Sql compare 3.1 was renane views and other..
Brian Donahue
Posts: 6,590 Bronze 1
Hi Alex,
haven't run into this problem myself, but I think it happened because
you had renamed the view and SQL Server didn't refresh it properly. SQL
Compare gets the SQL Data Definition Language from the server, and sometimes
the DDL does not match the object name in Enterprise Manager.
Sometimes you can correct this by refreshing the view manually -- try
using sp_refreshview from Query Analyzer and see if that does the trick.
The create order of objects is dictated using the sysdepends table at
the moment, which can possibly be out of date. The next version of SQL
Compare will build its' own dependency matrix so it will work much better.
Also, the suggestion about refreshing the view might help that problem too,
if it's caused by a view being scripted in the wrong place.
Regards,
Brian Donahue
Red Gate Technical Support
"Alex D. Pichkurov" <alex@mpc.odessa.ua> wrote in message
news:opr5km6is3f8n3rn@news.red-gate.com...
> Hello, I'm beginner with SQL Compare, but simple test with copy 2 dbs from
> one server to other take a some issues:
> 1) Itself change a views name , for example from "factSales_PG_slice" to
> "factSales PG filtr".
> It is very strange - view at screen snapshot file
> 2) Ingore a create order for objects, for exapmle try to create views
> before create a tables. Why ?
>
> Thank You for assistance !
>
>
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
haven't run into this problem myself, but I think it happened because
you had renamed the view and SQL Server didn't refresh it properly. SQL
Compare gets the SQL Data Definition Language from the server, and sometimes
the DDL does not match the object name in Enterprise Manager.
Sometimes you can correct this by refreshing the view manually -- try
using sp_refreshview from Query Analyzer and see if that does the trick.
The create order of objects is dictated using the sysdepends table at
the moment, which can possibly be out of date. The next version of SQL
Compare will build its' own dependency matrix so it will work much better.
Also, the suggestion about refreshing the view might help that problem too,
if it's caused by a view being scripted in the wrong place.
Regards,
Brian Donahue
Red Gate Technical Support
"Alex D. Pichkurov" <alex@mpc.odessa.ua> wrote in message
news:opr5km6is3f8n3rn@news.red-gate.com...
> Hello, I'm beginner with SQL Compare, but simple test with copy 2 dbs from
> one server to other take a some issues:
> 1) Itself change a views name , for example from "factSales_PG_slice" to
> "factSales PG filtr".
> It is very strange - view at screen snapshot file
> 2) Ingore a create order for objects, for exapmle try to create views
> before create a tables. Why ?
>
> Thank You for assistance !
>
>
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
This discussion has been closed.
