I get "--dev-url cannot be empty" on atlas schema apply -u ... -:to schema.sql

[205g0]

Pretty much the title and I'd like to migrate the the db in -u to the state in schema.sql, -u is my dev database. The migration from dev to prod is not handled by Atlas.

If I add --dev-url the same connection string as in -u I get: Error: sql/migrate: taking database snapshot: sql/migrate: connected database is not clean: found table "products" in schema "shop"

Guess I've misunderstood something...

[a8m]

Hey @205g0,

Can you please paste here the full command you ran? schema inspect is used for inspection.

[205g0]

Sure, I've meant "apply", sorry, editing the title and the full command is:

atlas schema apply --to file://schema.sql -u $MY_DEV_DB

My use case is adding a column to a existing table.

[a8m]

Got it, check out my comment there: #1644 (comment)

TL;DR - The -u is meant to be the database you want to apply the schema on, and the --dev-url is a local dev-database that is used for validating, normalizing, and computing the state defined by the schema.sql file. You can change the command to the following:

atlas schema apply \
  --to file://schema.sql \
  -u $MY_DEV_DB \
  --dev-url "docker://mysql/8/dev"

Or:

atlas schema apply \
  --to file://schema.sql \
  -u $MY_DEV_DB \
  --dev-url "docker://postgres/15/dev?search_path=public"

[205g0]

@a8m apologes for my replies, I've been on mobile yesterday and missed that one link. Now, everything works and I've grokked the concept!

However, why can Atlas not just use the respective docker string as default after it dtetected the db type? Moreover, the flag itself is a bit misleasing, it's not my dev db but rather a validation db/engine for Atlas (e.g. --val-url)