Import schema - incomplete

Hi,

I am trying to import schema for a 2005 database project from a 2005 database using CTP4. The process starts, then errors out due to syntax errors. In the schema view, all the tables are there, but the vast majority of other objects (stored procedures, functions, roles) all have the warning icon (yellow triangle with !). I have searched the forum and went through the help, but it is not clear why these items are marked. Do I have to fix the syntax errors in the database before it can be completely imported?

Also, is there a way to exclude ASP.NET SqlMembership tables/functions/roles from the schema, or do I have to remove them after the import?

Thanks

[670 byte] By [PMace] at [2007-12-22]
# 1

In the CTP4 not all SQL Server 2005 syntax is supported, that's why you may experience issues with 2005 projects, and have some objects marked in error state eveno though they have valid SQL syntax.

Dmitriy_Nikonov_MSFT at 2007-8-30 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 2

Hi

The reason you are probably seeing all the errors is that we don't fully support all of SQL Server 2005 objects yet hence the reason you are seeing a syntax error.

mairead

mairead at 2007-8-30 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 3
I am seeing similar issues with SQL 2000. We have a set of stored procedures that have valid syntax but are being marked with the warning sign in the Schema View. One of the interesting things is we have 3 part names being used. However, we had successful script creation for two other procedures that also had the 3 part naming convention so I do not believe that is the issue.
CliffBuckley at 2007-8-30 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 4

I have had the same issue. The 3 part names error in triggers and views and some sps but not all. When I rebuild a whole new bunch will error.

Susan

SuzMSDN at 2007-8-30 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

Visual Studio Team System

Site Classified