I have a VS 2010 database project that needs a database link to a Dynamics CRM database. I have remote access to a 32-bit Windows 2003 R2 R2 server. My strategy is to create a .dbschema file and use it as a link.
The two best resources that I found to create the .dbschema file are https://stackoverflow.com/a/2129129/ and MSDN .
I got an error:
The database schema provider cannot be determined from the attached connection string. Verify that the connection string is valid for the ADO.NET provider used for the database provider, and that you have the privileges necessary to connect to the server.
I have taken the following steps:
- Create a temporary folder C: \ temp
- Copy the contents of the folder C: \ Program Files (x86) \ Microsoft Visual Studio 10.0 \ VSTSDB \ Deploy to C: \ temp
- Copy several DLLS from the list below the folder C: \ Program Files (x86) \ Microsoft SQL Server Compact Edition \ v3.5 to C: \ temp
At this point, the MSDN instructions say that I must have files
- DatabaseSchemaProviders.Extensions.xml
- Microsoft.Data.Schema.dll
- Microsoft.Data.Schema.ScriptDom.dll
- Microsoft.Data.Schema.ScriptDom.Sql.dll
- Microsoft.Data.Schema.Sql.dll
- Microsoft.SqlServer.BatchParser.dll
- Sqlceer35en.dll
- Sqlceme35.dll
- Sqlceqp35.dll
- Sqlcese35.dll
- System.Data.SqlServerCe.dll
- VSDBCMD.EXE
It is almost like that.
- DatabaseSchemaProviders.Extensions.xml is actually located in C: \ temp \ Extensions \ SqlServer \, so I also copied it to C: \ temp if it should be at the same directory level.
Microsoft.SqlServer.BatchParser.dll GAC, , , C:\temp, , 32- , DLL Program Files (x86).
- VSDBCMD C:\temp CMD . C:\temp .
VSDBCMD/a: /cs: "Provider=SQLOLEDB.1;Password=********.Perist Security Info = True; = sa; = VANILLA_MSCRM; = ** ******" /dsp: Sql/model:VANILLA_MSCRM.dbschema
= {., (local), localhost, IP-, , } Providers = {SQLOLEDB.1, SQLNCLI10.1, SQLNCLI.1}. . , () localhost . , UDL (\ http://msdn.microsoft.com/en-us/library/e38h511e%28VS.71%29.aspx). \http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/dabd14fa-a805-4855-b3f1-33b37b16c5b1 sqlcmd .
? .dbschema CRM ?