Refreshing Test Dbs

Oct 14, 2002

I need to refresh a test db that is running on the same instance as the prod db. Should I just use DTS or is there a better way?

View 3 Replies


ADVERTISEMENT

DB Engine :: Replicate A Master Test Database To 100 Test Environments?

Oct 12, 2015

We are setting up a test lab environment with 100 machines.  We want one master testing db that gets replicated to each to run scripted application tests nightly.  

My goal is to minimize the amount of work to move this thing to each of the 100 test machines.  I am wondering if we need to even have the sql local and invest in a monster db server with 100 copies of the db we restore and each test machine point to their own db on that server, or if I should use db mirroring or something to get the master test db to each of those machines instead.

View 6 Replies View Related

Unit Testing For SSIS - To Test Or Not To Test?

Oct 17, 2006

Now that we have a good programming model in SSIS - the question is whether to write automated unit tests for your packages, and would it generally be a good idea for packages?

Also - if yes to write tests - then where to find more informations regarding How to accomplish that?

View 1 Replies View Related

How To Test SSis Package And What Are The Things I Need To Test It ?

Nov 27, 2007



hi every one,
i need to test SSIS pacakge which will import data from different database where record count is around 5 millions.
iam planning to test it through c# code as well as manually also.
SSIS source : consist of 7 tables
SSIS destination :consist of 7 tables
Using c# code iam trying to run ssis package through batch file.
i am putting expected rowcount, column count in an excel file and comparing same with destination tables by writing query implementing ADO.Net concept.
am i going right way ,can any one suggest best and productive way to test the ssis package .
what are the other things i need to test it.
do any one can add test cases to it.






S.No

Test Case


1

Verify all the tables have been imported.



2

Verify all the rows in each table have been imported.



3

Verify all the columns specified in source query for each table have been imported


4

Verify all the data has been received without any truncation for each column.



5

Verify the schema at source and destination



6

Verify the time taken /speed for data transfer


7

Fields truncated due to difference in length of the field at destination.
Regards
Arif shareef

View 9 Replies View Related

Parameter Isn't Refreshing

Jan 25, 2007

Hi.
I have a datasource that depend on parameter A.
Parameter A get his values from query and have a defualt value.
Parameter B get his default value from query that depend on parameter A.

Now, whan I run the report, parameter A get a value and then parameter B get his value and the
datasource run OK.

But the problem is that when I'm changing the A value (from the value list) - The datasource run fine but Parameter B stay with the old value with out any change.

Does any one know how to solve it.
I'll be happy to give more explanation if it isn't clear enough.

Thanks.

View 5 Replies View Related

Automatic Refreshing

May 9, 2007

I am wondering if it is possible to have a report generated by RS refresh periodically automatically. This could be realized by inserting a few lines of JavaScript to the report including the reload() function, but I do not know if there is anyway to do such thing.



Thanks in advance for any tip!

View 5 Replies View Related

SQL 2012 :: Restore DB From Prod To Test - How To Restore Users In Test

Jun 25, 2015

I need to restore test DB from production backup but once it is restored I would need all the permissions of sql logins and windows AD account intact in test Db as it was before.

View 4 Replies View Related

Refreshing Data In GridView

Sep 18, 2006

Hi,I’m new to SQL Express, but I have created a table and a stored proc to populate it.I have dragged the table into a form so I can view the data in a GridView.I have added a button to add new rows to the table. All the above works fine, except when I hit add, the data gets added, but the GridView doesn’t update and show the new data.  Is there some code I can add to the add button that also refreshed the GridView? ThanksMike

View 2 Replies View Related

Report Continually Refreshing

Jul 19, 2007

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.



I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.



Has anyone seen this problem of a continually refreshing report?



It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.



Thanks in Advance



Peter

View 3 Replies View Related

Refreshing Database Before Restart

Jun 8, 2007



i am running a game from a dedi box .. ms sql..

and every time i restart and put it back up ,,,,it rewinds the database

the only way i can prevent this is if i restart the server

