Rails - Mar 2006 - Migration commands -- create a SQL Server production DB?

Hallo -- could anyone tell me how I use Migrations (which my existing 
development schema is implemented with) to create the production 
database for deployment?
The target DB is a SQL Server database -- I don''t know if
that''s an
issue -- I seem to remember reading that SQL Server is supported now.
Oh, yeah -- SQL Server was *not* my choice!
But what I seem totally unable to find is a list of the commands that 
script/migrate accepts.
Cheers,
   doug.

-- 
Posted via http://www.ruby-forum.com/.

By coincidence I was just looking for the same thing. Check:
http://wiki.rubyonrails.com/rails/pages/UnderstandingMigrations
<http://wiki.rubyonrails.com/rails/pages/UnderstandingMigrations>  (which
links to: http://wiki.rubyonrails.com/rails/pages/UsingMigrations
<http://wiki.rubyonrails.com/rails/pages/UsingMigrations> )
It was the first thing that popped up when I googled for ''rails
migrations''.
 
And by the way: although I''m not that fond of most other ms products, I
can
actually honestly vouch for sqlserver and if given the choice (and if cost
would be the same) I''d probably prefer it over mysql when it needs to
be
deployed on an ms Windows server.
 
Piet.

-----Original Message-----
From: rails-bounces@lists.rubyonrails.org
[mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of doug livesey
Sent: maandag 27 maart 2006 17:15
To: rails@lists.rubyonrails.org
Subject: [Rails] Migration commands -- create a SQL Server production DB?



Hallo -- could anyone tell me how I use Migrations (which my existing 
development schema is implemented with) to create the production 
database for deployment? 
The target DB is a SQL Server database -- I don''t know if
that''s an
issue -- I seem to remember reading that SQL Server is supported now. 
Oh, yeah -- SQL Server was *not* my choice! 
But what I seem totally unable to find is a list of the commands that 
script/migrate accepts. 
Cheers, 
   doug. 

-- 
Posted via http://www.ruby-forum.com/ <http://www.ruby-forum.com/> . 
_______________________________________________ 
Rails mailing list 
Rails@lists.rubyonrails.org 
http://lists.rubyonrails.org/mailman/listinfo/rails
<http://lists.rubyonrails.org/mailman/listinfo/rails>  

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060327/c8e4b3d0/attachment.html

> But what I seem totally unable to find is a list of the commands that 
> script/migrate accepts.
http://api.rubyonrails.com/classes/ActiveRecord/Migration.html

dorian

--
I do things for love or money

Hi -- cheers for that. Whilst it has plenty on writing the actual 
migration, it''s running them that I need to know about.
The link you left mentions "rake migrate" and how to crete a migration
(which I''ve been using), not what commands would apply the migrations
to
a database other than my development database.
In another article I found this:

# rake db_schema_import ? imports the schema dumped using db_schema_dump
# rake migrate ? migrates a database to the current version
# rake migrate VERSION={X} ? migrates a database to a specific version
# rake environment RAILS_ENV=production migrate ? migrates the 
production database to the current version
# rake schema_generator ? products a .SQL file for each supported 
database platform (not everything is currently supported)

This is about as much detail as I have been able to find.
I guess I''ll go ahead & experiment with this, but I was hoping that
somewhere there might be a guide to running migrations (or maybe a rake 
in rails guide?) that would explain it all in detail to me, so that I 
could have a little more confidence in what I''m doing.
It''s all good learnin'', anyhow...
Cheers again,
   doug.

-- 
Posted via http://www.ruby-forum.com/.