How can we help you today? How can we help you today?
flemingho
Activity overview Badges (0) Posts (2) Comments (4)

Activity overview

Latest activity by flemingho

Hi Brian, I had asked this question in version 4 where you gave me a code snippet that worked like a charm. I'm trying to convert the same utility using version 5, but there seems to be some changes in the API that has "obseleted" some functions e.g. SQLProvider.GetDatabase(). I was wondering if you could be so kind again to give me a code snippet that does the same thing, please. The help file in version 5 is a tad less detailed than version 4. Thanks, Fleming Brian Donahue wrote: Hello Fleming, In code, you can register one database using Database.Register, then leave the second database as a new, blank database object. Then compare the two to generate a synchronization script. You would still need to append the CREATE DATABASE... command to the top of the script but that's not hard to do at all! [c#] using System; using RedGate.SQL.Shared; using RedGate.SQLPackager.Engine; using System.IO; namespace ConsoleApplication1 { class Class1 { static void Main() { string serverName="."; string databaseName="WidgetDev"; //get the execution block representing the schema RedGate.SQLCompare.Engine.Database database=new RedGate.SQLCompare.Engine.Database(); database.Register(new RedGate.SQLCompare.Engine.ConnectionProperties(serverName, databaseName), RedGate.SQLCompare.Engine.Options.Default); //compare it with a null database to get a creation script RedGate.SQLCompare.Engine.Differences schema=database.CompareWith(null, RedGate.SQLCompare.Engine.Options.Default); //select all the differences foreach (RedGate.SQLCompare.Engine.Difference difference in schema) { difference.Selected=true; } RedGate.SQLCompare.Engine.Work work=new RedGate.SQLCompare.Engine.Work(); //get the script work.BuildFromDifferences(schema, RedGate.SQLCompare.Engine.Options.Default, true); ExecutionBlock schemaBlock=work.ExecutionBlock; //now get the data script RedGate.SQLDataCompare.Engine.SqlProvider provider=new RedGate.SQLDataCompare.Engine.SqlProvider(); RedGate.SQLDataCompare.Engine.Database database2=provider.GetDatabase(new RedGate.SQLDataCompare.Engine.SqlConnectionProperties(serverName, databaseName)); RedGate.SQLDataCompare.Engine.ComparisonSession session=new RedGate.SQLDataCompare.Engine.ComparisonSession(); RedGate.SQLDataCompare.Engine.TableComparisonSettings tablesToCompare=new RedGate.SQLDataCompare.Engine.TableComparisonSettings(); foreach (RedGate.SQLDataCompare.Engine.Table table in database2.Tables) { //since we are always inserting data there is no need to define a primary key tablesToCompare.Add(new RedGate.SQLDataCompare.Engine.TableComparisonSetting(table.FullyQualifiedName, table.Fields, null)); } session.CompareDatabases(database2, null, tablesToCompare); ExecutionBlock dataBlock=provider.GetMigrationSQL(session, true); } } } / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Create script for new Database using API
Hi Brian, I had asked this question in version 4 where you gave me a code snippet that worked like a charm. I'm trying to convert the same utility using version 5, but there seems to be some change...
0 votes
Thanks. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Create script for new Database using API
Thanks.
0 votes
Great, thanks, Brian. Just as a suggestion, but this would be a good code example that needs an appropriate section title/name for itself in the next version of SQLBundle. Or the CompareWith method needs to have the use of "null" documented. Thanks, again. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Create script for new Database using API
Great, thanks, Brian. Just as a suggestion, but this would be a good code example that needs an appropriate section title/name for itself in the next version of SQLBundle. Or the CompareWith method...
0 votes
Create script for new Database using API
  1. Community
  2. SQL Compare Previous Versions
Hi, Is there an API code example that I can use, to create a script for a new database (ie. non-upgrade script). Basically I have a starting database (internally) where our customers can create new...
2 followers 6 comments 0 votes
Thanks, Richard. I'll check it out. Fleming / comments
  1. Community
  2. SQL Bundle 5 Beta
  3. TableComparisonSettings API ??
Thanks, Richard. I'll check it out. Fleming
0 votes
TableComparisonSettings API ??
  1. Community
  2. SQL Bundle 5 Beta
Hi, I'm walking through the API samples and I'm getting a compile error. Error 7 The type or namespace name 'TableComparisonSettings' could not be found (are you missing a using directive or an ass...
2 followers 2 comments 0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2