wait a phew hours then put it back up ,,"which makes it the same way it was when i logged off"

i was told that sql database servers refresh every hour.

is there a way i can make it refresh before i restart it so then i can put the server straight back up





if i restart the server back up straight away it does a rewind for some reason.





tech ::

the server does a rewind because it wouldn't have saved the game so to speak - as in updated everyone's characters. So yes waiting is the only way as far as I know to save the game.

View 3 Replies View Related

Refreshing Data In The Cursor.

Nov 17, 2006



Hello everybody,

I wrote a stored procedure for SqlServer 2000 and i am using it for paging purpose.
The procedure is as follows :

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[OLAP_PagedRows]
(
@SelectFields nVarchar(2000) =NULL,

@GroupByFields nvarchar(1000) =NULL,

@BaseTable varchar(100),

@KeyColumn nvarchar(200)=NULL ,

@JoinTables varchar(500) =NULL,

@ConditionalClause varchar(1000) =NULL,

@Pagesize int = 10,

@PageNumber int =1,

@SortExpression nvarchar(200)=NULL,

@SearchText nvarchar(200)=NULL

)

AS

BEGIN



DECLARE @SQLSTMT NVarchar(4000)

DECLARE @SQLSTMT1 NVarchar(4000)



SET @SQLSTMT1 = ''

--check whether page size is given null or not, if so set to default value

IF @Pagesize IS NULL OR @Pagesize = ''

BEGIN

SET @Pagesize =10

END

--check whether page number is given null or not, if so set to default value

IF @PageNumber IS NULL OR @PageNumber = ''

BEGIN

SET @PageNumber =1

END



--Start constructing the query --

SET @SQLSTMT = 'SELECT '

SET @SQLSTMT1 = 'DECLARE @CountValue INT SELECT @CountValue = count(*) From '+@BaseTable

SET @SQLSTMT = @SQLSTMT + @SelectFields + ' FROM '+@BaseTable

If @JoinTables Is Not Null

BEGIN

SET @SQLSTMT = @SQLSTMT + ' ' +@JoinTables

SET @SQLSTMT1 = @SQLSTMT1 + ' ' +@JoinTables

END

DECLARE @StmtWhereClause nvarchar(500)

SET @StmtWhereClause =''

--------------------- Get where conditional clause

If (@SearchText Is Not Null AND RTRIM(LTRIM(@SearchText))<>'')

BEGIN

SET @StmtWhereClause = @StmtWhereClause + ' WHERE ' + @SearchText

END





If @ConditionalClause Is Not Null AND RTRIM(LTRIM(@ConditionalClause))<>''

BEGIN

IF (@StmtWhereClause <> '')

BEGIN

SET @StmtWhereClause= @StmtWhereClause + 'AND ' +@ConditionalClause

END

ELSE

BEGIN

SET @StmtWhereClause = @StmtWhereClause + ' WHERE ' + @ConditionalClause

END

END



SET @SQLSTMT = @SQLSTMT + @StmtWhereClause

SET @SQLSTMT1 = @SQLSTMT1 + @StmtWhereClause

If @GroupByFields Is Not Null And RTRIM(LTRIM(@GroupByFields))<>''

BEGIN

SET @SQLSTMT = @SQLSTMT + ' Group By ' +@GroupByFields

SET @SQLSTMT1 = @SQLSTMT1 + ' Group By ' +@GroupByFields

END

IF @SortExpression Is Not Null AND RTRIM(LTRIM(@SortExpression))<>''

BEGIN

SET @SortExpression = LTRIM(RTRIM(' Order By '+ @SortExpression))

SET @SQLSTMT = @SQLSTMT +' '+ @SortExpression

SET @SQLSTMT1 = @SQLSTMT1 +' '+ @SortExpression

END

SET @SQLSTMT1= @SQLSTMT1+' SELECT @CountValue As MyRows '

--SELECT @SQLSTMT1

--SELECT @SQLSTMT

DECLARE @StartRow INT

