 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
Script Table Data malfunction... |
|
It seems that scripting out data does not work properly when you have brackets in the selected table names (yes, I know, it's weird to have brackets in the table name but mssql 2k8 allows it, and I've got a database containing a bunch of such tables).
In the messages window I could see lines 'x rows fetched from database.schema.table' but the file that was created missed insert statements from tables that came before the tables with brackets in their name. The comment lines in the files were also placed incorrectly
 |
 |
/* Inserting database.schema.table_2 data... */
INSERT INTO database.schema.table_3
.
.
.
|
|
|
Tue May 18, 2010 7:02 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you for reporting this issue. I am going to log it to our internal issue tracking system. Your feedback is much appreciated!
|
|
Tue May 18, 2010 8:27 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|