|
The best way to do this is to perform a full backup on one database, then restore it to the other computer. Backup and restore will guarantee that the data is consistent. Opening and copying database files from the operating system could potentially cause data corruption by locking the datafile outside the scope of the database engine.
|
|
|
|
|
If one of the servers is SQL 2005 you can use Copy DataBase Wizard
|
|
|
|
|
Hello,
I was able to take the backup but restoring was giving problem. I got the backup on SQL 7 and restoring it on ver 8 .
What must be the problem?
Regards,
Pritha
|
|
|
|
|
You cannot directly copy database files (not actual files or backups) between different versions since they are not compatible.
If you want to move to a newer version, you can:
- take a backup from version 7
- use version 7 instance and restore the backup
- upgrade the instance to version 8
- take a backup from version 8
- restore the backup to desired instance of version 8 if the upgrade was done using *temporary* instance
or you can use DTS and model a transfer between servers (use DTS at the site where version is higher)
Hope this helps,
Mika
The need to optimize rises from a bad design
|
|
|
|
|
Thanks
so this was version problem
Pritha
|
|
|
|
|
I believe so. You're welcome 
Mika
The need to optimize rises from a bad design
|
|
|
|
|
|
I'm a newbie so go easy,
Here is the setup:
sharepoint services 3.0
sql 2005 server
Cognos marketing software for dashboards
I just started at this job and the marketing department would like to gather data from sharepoint. They have setup a survey using the survey template in sharepoint services 3.0(I wish they would of used infopath and a dedicated database but oh well). Because we don't have sharepoint 2007 portal and only services 3.0 they are using a product called Cognos. It creates charts and dashboards. They can collect from pretty much any type of database out there. My Question is If someone uses the default survey template inside sharepoint services, where in the world is that data being placed? I've tried to manually search and can not find any data. I have also searched for the last week or so on the net and all I can find is articles about sharepoint 2007 portal. It must be hidden in there some place. Can anyone help? 
|
|
|
|
|
humm no reply yet.. and this is a SQL database question by the way....
|
|
|
|
|
Hello,
I am using an Accordion to house textboxes on my page. The problem I am having when inserting it is saying it cannot find the control txtDescription. When writing code in the code behind I can type txtDescription so I can see it from there. For some reason it cannot find that textbox. Possibly many more since it stops at the first one and throws that error. Everything is in an Accordion besides the SQLDATASOURCE
HEre is the SqlDataSource:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:GrantConnectionString %>"
InsertCommand="INSERT INTO [Grant_Table] ([Jurisdiction], [Input_Date], [Description], [FY], [Invoice_Number], [Inventory_Number], [Category], [Equipment_Location_Address], [Equipment_Location_City], [Equipment_Location_State], [Equipment_Location_ZIP], [Cost_PPI], [Cost_TAX], [Cost_Shipping], [Cost_TOTAL], [Received], [Equipment_Status], [AWIN_Serial], [AWIN_Operator], [AWIN_Call_Sign], [Contact_Name], [Contact_Phone], [Contact_Address], [Contact_City], [Contact_State], [Contact_ZIP], [Notes]) VALUES (@Jurisdiction, @Input_Date, @Description, @FY, @Invoice_Number, @Inventory_Number, @Category, @Equipment_Location_Address, @Equipment_Location_City, @Equipment_Location_State, @Equipment_Location_ZIP, @Cost_PPI, @Cost_TAX, @Cost_Shipping, @Cost_TOTAL, @Received, @Equipment_Status, @AWIN_Serial, @AWIN_Operator, @AWIN_Call_Sign, @Contact_Name, @Contact_Phone, @Contact_Address, @Contact_City, @Contact_State, @Contact_ZIP, @Notes)"
SelectCommand="SELECT [ID], [Jurisdiction], [Input_Date], [Description], [FY], [Invoice_Number], [Inventory_Number], [Category], [Equipment_Location_Address], [Equipment_Location_City], [Equipment_Location_State], [Equipment_Location_ZIP], [Cost_PPI], [Cost_TAX], [Cost_Shipping], [Cost_TOTAL], [Received], [Equipment_Status], [AWIN_Serial], [AWIN_Operator], [AWIN_Call_Sign], [Contact_Name], [Contact_Phone], [Contact_Address], [Contact_City], [Contact_State], [Contact_ZIP], [Notes] FROM [Grant_Table]">
<InsertParameters>
<asp:QueryStringParameter Name="Jurisdiction" QueryStringField="UserLocation"
Type="String" />
<asp:ControlParameter ControlID="txtInput_Date" Name="Input_Date"
Type="DateTime" />
<asp:ControlParameter ControlID="txtDescription" Name="Description"
PropertyName="Text" Type="String" />
<asp:QueryStringParameter Name="FY" QueryStringField="FY" Type="String" />
<asp:ControlParameter ControlID="txtInvoiceNumber" Name="Invoice_Number"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtInventoryNumber" Name="Inventory_Number"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtCategory" Name="Category"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtAddress" Name="Equipment_Location_Address"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtCity" Name="Equipment_Location_City"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtState" Name="Equipment_Location_State"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtZipCode" Name="Equipment_Location_ZIP"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtCostPPI" Name="Cost_PPI"
PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="txtTax" Name="Cost_TAX" PropertyName="Text"
Type="Decimal" />
<asp:ControlParameter ControlID="txtShipping" Name="Cost_Shipping"
PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="costLiteral" Name="Cost_TOTAL"
PropertyName="Text" Type="Decimal" />
<asp:ControlParameter ControlID="txtReceived" Name="Received"
PropertyName="Text" Type="DateTime" />
<asp:ControlParameter ControlID="txtEquipmentStatus" Name="Equipment_Status"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtAWINSerial" Name="AWIN_Serial"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtAWINOperator" Name="AWIN_Operator"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtAWINCallSign" Name="AWIN_Call_Sign"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtContactName" Name="Contact_Name"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtContactPhone" Name="Contact_Phone"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtContactAddress" Name="Contact_Address"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtCity" Name="Contact_City"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtContactState" Name="Contact_State"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtContactZip" Name="Contact_ZIP"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="txtNotes" Name="Notes" PropertyName="Text"
Type="String" />
</InsertParameters>
</asp:SqlDataSource>
Here is the error:
Source:
System.Web
Data:
System.Collections.ListDictionaryInternal
Inner Exception:
Location:
add.aspx
Message:
Could not find control 'txtDescription' in ControlParameter 'Description'.
|
|
|
|
|
I HAVE A COLUMN WHICH NAME IS "ID.ID2"
I WANT TO RENAME BY USE FOLLOWING QUERY:
SP_RENAME 'T1.ID2','ID'
BUT I GOT AN ERROR:
No item by the name of 'T1.ID2' could be found in the current database 'Zaid', given that @itemtype was input as '(null)'.
I ALSO TRY TO THIS COLUMN THROUGH THIS QUERY
ALTER TABLE T1
DROP COLUMN T1.ID2
BUT IT ALSO GIVES AN ERROR
Incorrect syntax near '.'.
please solve it
|
|
|
|
|
Its a typo
try
SP_RENAME 'T1.[ID.ID2]','ID'
(or whatever your column is called, it should be
SP_RENAME '{tablename}.{columnname}','{newcolumnname}'
Bob
Ashfield Consultants Ltd
|
|
|
|
|
thank u very much.
My problem have been solved
|
|
|
|
|
how to copy all records in one database to another database table in sql server 2005
|
|
|
|
|
insert into table2(column list) select (column list) from table1
not really difficult is it?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
It can also be done via SQL Server Management Studio, Object Explorer, Tasks and SQL Import and Export Wizard. I use this method as I have around 10-13 tables and their data to be moved from one database to another.
|
|
|
|
|
Hi,
It is quite annoying problem and I couldn't figure out what is causing it. The problem is:
When I invoke a stored procedure inside a sub procedure, it is working fine. However, when I try to invoke a stored procedure when I submit the web page, none of stored procedures are working even connection string and and assigned parameters are true as it can be seen below. "I get too many arguments error"
When I use a query in the aspx page, it works but when I invoke a stored procedure I get error message. What could cause the issue related to SQL SERVERS EXPRESS 2008?
<br />
<br />
'THIS IS THE CODE INSIDE AN ASPX FILE<br />
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HolidayDBConnectionString %>" <br />
InsertCommand='StoredProcedure1' <br />
<br />
<br />
SelectCommand="SELECT DISTINCT [ActivityName] FROM [Activities] ORDER BY [ActivityName]" <br />
InsertCommandType="StoredProcedure"><br />
<InsertParameters><br />
<asp:Parameter Name="GetActivityName" Type="String" /><br />
</InsertParameters><br />
</asp:SqlDataSource><br />
<br />
<br />
'HERE IS THE STORED PROCEDURE<br />
<br />
ALTER PROCEDURE dbo.StoredProcedure1 <br />
(<br />
@GetActivityName nvarchar(50)<br />
) <br />
AS<br />
<br />
<br />
INSERT INTO Activities VALUES (@GetActivityName)<br />
<br />
<br />
RETURN<br />
<br />
<br />
<br />
'HERE IS THE TABLE DEFINITION<br />
<br />
[PK] ActivityNumber bigint (IDENTITY COLUM) ALLOW NULLS FALSE<br />
ActivityName nvarchar(50) ALLOW NULLS FALSE<br />
<br />
<br />
Thanks.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
First, change this line
INSERT INTO Activities VALUES (@GetActivityName)
to this
INSERT INTO Activities(ActivityName) VALUES (@GetActivityName)
and possibly try forcing your asp application to totally restart -I have seen similar problems due to caching with web apps.
Hope this helps
Bob
Ashfield Consultants Ltd
|
|
|
|
|
There is no need to define it in SQL EXPRESS 2008 as at the way you presented. You don't have to define Activities(ActivityName) after INSERT INTO.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
JUNEYT wrote: There is no need to define it in SQL EXPRESS 2008 as at the way you presented. You don't have to define Activities(ActivityName) after INSERT INTO.
Possibly not, but its good practice to define which columns you are inserting into. In this instance its easy, but if you had a table of 200 columns it would be a major headache.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I second that.
As I recall it hasn't been mandatory to list target fields since mid 90's (depending on the db), but it sure helps (especially afterwards when little bit adding fields, renaming them and dropping a few  )
The need to optimize rises from a bad design
|
|
|
|
|
I need some pointers please. My friend Google overwhelms me when I ask "Distributed systems designs" or something similar.
We need to design a system with a 1000+ smallish and geographically distributed sites, each with a significant percentage of local, but volatile data. Think a distribution company with 1000+ outlets with "virtual stock" (thats voucher numbers which have real value). Each outlet has its own stock levels and customers but needs to know in realtime info of customers at other sites and global stock levels and goodness knows what else.
A somewhat reliable VPN is available to all sites.
Options:
1. I do not think this is a scenario where we occasionally update a central server with all local transactions (aggregate or even detailed), the data is too shared and needs to be near realtime for a significant proportion of the time.
2. Having one Hulk-sized setup centrally should work fine, but you cannot bring each site to a halt when there is a problem at the central server or the line to it has gone bad.
3. My idea is to use the one central hulk-sized server when all goes well, thereby avoiding all the distributed complexities (most of the time), but to switch over to a local DB when the line or central server goes bad, so that at least a significant proportion of transactions can continue.
Is Microsoft's Dryad any good here ?
Thanks in advance
|
|
|
|
|
Seems like you have a headache coming...
Seriously, if not already done so, read about the concepts (for example from BOL) for:
- distributed transactions (two-phase commit and especialy DTS in Microsoft world)
- linked servers
- transactional replication
- service broker and message queues
These should give you info on somewhat different technologies for distributed systems at database level.
Hope this helps,
Mika
The need to optimize rises from a bad design
|
|
|
|
|
Hi
First of all I have to say, that I'm in no way an SQL expert more likely an SQL dummy, so be warned. 
I'm am currently building an InnoSetup installer hierarchy and as a part of that I have made a prerequisite downloader+installer for various Microsoft items - .NET Frameworks, Windows Installers, Internet Explorers, MDAC etc.
To detect the various components I use mostly registration keys, but as I played around with SQL Server 2005 Express I found out, that registration keys wasn't a good way detect it. Instead I tried creating an Ole object like this:
function SQLServerExpress2005Exist(): Boolean;
begin
Result := True;
try
SQLServer := CreateOleObject('SQLDMO.SQLServer');
except
if MsgBox(CustomMessage('SQLServerExpress2005Msg'), mbConfirmation, MB_YESNO or MB_DEFBUTTON2) = IDYES then Result := False;
end;
end;This method works when trying to detect an SQL Server 2005, but when I try using the same method on my computer with a running SQL Server 2008 Express, it doesn't work i.e. the code enters the except block.
What is the best way to detect an installed (not necessarily running) SQL Server 2008?
I'm in the high-fidelity first class traveling set.
And I think I need a Lear jet.
|
|
|
|
|
try System.Data.Sql.SqlDataSourceEnumerator.Instance.GetDataSources();
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