SET @SQLSTMT = ' DECLARE temp_Cursor CURSOR SCROLL FOR '+@SQLSTMT

EXECUTE SP_EXECUTESQL @SQLSTMT

Open temp_Cursor

DECLARE @RowCount INT

SET @RowCount = 1

SET @startRow = (@PageSize * (@PageNumber-1))+@RowCount

--SELECT @startRow as 'Current Row'

WHILE @RowCount <= @PageSize

BEGIN

--Select @StartRow 'as @StartRow'

FETCH ABSOLUTE @startRow From temp_Cursor

SET @RowCount= @RowCount+1

SET @StartRow = @startRow + 1

END

deallocate temp_Cursor

EXECUTE SP_EXECUTESQL @SQLSTMT1



END

It is working fine but I have problem with this kind of paging. I need to load the whole data into the cursor and i have to fetch records. The problem is that my table's contains more than Half a million records in it. If I have to load each time this cursor it will be a very big problem on the server side.

Probably it may not be a best solution, but sqlserver 2000 cannot provide more help than this. If I use sub-query for this like using Top <Number> it adversly effecting the nature of the data retrieval.

One solution that I am thinking is Load cursor once and whenever some updations performed on those tables from which cursor is getting data should be automatically reflect the changes.

Is this possible? Please help me.

Regards

Andy Rogers









View 3 Replies View Related

Refreshing A Dataset In RS 2005

Feb 20, 2008



I have a report in RS that uses a cube as a data source. I made some changes to a cube in AS 2005 and I am not sure how I can refresh my existing datasets without deleting everything?


Any feedback is greatly appreciated.
Thanks!

View 4 Replies View Related

Problem With Reportviewer While Refreshing

May 8, 2007



Hai,



Im having a report.When i click on one item in Report it navigate to second Report.Here Second report acts as a Child report.Whne i click on refresh button it goes back parent report.Some times i get error



"
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request. "

Plz help its very imp.

With regards,
Mahender

View 3 Replies View Related

SQLDatasource && Schema Refreshing (with Parameters)

Apr 9, 2006

Hi,
I'm having serious issues trying to refresh a schema in a SQLDatasource.  It is hooked to a stored procedure that takes two varchar(39) parameters.   The default parameters in this case are '%'. Note I am working in the designer.
If I set it up as a stored proc, I can't even get the 'test query' to run in the builder.
If I set it up as a select statement, ala 'exec <procname> @p1, @p2', the 'test query' will run.
In neither case will hitting refresh schema work.  It returns 'Invalid length parameter passed to the substring function'
The stored proc is nothing special, simply returning a select based upon the parameters.
Thanks,
Nick H

View 2 Replies View Related

Automatically Refreshing OLAP Cubes...

Dec 14, 2000

Can someone tell me how you can automate the refresh of OLAP Cubes? I just inhereted a data warehouse running on SQL7 and the idea of having to go in and manually refresh the cubes everyday is, well... stupid. I can't believe that they've been doing this for a year. Unfortunately, I'm not familar enough with MSOLAP yet and I can't figure this out. Any tips?

View 2 Replies View Related

Loosing Connection Upon Refreshing Page

May 31, 2005

Hi,

I'm getting a connection and then loosing my connection upon refreshing the browser with this script connecting to MSSQL using php, when trying the following:


PHP Code:




 $connection = mssql_connect("127.0.0.1","test","") or 
die("Could not connect mssql db on " .$config['dbhost']);
        
mssql_select_db("dbName") or
die("Could not select database " ."dbName"); 






Are their other ways to see more error handling in connecting to MSSQL

View 1 Replies View Related

SQL 2012 :: SSRS Report Is Not Refreshing?

May 12, 2015

I have created an SSRS report, but the data does not refresh. I am using the SSRS Report Buidler to create reports and when I run the query in the dataset, the results return as expected. However, when I run the report itself, the dataset appears old.

View 6 Replies View Related

Refreshing SQL Connection From Access ADP File

May 21, 2008



