Hi there! Can anyone help me with this: what dll's do i need in order to export a crystal report to text format during runtime.
When i run my program in visual basic 6, the exporting is done successfully. but when im using it in .exe, errors are generated.
i already used U2FTXT.DLL
what could be the problem?
pls help me... thanks a lot!Look at this thread, you might need one more dll:
http://www.dev-archive.com/forum/showthread.php?t=287692&highlight=export+text
JeffB
Showing posts with label order. Show all posts
Showing posts with label order. Show all posts
Thursday, March 22, 2012
Monday, March 19, 2012
Export Wizard disturb the order of data while exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.
Please give me the solutions.
If the only diffrence in the tables is the order of the rows I would not call it incorrect data. If you need the data to be shown in a especific order you need to use Order By clause in your query
|||i am using order by in my query . Data is correct in Access but order is not correct.|||Dear All,
Thankyou for your replies.
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thankx again for your replies. However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb the order of data while exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.
Please give me the solutions.
If the only diffrence in the tables is the order of the rows I would not call it incorrect data. If you need the data to be shown in a especific order you need to use Order By clause in your query
|||i am using order by in my query . Data is correct in Access but order is not correct.|||Dear All,
Thankyou for your replies.
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thankx again for your replies. However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb the order of data while exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.
Please give me the solutions.
If the only diffrence in the tables is the order of the rows I would not call it incorrect data. If you need the data to be shown in a especific order you need to use Order By clause in your query
|||i am using order by in my query . Data is correct in Access but order is not correct.|||Dear All,
Thankyou for your replies.
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thankx again for your replies. However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb order of data during exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect order of data.
Please give me the solutions.
Speaking logically, sets and tables don’t have order. Order can be specified in a SELECT. Order can be the result of a clustered index but typically there is no guarantee of order without an explicit ORDER BY.
This is generally true of all Relational Databases.
Did you try placing an index on the Access table?
|||True, I believe this more a call from Access 2003 settings to see how data is displayed.
Also check the code in Access about getting this data display.
|||Dear All,
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thank you all of you for your replies.
However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb order of data during exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect order of data.
Please give me the solutions.
Speaking logically, sets and tables don’t have order. Order can be specified in a SELECT. Order can be the result of a clustered index but typically there is no guarantee of order without an explicit ORDER BY.
This is generally true of all Relational Databases.
Did you try placing an index on the Access table?
|||True, I believe this more a call from Access 2003 settings to see how data is displayed.
Also check the code in Access about getting this data display.
|||Dear All,
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thank you all of you for your replies.
However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb order of data during exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect order of data.
Please give me the solutions.
Speaking logically, sets and tables don’t have order. Order can be specified in a SELECT. Order can be the result of a clustered index but typically there is no guarantee of order without an explicit ORDER BY.
This is generally true of all Relational Databases.
Did you try placing an index on the Access table?
|||True, I believe this more a call from Access 2003 settings to see how data is displayed.
Also check the code in Access about getting this data display.
|||Dear All,
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thank you all of you for your replies.
However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
export with a webservice
Hi,
I have created an application with VIsual Studio.NET in C#. I used a
webservice in order to view my reports.
I want export my report in format that I want with this application.
How can I do? What is the solution?I've done this by putting into a dropdownlist the available export formats
for a particular report. then when i go to render the report i have the
following code:
try
{
report =rs.Render(reportPath,format,historyID,devInfo,parameters,credentials,showHideToggle,out
encoding, out mimeType, out optionalParams, out optionalWarnings, out
streamIDs);
switch(format)
{
case "PDF":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/pdf";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "CSV":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "EXCEL":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
default:
Label1.Text = System.Text.Encoding.Default.GetString(report);
break;
}
}
catch (SoapException se)
{
Console.WriteLine(se.Detail.OuterXml);
}
"r388042" wrote:
> Hi,
> I have created an application with VIsual Studio.NET in C#. I used a
> webservice in order to view my reports.
> I want export my report in format that I want with this application.
> How can I do? What is the solution?|||Thanks you!!!
It's run very good!!!
Do you know how we can do in order to export in XML or TIFF?
I have created an application with VIsual Studio.NET in C#. I used a
webservice in order to view my reports.
I want export my report in format that I want with this application.
How can I do? What is the solution?I've done this by putting into a dropdownlist the available export formats
for a particular report. then when i go to render the report i have the
following code:
try
{
report =rs.Render(reportPath,format,historyID,devInfo,parameters,credentials,showHideToggle,out
encoding, out mimeType, out optionalParams, out optionalWarnings, out
streamIDs);
switch(format)
{
case "PDF":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/pdf";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "CSV":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "EXCEL":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
default:
Label1.Text = System.Text.Encoding.Default.GetString(report);
break;
}
}
catch (SoapException se)
{
Console.WriteLine(se.Detail.OuterXml);
}
"r388042" wrote:
> Hi,
> I have created an application with VIsual Studio.NET in C#. I used a
> webservice in order to view my reports.
> I want export my report in format that I want with this application.
> How can I do? What is the solution?|||Thanks you!!!
It's run very good!!!
Do you know how we can do in order to export in XML or TIFF?
Friday, March 9, 2012
Export to PDF in a new window using web service render method
We have an order screen which we would like to be visible at all times, and a
report based off some of the information on that screen. Is there any way to
keep this window open and open the report in a new window? Right now the
button used to launch the report is a server control button. This is what I
use now to open in the same window:
'setup parameters here...
result = rs.Render(reportPath, format, historyID, devInfo, parameters,
credentials, showHideToggle, encoding, mimeType, reportHistoryParameters,
warnings, streamIDs)
sh.SessionId = rs.SessionHeaderValue.SessionId
With Response
.ClearContent()
.AppendHeader("content-length", result.Length.ToString())
.ContentType = "application/pdf"
.BinaryWrite(result)
.Flush()
.Close()
End With
I did some reading and tried using window.open but to no avail. Any
suggestions?Does this help?
For the following you need SP1 or greater installed.
= "javascript:void(window.open('http://www.google.com','_blank'))"
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Treviathon" <Treviathon@.discussions.microsoft.com> wrote in message
news:454A2439-8071-48A2-9476-DA631E985D6C@.microsoft.com...
> We have an order screen which we would like to be visible at all times,
and a
> report based off some of the information on that screen. Is there any way
to
> keep this window open and open the report in a new window? Right now the
> button used to launch the report is a server control button. This is what
I
> use now to open in the same window:
> 'setup parameters here...
> result = rs.Render(reportPath, format, historyID, devInfo, parameters,
> credentials, showHideToggle, encoding, mimeType, reportHistoryParameters,
> warnings, streamIDs)
> sh.SessionId = rs.SessionHeaderValue.SessionId
> With Response
> .ClearContent()
> .AppendHeader("content-length", result.Length.ToString())
> .ContentType = "application/pdf"
> .BinaryWrite(result)
> .Flush()
> .Close()
> End With
> I did some reading and tried using window.open but to no avail. Any
> suggestions?|||I'm trying the same thing.
I've tried your solution, and it doesn't work for me. Maybe I'm
misunderstanding?
I've put the snippet of javascript on the OnClickevent of my asp.net
pushbutton, and I can't compile the project. Can you give me a fuller
sample?
Thx
report based off some of the information on that screen. Is there any way to
keep this window open and open the report in a new window? Right now the
button used to launch the report is a server control button. This is what I
use now to open in the same window:
'setup parameters here...
result = rs.Render(reportPath, format, historyID, devInfo, parameters,
credentials, showHideToggle, encoding, mimeType, reportHistoryParameters,
warnings, streamIDs)
sh.SessionId = rs.SessionHeaderValue.SessionId
With Response
.ClearContent()
.AppendHeader("content-length", result.Length.ToString())
.ContentType = "application/pdf"
.BinaryWrite(result)
.Flush()
.Close()
End With
I did some reading and tried using window.open but to no avail. Any
suggestions?Does this help?
For the following you need SP1 or greater installed.
= "javascript:void(window.open('http://www.google.com','_blank'))"
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Treviathon" <Treviathon@.discussions.microsoft.com> wrote in message
news:454A2439-8071-48A2-9476-DA631E985D6C@.microsoft.com...
> We have an order screen which we would like to be visible at all times,
and a
> report based off some of the information on that screen. Is there any way
to
> keep this window open and open the report in a new window? Right now the
> button used to launch the report is a server control button. This is what
I
> use now to open in the same window:
> 'setup parameters here...
> result = rs.Render(reportPath, format, historyID, devInfo, parameters,
> credentials, showHideToggle, encoding, mimeType, reportHistoryParameters,
> warnings, streamIDs)
> sh.SessionId = rs.SessionHeaderValue.SessionId
> With Response
> .ClearContent()
> .AppendHeader("content-length", result.Length.ToString())
> .ContentType = "application/pdf"
> .BinaryWrite(result)
> .Flush()
> .Close()
> End With
> I did some reading and tried using window.open but to no avail. Any
> suggestions?|||I'm trying the same thing.
I've tried your solution, and it doesn't work for me. Maybe I'm
misunderstanding?
I've put the snippet of javascript on the OnClickevent of my asp.net
pushbutton, and I can't compile the project. Can you give me a fuller
sample?
Thx
Export to PDF and hebrew charcters
Hi
According to SP1 documantation the problem with hebrew charecters appering
in reverse order was resolved in SP1.
Unfortunetly for printing this problem still presists.
which mean I can view the page in PDF on the screen in the right format, but
when I print it the hebrew charcters appears in reverse.
In addtion the only way to view exported PDF reports with hebrew charecters
is with Acorobat Reader 6, previous version
of acrobat reader display message "Unable to find or createthe font
'TimesNewRoman'. Some characters may not display or print correctly" and no
hebrew charecters appears on the report.
I would like to know if this issues are known and when they will be
resolved?
thanks...
YuvalWe believe this is fixed. We tested with both Hebrew and Arabic text and it
worked in our tests. You need to make sure you set the language setting
correctly, set the font to one that has the required glyphs and have the
font installed on both the Report Server machine as well as the client
machine.
If you can post an RDL that doesn't work, we will take a look.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Yuval Rabinovitz" <yvlrb@.netvision.net.il> wrote in message
news:%23mhX4AdWEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi
> According to SP1 documantation the problem with hebrew charecters appering
> in reverse order was resolved in SP1.
> Unfortunetly for printing this problem still presists.
> which mean I can view the page in PDF on the screen in the right format,
> but
> when I print it the hebrew charcters appears in reverse.
> In addtion the only way to view exported PDF reports with hebrew
> charecters
> is with Acorobat Reader 6, previous version
> of acrobat reader display message "Unable to find or createthe font
> 'TimesNewRoman'. Some characters may not display or print correctly" and
> no
> hebrew charecters appears on the report.
> I would like to know if this issues are known and when they will be
> resolved?
> thanks...
> Yuval
>
According to SP1 documantation the problem with hebrew charecters appering
in reverse order was resolved in SP1.
Unfortunetly for printing this problem still presists.
which mean I can view the page in PDF on the screen in the right format, but
when I print it the hebrew charcters appears in reverse.
In addtion the only way to view exported PDF reports with hebrew charecters
is with Acorobat Reader 6, previous version
of acrobat reader display message "Unable to find or createthe font
'TimesNewRoman'. Some characters may not display or print correctly" and no
hebrew charecters appears on the report.
I would like to know if this issues are known and when they will be
resolved?
thanks...
YuvalWe believe this is fixed. We tested with both Hebrew and Arabic text and it
worked in our tests. You need to make sure you set the language setting
correctly, set the font to one that has the required glyphs and have the
font installed on both the Report Server machine as well as the client
machine.
If you can post an RDL that doesn't work, we will take a look.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Yuval Rabinovitz" <yvlrb@.netvision.net.il> wrote in message
news:%23mhX4AdWEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi
> According to SP1 documantation the problem with hebrew charecters appering
> in reverse order was resolved in SP1.
> Unfortunetly for printing this problem still presists.
> which mean I can view the page in PDF on the screen in the right format,
> but
> when I print it the hebrew charcters appears in reverse.
> In addtion the only way to view exported PDF reports with hebrew
> charecters
> is with Acorobat Reader 6, previous version
> of acrobat reader display message "Unable to find or createthe font
> 'TimesNewRoman'. Some characters may not display or print correctly" and
> no
> hebrew charecters appears on the report.
> I would like to know if this issues are known and when they will be
> resolved?
> thanks...
> Yuval
>
Sunday, February 26, 2012
Export to Excel causes merged cells?
I have a report that is a table of data... the users export this report to
excel and then pivot the data in the table in order to cut and slice the data
to do analysis. When they go to insert a pivot table off of this report
Excel throws an error saying that the data source is not valid. What I've
noticed is that when reporting services exports the report to excel it
created one very narrow column and merges that column with the the next and
merges the cells in each of the rows below it' Also, even if I remove the
merged or hidden columns I still can't seem to pivot the data unless I do a
copy paste special values into a new workbook... it won't work if I just
paste into a new worksheet in the same workbook'
Any help you could provide would be greatly appreciated!On Mar 15, 12:54 pm, mr.letni <mrle...@.discussions.microsoft.com>
wrote:
> I have a report that is a table of data... the users export this report to
> excel and then pivot the data in the table in order to cut and slice the data
> to do analysis. When they go to insert a pivot table off of this report
> Excel throws an error saying that the data source is not valid. What I've
> noticed is that when reporting services exports the report to excel it
> created one very narrow column and merges that column with the the next and
> merges the cells in each of the rows below it' Also, even if I remove the
> merged or hidden columns I still can't seem to pivot the data unless I do a
> copy paste special values into a new workbook... it won't work if I just
> paste into a new worksheet in the same workbook'
> Any help you could provide would be greatly appreciated!
If you are using multiple tables (one-above-the-other) in a single
column report, I would suggest making sure that the column widths
match exactly between the multiple tables (that are one-above-the-
other). Also, make sure that your report title/independent textboxes
and table widths are the exact same width (i.e., don't have a report
title textbox smaller in width than the table(s) width). Other similar
kinds of nuances should apply as well. It depends on which axis you
see the merged cells on as far as which items need to be expanded to
match widths, etc. Also, make sure that there is no open space below
all items in the report to the bottom report border and no open space
to the right of the report items to the right border of the report.
I've had some very picky clients in regards to merged cell exports to
Excel and this was how I alleviated the merged cells for them. Hope
this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||The main issue I have seen is when I use a textbox at the top of my report
to put my title in. Instead, add additional header rows, then merge the
header row cells that you want to put your title in. When you use a text box
you end up with merged fields that then prevents sorting (or other
operations) on the data in Excel.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mr.letni" <mrletni@.discussions.microsoft.com> wrote in message
news:4DD288E7-2C95-4A53-BB29-A86283B1C962@.microsoft.com...
>I have a report that is a table of data... the users export this report to
> excel and then pivot the data in the table in order to cut and slice the
> data
> to do analysis. When they go to insert a pivot table off of this report
> Excel throws an error saying that the data source is not valid. What I've
> noticed is that when reporting services exports the report to excel it
> created one very narrow column and merges that column with the the next
> and
> merges the cells in each of the rows below it' Also, even if I remove
> the
> merged or hidden columns I still can't seem to pivot the data unless I do
> a
> copy paste special values into a new workbook... it won't work if I just
> paste into a new worksheet in the same workbook'
> Any help you could provide would be greatly appreciated!
excel and then pivot the data in the table in order to cut and slice the data
to do analysis. When they go to insert a pivot table off of this report
Excel throws an error saying that the data source is not valid. What I've
noticed is that when reporting services exports the report to excel it
created one very narrow column and merges that column with the the next and
merges the cells in each of the rows below it' Also, even if I remove the
merged or hidden columns I still can't seem to pivot the data unless I do a
copy paste special values into a new workbook... it won't work if I just
paste into a new worksheet in the same workbook'
Any help you could provide would be greatly appreciated!On Mar 15, 12:54 pm, mr.letni <mrle...@.discussions.microsoft.com>
wrote:
> I have a report that is a table of data... the users export this report to
> excel and then pivot the data in the table in order to cut and slice the data
> to do analysis. When they go to insert a pivot table off of this report
> Excel throws an error saying that the data source is not valid. What I've
> noticed is that when reporting services exports the report to excel it
> created one very narrow column and merges that column with the the next and
> merges the cells in each of the rows below it' Also, even if I remove the
> merged or hidden columns I still can't seem to pivot the data unless I do a
> copy paste special values into a new workbook... it won't work if I just
> paste into a new worksheet in the same workbook'
> Any help you could provide would be greatly appreciated!
If you are using multiple tables (one-above-the-other) in a single
column report, I would suggest making sure that the column widths
match exactly between the multiple tables (that are one-above-the-
other). Also, make sure that your report title/independent textboxes
and table widths are the exact same width (i.e., don't have a report
title textbox smaller in width than the table(s) width). Other similar
kinds of nuances should apply as well. It depends on which axis you
see the merged cells on as far as which items need to be expanded to
match widths, etc. Also, make sure that there is no open space below
all items in the report to the bottom report border and no open space
to the right of the report items to the right border of the report.
I've had some very picky clients in regards to merged cell exports to
Excel and this was how I alleviated the merged cells for them. Hope
this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||The main issue I have seen is when I use a textbox at the top of my report
to put my title in. Instead, add additional header rows, then merge the
header row cells that you want to put your title in. When you use a text box
you end up with merged fields that then prevents sorting (or other
operations) on the data in Excel.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mr.letni" <mrletni@.discussions.microsoft.com> wrote in message
news:4DD288E7-2C95-4A53-BB29-A86283B1C962@.microsoft.com...
>I have a report that is a table of data... the users export this report to
> excel and then pivot the data in the table in order to cut and slice the
> data
> to do analysis. When they go to insert a pivot table off of this report
> Excel throws an error saying that the data source is not valid. What I've
> noticed is that when reporting services exports the report to excel it
> created one very narrow column and merges that column with the the next
> and
> merges the cells in each of the rows below it' Also, even if I remove
> the
> merged or hidden columns I still can't seem to pivot the data unless I do
> a
> copy paste special values into a new workbook... it won't work if I just
> paste into a new worksheet in the same workbook'
> Any help you could provide would be greatly appreciated!
Friday, February 17, 2012
Export Stored Procedure SQL Script
We usually keep an "installation " table , when we save out stored
procedures they are ordered by the stated execution order. (customised
script)
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eXOzROPmGHA.4164@.TK2MSFTNGP03.phx.gbl...
> I just use the 'Generate SQL Script' from EM to export stored procedure.
> How do I export the Stored Procedure SQL Script in to a file so in an
order
> so that they can be created successfully ?
> I got an error when execute the scripts:
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'sp1'. The stored procedure will still be
> created.
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'sp2'. The stored procedure will still be
> created.
> ...............
> ...............
> How do I get around that ?
>I just use the 'Generate SQL Script' from EM to export stored procedure.
How do I export the Stored Procedure SQL Script in to a file so in an order
so that they can be created successfully ?
I got an error when execute the scripts:
Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp1'. The stored procedure will still be
created.
Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp2'. The stored procedure will still be
created.
...............
...............
How do I get around that ?|||We usually keep an "installation " table , when we save out stored
procedures they are ordered by the stated execution order. (customised
script)
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eXOzROPmGHA.4164@.TK2MSFTNGP03.phx.gbl...
> I just use the 'Generate SQL Script' from EM to export stored procedure.
> How do I export the Stored Procedure SQL Script in to a file so in an
order
> so that they can be created successfully ?
> I got an error when execute the scripts:
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'sp1'. The stored procedure will still be
> created.
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'sp2'. The stored procedure will still be
> created.
> ...............
> ...............
> How do I get around that ?
>
procedures they are ordered by the stated execution order. (customised
script)
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eXOzROPmGHA.4164@.TK2MSFTNGP03.phx.gbl...
> I just use the 'Generate SQL Script' from EM to export stored procedure.
> How do I export the Stored Procedure SQL Script in to a file so in an
order
> so that they can be created successfully ?
> I got an error when execute the scripts:
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'sp1'. The stored procedure will still be
> created.
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'sp2'. The stored procedure will still be
> created.
> ...............
> ...............
> How do I get around that ?
>I just use the 'Generate SQL Script' from EM to export stored procedure.
How do I export the Stored Procedure SQL Script in to a file so in an order
so that they can be created successfully ?
I got an error when execute the scripts:
Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp1'. The stored procedure will still be
created.
Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp2'. The stored procedure will still be
created.
...............
...............
How do I get around that ?|||We usually keep an "installation " table , when we save out stored
procedures they are ordered by the stated execution order. (customised
script)
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eXOzROPmGHA.4164@.TK2MSFTNGP03.phx.gbl...
> I just use the 'Generate SQL Script' from EM to export stored procedure.
> How do I export the Stored Procedure SQL Script in to a file so in an
order
> so that they can be created successfully ?
> I got an error when execute the scripts:
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'sp1'. The stored procedure will still be
> created.
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'sp2'. The stored procedure will still be
> created.
> ...............
> ...............
> How do I get around that ?
>
Wednesday, February 15, 2012
Export script data from sql server - suggestions for this case
Hello Guys,
I would like to export my database into a file in order to be used in
another server that I do not know? So, I would to be able to exprot
all the table structure, stored procedures and data (insert into).
How can I do it?
InaPerhaps you just need a database backup.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>|||Ben
She wanted as I understood her only table's structure without any data
So , he may want to use SQLDMO objects to script out or Generate Script
Option in the EM
Sub ScriptDB(strLogin As String, strPwd As String, _
strDataBase As String, StrFilePath As String)
Dim sql As Object
Dim db As Object
Dim objTrigger As Object
Dim intOptions As Long
Dim genObj
Set sql = CreateObject("SQLDMO.SQLServer")
Set db = CreateObject("SQLDMO.Database")
Set objTrigger = CreateObject("SQLDMO.Trigger")
Const sDrops As Integer = 1
Const sIncludeHeaders As Long = 131072
Const sDefault As Integer = 4
Const sAppendToFile As Integer = 256
Const sBindings As Integer = 128
' Set scripting options. Because you need to specify multiple behaviors
' for the ScriptType argument, you use "Or" to combine these.
intOptions = sDrops Or sIncludeHeaders Or _
sDefault Or sAppendToFile Or sBindings
' Connect to local server
sql.Connect "(local)", strLogin, strPwd
Set db = sql.Databases(strDataBase, "dbo")
' Script User Defined Data Types
For Each genObj In db.UserDefinedDatatypes
genObj.Script intOptions, StrFilePath
Next
' Script Tables and Triggers, ignoring system
' tables and system generated triggers
For Each genObj In db.Tables
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
For Each objTrigger In genObj.Triggers
If objTrigger.SystemObject = False Then
objTrigger.Script intOptions, StrFilePath
End If
Next
End If
Next
' Script Rules
For Each genObj In db.Rules
genObj.Script intOptions, StrFilePath
Next
' Script Defaults
For Each genObj In db.Defaults
genObj.Script intOptions, StrFilePath
Next
' Script Sprocs, ignoring system sprocs
For Each genObj In db.StoredProcedures
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
End If
Next
' Script Views, ignoring system views and informational schemas
For Each genObj In db.Views
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
End If
Next
MsgBox "Finished generating SQL scripts."
End Sub
Save the module as MyModule.
Call ScriptDB("UserName","Password","DatabaseName","C:\MyResults.SQL")
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:03E4FC21-234C-42DF-BF2D-649922C22CE0@.microsoft.com...
> Perhaps you just need a database backup.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "ina" wrote:
>> Hello Guys,
>> I would like to export my database into a file in order to be used in
>> another server that I do not know? So, I would to be able to exprot
>> all the table structure, stored procedures and data (insert into).
>> How can I do it?
>> Ina
>>|||thanks but I would like to data too (copy the backup only is a
solution). But this script is very cool. Thanks|||Use www.sqlscripter.com to generate the data scripts for tables.
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>|||Thank you thomas. I will have a look on this tools.
Ina
Thomas wrote:
> Use www.sqlscripter.com to generate the data scripts for tables.
> "ina" wrote:
> > Hello Guys,
> >
> > I would like to export my database into a file in order to be used in
> > another server that I do not know? So, I would to be able to exprot
> > all the table structure, stored procedures and data (insert into).
> >
> > How can I do it?
> >
> > Ina
> >
> >
I would like to export my database into a file in order to be used in
another server that I do not know? So, I would to be able to exprot
all the table structure, stored procedures and data (insert into).
How can I do it?
InaPerhaps you just need a database backup.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>|||Ben
She wanted as I understood her only table's structure without any data
So , he may want to use SQLDMO objects to script out or Generate Script
Option in the EM
Sub ScriptDB(strLogin As String, strPwd As String, _
strDataBase As String, StrFilePath As String)
Dim sql As Object
Dim db As Object
Dim objTrigger As Object
Dim intOptions As Long
Dim genObj
Set sql = CreateObject("SQLDMO.SQLServer")
Set db = CreateObject("SQLDMO.Database")
Set objTrigger = CreateObject("SQLDMO.Trigger")
Const sDrops As Integer = 1
Const sIncludeHeaders As Long = 131072
Const sDefault As Integer = 4
Const sAppendToFile As Integer = 256
Const sBindings As Integer = 128
' Set scripting options. Because you need to specify multiple behaviors
' for the ScriptType argument, you use "Or" to combine these.
intOptions = sDrops Or sIncludeHeaders Or _
sDefault Or sAppendToFile Or sBindings
' Connect to local server
sql.Connect "(local)", strLogin, strPwd
Set db = sql.Databases(strDataBase, "dbo")
' Script User Defined Data Types
For Each genObj In db.UserDefinedDatatypes
genObj.Script intOptions, StrFilePath
Next
' Script Tables and Triggers, ignoring system
' tables and system generated triggers
For Each genObj In db.Tables
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
For Each objTrigger In genObj.Triggers
If objTrigger.SystemObject = False Then
objTrigger.Script intOptions, StrFilePath
End If
Next
End If
Next
' Script Rules
For Each genObj In db.Rules
genObj.Script intOptions, StrFilePath
Next
' Script Defaults
For Each genObj In db.Defaults
genObj.Script intOptions, StrFilePath
Next
' Script Sprocs, ignoring system sprocs
For Each genObj In db.StoredProcedures
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
End If
Next
' Script Views, ignoring system views and informational schemas
For Each genObj In db.Views
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
End If
Next
MsgBox "Finished generating SQL scripts."
End Sub
Save the module as MyModule.
Call ScriptDB("UserName","Password","DatabaseName","C:\MyResults.SQL")
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:03E4FC21-234C-42DF-BF2D-649922C22CE0@.microsoft.com...
> Perhaps you just need a database backup.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "ina" wrote:
>> Hello Guys,
>> I would like to export my database into a file in order to be used in
>> another server that I do not know? So, I would to be able to exprot
>> all the table structure, stored procedures and data (insert into).
>> How can I do it?
>> Ina
>>|||thanks but I would like to data too (copy the backup only is a
solution). But this script is very cool. Thanks|||Use www.sqlscripter.com to generate the data scripts for tables.
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>|||Thank you thomas. I will have a look on this tools.
Ina
Thomas wrote:
> Use www.sqlscripter.com to generate the data scripts for tables.
> "ina" wrote:
> > Hello Guys,
> >
> > I would like to export my database into a file in order to be used in
> > another server that I do not know? So, I would to be able to exprot
> > all the table structure, stored procedures and data (insert into).
> >
> > How can I do it?
> >
> > Ina
> >
> >
Export script data from sql server - suggestions for this case
Hello Guys,
I would like to export my database into a file in order to be used in
another server that I do not know? So, I would to be able to exprot
all the table structure, stored procedures and data (insert into).
How can I do it?
InaPerhaps you just need a database backup.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>|||Ben
She wanted as I understood her only table's structure without any data
So , he may want to use SQLDMO objects to script out or Generate Script
Option in the EM
Sub ScriptDB(strLogin As String, strPwd As String, _
strDataBase As String, StrFilePath As String)
Dim sql As Object
Dim db As Object
Dim objTrigger As Object
Dim intOptions As Long
Dim genObj
Set sql = CreateObject("SQLDMO.SQLServer")
Set db = CreateObject("SQLDMO.Database")
Set objTrigger = CreateObject("SQLDMO.Trigger")
Const sDrops As Integer = 1
Const sIncludeHeaders As Long = 131072
Const sDefault As Integer = 4
Const sAppendToFile As Integer = 256
Const sBindings As Integer = 128
' Set scripting options. Because you need to specify multiple behaviors
' for the ScriptType argument, you use "Or" to combine these.
intOptions = sDrops Or sIncludeHeaders Or _
sDefault Or sAppendToFile Or sBindings
' Connect to local server
sql.Connect "(local)", strLogin, strPwd
Set db = sql.Databases(strDataBase, "dbo")
' Script User Defined Data Types
For Each genObj In db.UserDefinedDatatypes
genObj.Script intOptions, StrFilePath
Next
' Script Tables and Triggers, ignoring system
' tables and system generated triggers
For Each genObj In db.Tables
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
For Each objTrigger In genObj.Triggers
If objTrigger.SystemObject = False Then
objTrigger.Script intOptions, StrFilePath
End If
Next
End If
Next
' Script Rules
For Each genObj In db.Rules
genObj.Script intOptions, StrFilePath
Next
' Script Defaults
For Each genObj In db.Defaults
genObj.Script intOptions, StrFilePath
Next
' Script Sprocs, ignoring system sprocs
For Each genObj In db.StoredProcedures
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
End If
Next
' Script Views, ignoring system views and informational schemas
For Each genObj In db.Views
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
End If
Next
MsgBox "Finished generating SQL scripts."
End Sub
Save the module as MyModule.
Call ScriptDB("UserName","Password","DatabaseName","C:\MyResults.SQL")
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:03E4FC21-234C-42DF-BF2D-649922C22CE0@.microsoft.com...[vbcol=seagreen]
> Perhaps you just need a database backup.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "ina" wrote:
>|||Use www.sqlscripter.com to generate the data scripts for tables.
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>|||Use www.sqlscripter.com to generate the data scripts for tables.
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>
I would like to export my database into a file in order to be used in
another server that I do not know? So, I would to be able to exprot
all the table structure, stored procedures and data (insert into).
How can I do it?
InaPerhaps you just need a database backup.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>|||Ben
She wanted as I understood her only table's structure without any data
So , he may want to use SQLDMO objects to script out or Generate Script
Option in the EM
Sub ScriptDB(strLogin As String, strPwd As String, _
strDataBase As String, StrFilePath As String)
Dim sql As Object
Dim db As Object
Dim objTrigger As Object
Dim intOptions As Long
Dim genObj
Set sql = CreateObject("SQLDMO.SQLServer")
Set db = CreateObject("SQLDMO.Database")
Set objTrigger = CreateObject("SQLDMO.Trigger")
Const sDrops As Integer = 1
Const sIncludeHeaders As Long = 131072
Const sDefault As Integer = 4
Const sAppendToFile As Integer = 256
Const sBindings As Integer = 128
' Set scripting options. Because you need to specify multiple behaviors
' for the ScriptType argument, you use "Or" to combine these.
intOptions = sDrops Or sIncludeHeaders Or _
sDefault Or sAppendToFile Or sBindings
' Connect to local server
sql.Connect "(local)", strLogin, strPwd
Set db = sql.Databases(strDataBase, "dbo")
' Script User Defined Data Types
For Each genObj In db.UserDefinedDatatypes
genObj.Script intOptions, StrFilePath
Next
' Script Tables and Triggers, ignoring system
' tables and system generated triggers
For Each genObj In db.Tables
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
For Each objTrigger In genObj.Triggers
If objTrigger.SystemObject = False Then
objTrigger.Script intOptions, StrFilePath
End If
Next
End If
Next
' Script Rules
For Each genObj In db.Rules
genObj.Script intOptions, StrFilePath
Next
' Script Defaults
For Each genObj In db.Defaults
genObj.Script intOptions, StrFilePath
Next
' Script Sprocs, ignoring system sprocs
For Each genObj In db.StoredProcedures
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
End If
Next
' Script Views, ignoring system views and informational schemas
For Each genObj In db.Views
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath
End If
Next
MsgBox "Finished generating SQL scripts."
End Sub
Save the module as MyModule.
Call ScriptDB("UserName","Password","DatabaseName","C:\MyResults.SQL")
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:03E4FC21-234C-42DF-BF2D-649922C22CE0@.microsoft.com...[vbcol=seagreen]
> Perhaps you just need a database backup.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "ina" wrote:
>|||Use www.sqlscripter.com to generate the data scripts for tables.
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>|||Use www.sqlscripter.com to generate the data scripts for tables.
"ina" wrote:
> Hello Guys,
> I would like to export my database into a file in order to be used in
> another server that I do not know? So, I would to be able to exprot
> all the table structure, stored procedures and data (insert into).
> How can I do it?
> Ina
>
Subscribe to:
Posts (Atom)