ah I see, thanks for explaining :) is it a feature you would like me to leave for you to tackle or are you happy for me to give it a go when (if!) I get time? :) I imagine it could be (naughtily) simplified slightly by expecting a CREATE TABLE statement for all files in the tables folder etc. ;) so if I do it, we might not end up with a "complete" sql parser, so to speak :P
enjoy your vacation :)
is it possible to also export the data using schemazen?
Here's an example: SchemaZen script -s localhost -b test -d c:\test --dataTables "table1,table2,table3"
I get an exception using schemazen
SQL data type hierarchyid is not supported
is it possible to exclude such a field from the export and fill it with null values?
It should be straightforward to fix. Take a look at https://github.com/sethreno/schemazen/blob/master/model/Column.cs around line 73.
seems msdn isn't a good source of info, it doesn't even mention hierarchyid - https://msdn.microsoft.com/en-gb/library/bb510411%28v=sql.120%29.aspx
I have a problem with the sql server bulk copy
the hierarchy is serialized as ToString()
which is ok so far, since it's a correct representation
but there is a problem to write this back to the server
apart from this, ist there a possibility so restore just the data
by defaukt schemazen creates the schema first
did I say Thank You! for that tool already? :)
if I remember rightly, there currently isn't an option to just restore the data, but you can get it to do this without changing any code if you simply delete all the other files/folders that were created from the "script" command, so that the data folder will be all that SchemaZen sees
what error are you getting when it tries to write the hierarchy back to the server? I would like to think that if it is serialized correctly as ToString() then SqlServer should be able to un-serialize it from that...
but nothing ever works the way we would like ;)
Hey @sethreno I'm trying to get a feel for the state of the compare function. At a glance, it would appear the scripts created by the compare function simply use whatever database is selected. Also, any schemas missing from the target database are not added to the script. Is this expected behavior?
@NathanaelThompson I believe I can answer this, I did some work on the compare function a while ago. It is a bug that schemas are not compared - they are missing from the DatabaseDiff class. You could open an issue for this. And, yes, the scripts created by the compare function do indeed just use whatever database is selected when the scripts are executed. If you want this changed, you could again open an issue :)
the history behind the compare function is, that Seth had disabled it (commented out the code) because he wasn't sure it always produced correct results. and I came along, and being new to open source development, blundered in without knowing this or asking about it and uncommented it and added a few object types that were missing - it seems I missed schemas, so I think that it's my fault ;) I'm sure there is a discussion about it somewhere - maybe on the commits themselves, I'll try to find it
@honzabilek4 Doesn 't seem very active. I use the tool quite regulary though. I haven't found a way to fully automate my git/mssql workflow yet, is there some way to "sync" between the generated .sql files and the procesdures on the server? the direction SQLserver -> Files is easy with this.
@sethreno Just wanted to chime in on an issue that I've been having while working with SchemaZen, I am able to copy down most of the database objects from my source database, but I'm seeing that database Sequences are not coming down as expected. Is there some database rule I am missing to where sequences could not be copied?
Does anyone know about it?
I'm trying to get around the time it takes to expand all tables in SSMS
like @raminmahpour asked, can I make databackup with schemazen? I seen option "--datatable <tablename1>,<tablename2>,<tablename3> (etc).." but I want to get data of all tables in my db. It is not easy to enter all the table name since there are a number of tables. please help me on this. Thanks in advance.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)