Hi,
I have many buttons in Access ADP that trigger feeding a table with different data.
Let's call the table tempTable1. I have 600 buttons that feed the make table with all kinds of data:



Code SnippetSELECT * INTO tempTable1 From AnyDataSourceSPViewTable

. There is another menu bar button that only opens


tempTable1. The result for tempTable1 is always correct when you use Query Analyzer. However Access ADP recognizes the change in the table structure when the connection is refreshed. Is there is any way that we can automate the connection refresh procedure or an easier way to get the desired results?

Am using Access 2003 connected to SQL 2005 and trigering the events via VBA.

thank you,

View 3 Replies View Related

Data Is Not Refreshing On The Databse Server With 64 Bit

May 30, 2008



Hi,

Recently we upgraded the SQL sever from 32 bit box to 64 bit and we encounterd some weird results like data was not refreshing unless we manually does a manually refresh.

we just ran some migration scripts from another server to the new 64 bit server and script is correct only thing problem is with data refreshing.

Please send me the solution for the problem and let me is there any script that we can refresh the database using tsql command???

Thanks in Advance,
Shiva.

View 2 Replies View Related

Need To Create Package For Refreshing The Cubes

Apr 4, 2008



We have scenario where we need to create package for refreshing the cubes. Let me explain it breifly.

We are doing ETL process in different ETL tool (not SSIS) and once the process is done, we are inserting in a table where we have a column like date, Completed C as the status. Once we get this information i.e 'Completed C' status and date, we need to refresh the cube like as follows,

1. Previous day cube need to be refreshed daily once
2. Previous week cube need to be refreshed weekly once.
3. Previous month cube need to be refreshed monthly once.
4. Historical cube need to be refreshed daily once.

We have decided all these above operations needs to be done in SSIS. In this case what are the things to be done while creating a package.

1. What are the control flow items to create it in SSIS?
2. Is there any way to have pooling like every 10 minutes to check whether the table has 'Completed C' status and STOP EXECUTE this package?
3. Is there any way to check the date for Previous day cube, Previous week cube, Previous Month cube and Historical cube etc?


Thanks in advance,
Anand Rajagopal

View 7 Replies View Related

Update Statements Delay And Datagrid Refreshing

Mar 28, 2006

I have been posting to the Data Presentation Controls forum for about a month regarding a problem I've been dealing with.

http://forums.asp.net/thread/1223055.aspx

What it boils down to is that on a button click event, I was updating
some records, then re-executing a SELECT statement to get the records
back out and rebind my DataGrids.  This was happening too quickly
and the data was not being updated in time before the SELECT was
executed.  So my grids would still display "old" data.

How do I get SQL Server to commit the UPDATE before my C# code continues?

View 4 Replies View Related

SSRS 2000 Data Not Refreshing In Report

May 7, 2007

Good day,

I have a SSRS 2000 report that when I view the report data does not refresh until I press the refresh data button in the report. Clearly this can't be right and to expect users to press the refresh button every single time is also rediculous.

HAs anyone had this problem before and know what to do.

Please help.

Thanks

View 3 Replies View Related

Refreshing Metadata Of Transformations In The Data Flow

Jan 10, 2007

Hello,

I created a slowly changing dimension object and used an OLE DB Source object with a SQL Command to feed it. After all the SCD objects are created, I get a warning about a truncation which might happen.

I adjust the source query with the right converts, so the query uses data types and lengths which match the target table. I update the OLE DB Source with the new query. Column names are unchanged.

Now how do I get this data flow to reflect the new column lengths? Do I have to throw away all objects and recreate the SCD? The refresh button in the SCD object doesn't do it. This is also a problem when adding columns to your dimension table. Because I modify the stuff that the SCD generates, it's VERY teadious to always have to throw it all away and start over again.

Thnx. Jeroen.

View 7 Replies View Related

Document Map Pane Refreshing ENTIRE Page!

Jul 10, 2006

I am using the ReportViewer control with SRS2005. I have an extremely large report (243 pages) - however. It takes an extremely long time to load the report as well as populate the document map pane.

