Re: [Firebird-net-provider] Rename a table
sqlsvr schrieb am 12.06.2010 um 21:28 (-0700): How do you rename a table? Every other DBMS supports renaming a table. During development, table names can AND DO change and firebird does not support this. Apparently true. But during development it is not much of a problem provided you develop a DDL script that drops and recreates the entire set of objects in the database. Just drop the old set of objects (table plus all dependent objects), rename the table in your script, and then recreate the database. If your database setup involves time-consuming import of lots of data, that is apparently not an entirely satisfactory solution. I see that there is already an old request in the firebird tracker that the firebird developers arrogance has chosen to ignore... You're probably talking about this one: http://tracker.firebirdsql.org/browse/CORE-2486 You say that every other DBMS supports renaming a table. Well, MySQL/MyISAM can do it quite easily because it hardly supports any referential integrity. Reading the issue, the way this is implemented in real SQL servers is not as useful as it sounds: This feature could only be implemented after support for invalidating metadata objects was added to the Firebird engine, since attempting to replace all table references in the source 'code' of the dependent objects would be much too risky to consider. (This is how Oracle and Postgres have implemented the feature -- they mark all existing objects as invalid and require the developer to correct the references themselves.) So it's far from automatic. All things considered, editing the DDL script using search/replace and recreating the database may be a lot easier. a real shameif this is the case, I assume that firebird developers never worked in a production/development environmentI'm switching back to Oracle. Sorry to hear that: I shall miss the display of skilled arrogance in your provocative posts ... -- Michael Ludwig -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Rename a table
I'm appalled at how developers ignore this request, it is either a lack of experience (they never worked in a REAL company in a REAL production environment) or arrogance. Just last week, we renamed a table in SQL Server on a production environmentthe table itself contained over 1 TERABYTE of data. The rename operation took 2-3 seconds. So on firebird, you want me to create a new table, import 1 TERABYTE of data, REBUILD THE INDEXES, and drop the old table? What kind of ** nonsense is that? That is a minimum 3 day operation and meanwhile, all the production applications (that are updated to use the new table name) will be unavailable during that time. Again, what kind of ** nonsense is that? Why firebird developers ignore this requestit's just amazing. Vote for this request: http://tracker.firebirdsql.org/browse/CORE-3040 -- View this message in context: http://firebird.1100200.n4.nabble.com/Rename-a-table-tp2253220p2253431.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Rename a table
The actual firebird developers response to this CRITICAL BUG is: Thousands of developers worldwide are fine with horse drawn carriages, who needs cars? FIREBIRD IS DANGEROUS, DO NOT USE FOR PRODUCTION ENVIRONMENTS! Also, read Dr. Codds specifications, a DBMS is not a DBMS BY DEFINITION IF IT DOES NOT SUPPORT TABLE RENAMING. -- View this message in context: http://firebird.1100200.n4.nabble.com/Rename-a-table-tp2253220p2253437.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Rename a table
On Sun, Jun 13, 2010 at 4:31 PM, sqlsvr sql...@yahoo.com wrote: The actual firebird developers response to this CRITICAL BUG is: Thousands of developers worldwide are fine with horse drawn carriages, who needs cars? FIREBIRD IS DANGEROUS, DO NOT USE FOR PRODUCTION ENVIRONMENTS! Also, read Dr. Codds specifications, a DBMS is not a DBMS BY DEFINITION IF IT DOES NOT SUPPORT TABLE RENAMING. -- View this message in context: http://firebird.1100200.n4.nabble.com/Rename-a-table-tp2253220p2253437.html Sent from the firebird-net-provider mailing list archive at Nabble.com. you are screaming with CAPS on and that is not good from dialogue point of view please , the bug or feature that you request is or it will be on developers radar if is simple enough or if there are radical changes in the engine then it will be deffered to a later point oh yes if you scream you don't solve nothing , if you care about your 1T of data then is better in the end to start the dialogue and not screaming that we don't understand the issue or that we don't want , yes we want but maybe changing this in the engile will bring other bugs or is too complicated at the moment. All databases do have bugs and there are relational unexplored corners on all of them but please don't be a a troll and fill a wrong mailing list with wrong question and big caps we are all smart , and you too and we do know how to solve the rdbms issues and workarounds and in the end what this has to do with this .net list ? -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] DDEX Provider installed and works....but not correctly
On Sat, Jun 12, 2010 at 02:54, will ferguson willfergu...@westruss.com.au wrote: I'm a local admin. But I notice the permissions on this file are locked down. Trusted Installer account has full control rights though?? Any thoughts UAC? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbDataAdapter, commands and transactions
On Sat, Jun 12, 2010 at 13:55, Pierre Arnaud pierre.arn...@opac.ch wrote: No, I do not call SqlCommandBuilder.GetUpdateCommand. All I do is call IDataAdapter.Update on the data set. In the first example, you created instance. Maybe it's good idea to use these commands explicitly and set transaction properties. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Rename a table
sqlsvr schrieb am 13.06.2010 um 06:29 (-0700): I'm appalled at how developers ignore this request, it is either a lack of experience (they never worked in a REAL company in a REAL production environment) or arrogance. Just last week, we renamed a table in SQL Server on a production environmentthe table itself contained over 1 TERABYTE of data. The rename operation took 2-3 seconds. So on firebird, you want me to create a new table, import 1 TERABYTE of data, REBUILD THE INDEXES, and drop the old table? Take it easy. Nobody made such a suggestion. Bälle flach halten. It's clear that Firebird currently does not support such an operation. It also appears that implementing such a change would not be trivial. Shouting and screaming don't change any of the above. -- Michael Ludwig -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] DDEX Provider installed and works....but not correctly
Try right clicking on eg notepad Run as Administrator and opening and saving using that. On Sun, Jun 13, 2010 at 5:46 PM, Jiri Cincura disk...@cincura.net wrote: On Sat, Jun 12, 2010 at 02:54, will ferguson willfergu...@westruss.com.au wrote: I'm a local admin. But I notice the permissions on this file are locked down. Trusted Installer account has full control rights though?? Any thoughts UAC? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Vol 50, Issue 4 Item 1
I had the same problem on one of my computers and did the following as a work around. 1) copy the machine.config to another directory you own and make changes to file in this directory. 2) Copy machine.config back to original directory. I know it sounds odd because if you can't modify a file you should be able to overwrite it, but it worked for me. HTH John -Original Message- From: firebird-net-provider-requ...@lists.sourceforge.net [mailto:firebird-net-provider-requ...@lists.sourceforge.net] Sent: Sunday, June 13, 2010 10:14 AM To: firebird-net-provider@lists.sourceforge.net Subject: Firebird-net-provider Digest, Vol 50, Issue 4 Send Firebird-net-provider mailing list submissions to firebird-net-provider@lists.sourceforge.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/firebird-net-provider or, via email, send a message with subject or body 'help' to firebird-net-provider-requ...@lists.sourceforge.net You can reach the person managing the list at firebird-net-provider-ow...@lists.sourceforge.net When replying, please edit your Subject line so it is more specific than Re: Contents of Firebird-net-provider digest... Today's Topics: 1. Re: DDEX Provider installed and worksbut not correctly (will ferguson) 2. Re: FbDataAdapter, commands and transactions (Pierre Arnaud) 3. [FB-Tracker] Created: (DNET-325) fbConnection.State returns Open even when connection to the server was lost. (Luciano Mendes (JIRA)) 4. Rename a table (sqlsvr) 5. Re: Rename a table (Michael Ludwig) 6. Re: Rename a table (sqlsvr) 7. Re: Rename a table (sqlsvr) 8. Re: Rename a table (marius adrian popa) -- Message: 1 Date: Fri, 11 Jun 2010 17:54:41 -0700 From: will ferguson willfergu...@westruss.com.au Subject: Re: [Firebird-net-provider] DDEX Provider installedand worksbut not correctly To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Message-ID: 0fa04f67a57a6d4faf6d13be1ec6d955dff6626...@sg1rd3xvs041.red003.local Content-Type: text/plain; charset=us-ascii Trying to use ddex. I'm having difficulty making changes to my machine.config file.. access denied. I'm a local admin. But I notice the permissions on this file are locked down. Trusted Installer account has full control rights though?? Any thoughts -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Saturday, 12 June 2010 3:28 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] DDEX Provider installed and worksbut not correctly On Fri, Jun 11, 2010 at 16:13, sqlsvr sql...@yahoo.com wrote: Then what is the point of the DDEX provider? Support stuff build on top of it. Connections configurators, wizards, ... and also see DB structure. On the other hand you can step into and add the support. We'll be happy to include it. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Message: 2 Date: Sat, 12 Jun 2010 13:55:10 +0200 From: Pierre Arnaud pierre.arn...@opac.ch Subject: Re: [Firebird-net-provider] FbDataAdapter, commands and transactions To: 'For users and developers of the Firebird .NET providers' firebird-net-provider@lists.sourceforge.net Message-ID: 021f01cb0a26$1c158b00$5440a1...@opac.ch Content-Type: text/plain; charset=us-ascii No, I do not call SqlCommandBuilder.GetUpdateCommand. All I do is call IDataAdapter.Update on the data set. -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Thursday, June 10, 2010 9:01 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] FbDataAdapter, commands and transactions On Wed, Jun 9, 2010 at 22:39, Pierre Arnaud pierre.arn...@opac.ch wrote: Because adapter.UpdateCommand stays null for the whole execution of my program! Are you calling GetUpdateCommand somewhere and using the result? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to
Re: [Firebird-net-provider] Rename a table
Then stick with oracle, it is a good/better database, but stop spamming my mail account. I'm subscribed to this newsgroup because I care and sponsor the .net provider. Not to listen to some hysterical chicken threatening to go back to oracle. Did you know firebird doesn't support fulltext search, table valued functions, clr-integration or likewise, neither... It is an as good as possible effort from some really intelligent people who don't ask money for their product. And the product itself is also really nice, I like working with it. In all honesty, I never felt the need to adapt all my programs to rename a table, sounds like a lot of work. But that is maybe because I never worked in a team or on a product neither. :) Thanks for your silence. Alexander -Original Message- From: sqlsvr [mailto:sql...@yahoo.com] Sent: zondag 13 juni 2010 15:32 To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Rename a table The actual firebird developers response to this CRITICAL BUG is: Thousands of developers worldwide are fine with horse drawn carriages, who needs cars? FIREBIRD IS DANGEROUS, DO NOT USE FOR PRODUCTION ENVIRONMENTS! Also, read Dr. Codds specifications, a DBMS is not a DBMS BY DEFINITION IF IT DOES NOT SUPPORT TABLE RENAMING. -- View this message in context: http://firebird.1100200.n4.nabble.com/Rename-a-table-tp2253220p2253437.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider