SqlDbx Forum

SqlDbx

You are not logged in.

#1 2013-01-31 07:36:29

ptoniolo
Member

Tools/GenScripts: $(SCHEMA) in the fname uses the database instead

SqlDbx 3.59.

In one of my sqlserver 2008 databases I have tables with the same tablename in different schemas.

When I use Tools/Generate Scripts, and I choose a filename "$(SCHEMA).$(NAME).sql", the name of the files does not have the schema name, but the database name!

Is there a way to use the sqlserver schema name instead? Seems like your "schema" concept has been implemented a-la Oracle!

And is there a way to know which are the options that can be used in that filename field?

Thanks
Pietro

Offline

#2 2013-01-31 11:58:07

sqldbxhelp
Administrator

Re: Tools/GenScripts: $(SCHEMA) in the fname uses the database instead

Thank you for pointing this out.
This is the oversight on our part.
Will be addressed in a next release.
$(DATE) is the only option right now for file name. What other options you would like to have?

Offline

#3 2013-02-01 05:21:07

ptoniolo
Member

Re: Tools/GenScripts: $(SCHEMA) in the fname uses the database instead

I think we don't need any other option... even $(DATE) is more than enough, but it's ok to have it.
Hopefully you are implementing a format like yyyy-mm-dd!

Offline

Board footer

Powered by FluxBB