When one clicks a link in the document map pane, it refreshes the entire page - and thus causes the report to take another 2-3min to repopulate the document map.

However, if I were to access the Report Server directly, clicking a link only causes the main content page to be refreshed.

This is a substantial difference between selectively refreshing as opposed to refreshing the ENTIRE page and hence taking 2-3min between links.

I am defining the report as:

<rsweb:ReportViewer ID="rvMain" runat="server" AsyncRendering="true" ProcessingMode="Remote" ShowParameterPrompts="False" OnPageNavigation="rvMain_PageNavigation" Width="100%" Height="800px" DocumentMapCollapsed="False" DocumentMapWidth="300px">
</rsweb:ReportViewer>

View 1 Replies View Related

Refreshing A Development Database With Production Data

Jan 17, 2007

Hello,

I am trying to refresh a test database with data from a production database. Both database structures are identical, e.g. constraints, stored procs, PK, etc. I am trying to create a package in SSIS that accomplishes this task and I am having extensive problems. The import export wizard is out of the question because the constaints are not carried over, plus when I try to refresh the data using the import export wizard, it fails on 1 specific table because of a column in that table named "Error code". I think "Error code" is a micrsoft keyword, so it fails on this column. Does anyone know a workaround that I can do to accomplish this simple task, that could be completed in minutes using DTS. I understand that SSIS is not as straight forward as DTS, but this task is something that DBA's do on a regular basis and therefore should not be this difficult.

Any help would be appreciated,

David

View 1 Replies View Related

ReportViewer Control - Page Navigation Not Refreshing

Jan 17, 2008

I am using a ReportViewer Control inside of a Windows Form and ran into an issue with the page navigation failing to update upon refresh (the report itself does refresh - the page navigation does not). If the initial report has one page and the subsequent refresh produces five pages, the page navigation window only shows one page. If you manually type in page two or three, nothing happens.

Here is a code snippet:


private void adpTaxServicesForm_Load(object sender, EventArgs e)

{

this.reportViewer.RefreshReport();

}



private void button1_Click(object sender, EventArgs e)

{

this.reportViewer.SuspendLayout();



this.reportViewer1.RefreshReport();

this.reportViewer.ResumeLayout();
}


Any help would be greatly appreciated...

Thanks,

-Fernando

View 1 Replies View Related

Refreshing Data In Hyperion Essbase Cubes

Jul 11, 2006

Hi all,

Normally I would be using SSAS but our finance department make use of Hyperion Essbase. I was wondering whether it was possible to upload data into an Essbase cube using SSIS in the same way that you can use the Analysis Services processing task? I realise there are no specific task for Essbase, but are there any suggestions about what would be the best way of going about this?

regards

 

Colin

View 4 Replies View Related

SSRS 2005 SP1 Report Parameters Not Refreshing

Aug 24, 2007

I am having issues getting my report parameters to refresh when changing their values. I am running SP1 and am trying to mimic the functionality of the Select All for the multi-valued drop-down list. I have a boolean field that I pass to the query that populates the multi-valued list and set a field value to either what is displayed in the list or a -1 (a non-valid option). I then set the default value of the multi-valued list to the value of the new field I created in the query based on if they want to select all values or not.

This works great on the first choice, if I select no, nothing is checked in the list and if I select yes then everything is selected. However, if I select Yes and select No, everything remains checked. It acts like it does a refresh, but does not.

Has anyone else had a similar issue?

Thanks

View 3 Replies View Related

Event Driven Cache Refreshing Script

Aug 27, 2007

Hi,

Can someone share how to setup an event-driven cache refreshing option? The options provided from SSRS interface are based on a fixed schedule. If I would like to setup a dependency in determining when to refresh reports caching, based on the successful refreshing of the underlyinn SSAS cube, how can I achieve it?

Is there an utility/API provided by SSRS? Any samples scripts are very much appreciated.


Thanks,
Jet

View 1 Replies View Related

SQL 2012 :: Refreshing MSDB SSIS Packages From One Server To Another

