search

minhphien / migratordotnet

Automatically exported from code.google.com/p/migratordotnet
0 stars 0 forks source link

Error when trying to migrate to SQL Server #44

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Write migration and try to run it on SqlServer 2005.

I keep getting this annoying "Invalid column name 'X'" for every single
column in my tables. It's driving me nuts. I've been using Migrator.NET
with MySQL without *any* problems at all, but when I tried to generate the
same database on SQL Server it just won't create a single table. I suppose
I could possibly write a lot of code to dump the SQL and debug it, but
sincerely I don't have time. I'd gladly do it once I'm done with this
project, but I'm already behind schedule and I'm terribly frustrated by
this. I tried using NAnt, the command line tool... nothing works.

I'm attaching the output for the command so you see what I mean.

I'm also attaching the migrations project, in the hope that someone will be
able to reproduce the error, or at least hint me to a possible solution.

Original issue reported on code.google.com by dguarag...@gmail.com on 4 Jul 2008 at 5:50

Attachments:

GoogleCodeExporter commented 9 years ago 
i dont have time to dig into this now, but its something got to do with your 
CreateClientLstsView view.

ill check it later.

Original comment by dko...@gmail.com on 4 Jul 2008 at 6:41

GoogleCodeExporter commented 9 years ago 
OK, I'll try disabling that view first. It might be crapping the whole SQL
generation. If the table-related stuff works, I can work my way through 
creating the
views by hand. Thanks!

Original comment by dguarag...@gmail.com on 4 Jul 2008 at 7:28

GoogleCodeExporter commented 9 years ago 
Well, I've corrected it. Can't believe it! Wasted 4 hours today, trying to 
guess what
was going on, and now I realize it was just one missing space char between the 
last
field in the select statement and the FROM part.

Actually, I think there should be an option for Migrator to output more detailed
information, so that I could know exactly in what part of the process it dies. I
might look into it once I'm done with this project.

Thanks a lot!

Original comment by dguarag...@gmail.com on 4 Jul 2008 at 7:41

GoogleCodeExporter commented 9 years ago 
Did you have Trace enabled?
That should give you more detailed output.

Either way, I'll add in an enhancement to improve the output on a failure. 
Closing
this though.

Original comment by geoffl...@gmail.com on 5 Aug 2008 at 10:13