Ok, one step closer... I got it to generate a file, but it is only
doing table names and columns. It is ignoring column data type,
lenght, indexes, and keys. Is there an additional setting for the -
dump command?
Thanks,
On Feb 9, 2:57 pm, Roger <em...@rogerguess.net> wrote:
> Doh.. ok:
>
> migrator.console SqlServer "Database=xxx;Data Source=xxx;User
> Id=xxx;Password=xxx" migrationAssembly="MigrationTest.dll" -dump
> test.cs
>
> On Feb 9, 2:53 pm, Roger <em...@rogerguess.net> wrote:
>
> > Ah, excellent! But I am having issues. I am trying a batch file to
> > execute via the console, because I was not sure how to add what I
> > needed to the MSBuild task. Here is what I tried:
>
> > migrator.console provider=sqlserver
> > connectionstring="Database=xxxx;Data Source=xxxx;User
> > Id=xxxx;Password=xxxx" migrationAssembly="MigrationTest.dll" -dump
> > test.cs
>
> > I built the MigrationTest.dll with simple class:
> > using System;
> > using System.Collections.Generic;
> > using System.Linq;
> > using System.Text;
> > using Migrator.Framework;
>
> > namespace MigrationTest
> > {
> > public class Class1: Migration
> > {
> > public override void Up()
> > {
> > // Create stuff
> > }
> > public override void Down()
> > {
> > // Remove the same stuff
> > }
> > }
>
> > }
>
> > Getting this error:
>
> > C:\Development\MigrationTesting\MigrationTest\MigrationTest
> > \Migrator.net>dump
>
> > C:\Development\MigrationTesting\MigrationTest\MigrationTest
> > \Migrator.net>migrato
> > r.console provider=sqlserver connectionstring="Database=svrlat;Data
> > Source=webte
> > sting;User Id=webtester;Password=Loans123"
> > migrationAssembly="MigrationTest.dll"
> > -dump test.cs
> > System.TypeLoadException: Could not load type
> > 'Migrator.Providers.provider=sqlse
> > rver.provider=sqlserverTransformationProvider' from assembly
> > 'Migrator.Providers
> > , Version=0.7.0.21798, Culture=neutral, PublicKeyToken=null'.
> > at System.Reflection.Assembly._GetType(String name, Boolean
> > throwOnError, Boo
> > lean ignoreCase)
> > at System.Reflection.Assembly.GetType(String name, Boolean
> > throwOnError, Bool
> > ean ignoreCase)
> > at Migrator.ProviderFactory.Create(String providerName, String
> > connectionStri
> > ng) in c:\work\other projects\migratordotnet\migratordotnet-trunk\src
> > \Migrator\P
> > roviderFactory.cs:line 41
> > at Migrator.Tools.SchemaDumper..ctor(String provider, String
> > connectionString
> > ) in c:\work\other projects\migratordotnet\migratordotnet-trunk\src
> > \Migrator\Too
> > ls\SchemaDumper.cs:line 23
> > at Migrator.MigratorConsole.MigratorConsole.Dump() in c:\work\other
> > projects\
> > migratordotnet\migratordotnet-trunk\src\Migrator.Console
> > \MigratorConsole.cs:line
> > 114
> > at Migrator.MigratorConsole.MigratorConsole.Run() in c:\work\other
> > projects\m
> > igratordotnet\migratordotnet-trunk\src\Migrator.Console
> > \MigratorConsole.cs:line
> > 55
> > C:\Development\MigrationTesting\MigrationTest\MigrationTest
> > \Migrator.net>
>
> > I have MigrationTest.dll, all the dll's and the console that came with
> > migrator.net in the same folder for now, so the error should not be
> > due to it not finding the path to Migrator.Providers.dll
>
> > Any ideas?
>
> > Thanks!
>
> > On Feb 9, 10:15 am, "Dotan N." <dip...@gmail.com> wrote:
>
> > > sure, look at the console tool and try -dump :)
>
> > > On Mon, Feb 9, 2009 at 6:12 PM, Roger <em...@rogerguess.net> wrote:
>
> > > > Greetings all,
>
> > > > I am curious to find out if anyone has a mechanism for reverse
> > > > engineering a schema as a starting point. We have an interest in using
> > > > this library, but definitely are not interested in hand writing the
> > > > first pass of our existing schema:P
>
> > > > Anything out there I can look at?
>
> > > > Thanks,
> > > > Roger
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"migratordotnet-devel" group.
To post to this group, send email to migratordotnet-devel@googlegroups.com
To unsubscribe from this group, send email to
migratordotnet-devel+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/migratordotnet-devel?hl=en
-~----------~----~----~----~------~----~------~--~---