Mar 25, 2015

I was recently tasked with creating an automated process to refresh SSIS packages from MSDB on one server to another and I decided to go the route of using Powershell, however this wasn't as straight forward as I originally imagined so I thought I would share my solution in case others encounter the same request. The below PowerShell code will create all Integration Services folders from the source MSDB (that contain SSIS packages) on the target instance of MSDB then copy all packages to the proper folder locations. The /QUIET option is used to automatically overwrite packages that already exist on the target so make sure you want to overwrite the current versions of your packages before executing.

[Reflection.Assembly]::LoadWithPartialName("Microsoft.SQLServer.ManagedDTS") | out-NULL

$app = New-Object Microsoft.SqlServer.Dts.Runtime.APPLICATION
$SourceServer = "<source server name>"
$TargetServer = "<target server name>"

$Packages = Invoke-Sqlcmd -MaxCharLength 10000000 -ServerInstance $SourceServer -Query "

[Code] .....

View 0 Replies View Related

Analysis :: Excel 2010 Not Refreshing Data From Cube?

Aug 21, 2015

So I use Excel 2010 connect to a cube I have built.  Then I change some values in the cube via my ETL and re-process the cube.  Then I verify that record is NOT there in the fact table - check!

However, when I refresh the worksheet where the pivot table is pulling data from the cube, but that old record wont go away!

Just realized my cube data source on the dev server, was in fact still configured with my local workstation name. Once I updated that, processed the cube all was well.

View 2 Replies View Related

Problem With Data Refreshing After Insert Or Update Statement

Mar 18, 2008

Dear All,

Im using VS2008, visual basic and SQL Server express.

General questions please: Is it necessary, to issue some sort of command, to 'commit' data to a SQL express database after a INSERT or UPDATE sql command?

I'm getting strange behavior where the data is not refreshed unless i exit my app and re-enter. In other words, i can run a sql command , the data is apparantly saved (because i get no errors) then if i refresh a data set or do a sql select query the data that i expect to return is not there.

Im fairly new to SQL express (and SQL server generally) so i dont know if its my coding or i need to switch some 'feature'
on/off or not.

I hope thats clear

Also, could someone point me to documentation that explains each parameter in the connection string

Many Thanks

Chris Anderson


My code is:


ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:myfile.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

Connection = New SqlConnection

Connection.ConnectionString = ConnectionString

Connection.Open()
'''''''''''''''''the above code is done at the start of my application


'''''''this code below called during application many times


dim sql as string = "my sql string here"

Dim cmd As SqlCommand = Nothing

cmd = New SqlCommand(sql, Connection)






Try

cmd.ExecuteNonQuery()

Catch err As SqlException

MessageBox.Show(err.Message.ToString())

MessageBox.Show(sql, "SQL ERROR: ", MessageBoxButtons.OK, MessageBoxIcon.Error)

End Try



cmd.Dispose()

View 5 Replies View Related

Insufficient Base Table Information For Updating Or Refreshing

Nov 16, 2006

I am using MADC 2.8 to connect to Sql Sever 2000.

The Connection string uses a File DSN.

I get few records into a Record set using Select Command. Then I update one Col in the Recordset and Updates the database table. I open the recordset in

I am getting "Insufficient base table information for updating or refreshing" Error some times. This Code executes in a Multi user Environment.

I tried to recreate this error condition on my local system by Deleteing/Updating the Reocrds from the table and even locking the table.

I get this error "Row cannot be located for updating. Some values may have been changed since it was last read."

Are both of these errors connected? or is there any way i can get rid of this error



The Code is somethng like this

Set objRs = New ADODB.Recordset
objRs.CursorLocation = adUseClient
objRs.Open strSql, SQLCON, adOpenDynamic, adLockOptimistic
If (Not objRs.BOF) And (Not objRs.EOF) Then
objRs.Fields("FLAG") = 1
objRs.Update
VAR1 = objRs.Fields("0")
Else
MsgBox ("No Reocrds exist")
End If


Thanks in Advance for any help



View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved