|
A client has gone and ordered a new server to run my software, the new server has SQL Server 2005 installed. Are there any gotcha's that I need to watch out for when transferring an SQL Server 2000 system to SQL Server 2005. Especially when copying an existing database from one server to another.
I'm going to be googling all night, but I thought I'd see if anybody here has any advice they'd care to share.
|
|
|
|
|
You should be aware that SQL 2005 installs with all remote protocols disabled by default. You may need to configure (enable) the appropriate network protocols before you can connect to it from another node (or the internet). If the new server has the windows firewall enabled, you may also need to unblock the apprpriate TCP port (1433 IIRC).
|
|
|
|
|
Hi , I have reverse problem .. I have my DB in SQL 2005 (designed in Express edition) but my hoster supports SQL 2000 only .. Pls advice how i can do that ... I generated .BAK of my DB but it didnt work with hoster ...
|
|
|
|
|
It's likely that the only thing you can do is export your database then import it into sql 2000. You could script the schema, and perhaps use bcp to export the data. Neither backup files nor detached databases will work when moving backwards.
|
|
|
|
|
select f.financialTrendSeq
from #tempAllobligor a
left join obligor o on a.obligorSeq = o.obligorSeq
left join obligorFinancialTrend ot on o.obligorSeq = ot.obligorSeq
right outer join financialTrend f on ot.financialTrendSeq = f.financialTrendSeq
where o.quarterDate=ot.quarterdate
and ot.quarterdate = '06/30/2006'
When I join 3 tables, am not getting the result containing all financialTrend f data.
Only, financialTrends in obligorFinancialTrend ot is displayed.
Am I wrong? Can somebody please help me?
rmr
|
|
|
|
|
Hi
What is the easiest option for Exporting ALL of my SQL Server tables into a CSV file (either separate CSV files for each table or one big file with all the table columns and data) ???
I just want to Backup my SQL Server database like we backup MySQL database using phpMyAdmin. Unfortunately, my SQL hosting company does not allow backups for free.
Thanks for help
|
|
|
|
|
i want to copy one database to another using following approach:-
fill dataset1 from adapter1
copy dataset1 to dataset2
update database from dataset2 using adapter2.
But error here is:- Update unable to find TableMapping['Table'] or
DataTable 'Table'.
On Following line:- adapter.Update(ds2)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
LoadFBGrid()
loadDS2()
copyds1to2()
End Sub
Public Sub copyds1to2()
Dim cmdBuilder As FbCommandBuilder = New FbCommandBuilder(adapter2)
ds2 = ds.Copy
adapter.Update(ds2)
End Sub
Public Sub loadDS2()
Try
ds2 = New DataSet("Destination")
con2 = New FbConnection(connectionString2)
con2.Open()
adapter2 = New FbDataAdapter("Select * from Students", con2)
adapter2.Fill(ds2, "Studets")
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
Public Sub LoadFBGrid()
Try
ds = New DataSet("Source")
con = New FbConnection(connectionString)
con.Open()
adapter = New FbDataAdapter("Select * from Students", con)
dt = New DataTable("Students")
adapter.Fill(ds, "Studets") ' copy ds change
adapter.Fill(dt)
DataGrid1.DataSource = dt
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
"You can do any thing you set to your mind" - theGhost_k8
|
|
|
|
|
Hi,I want to display two columns from one table in a Web Form dropdownlist,I've tried something
like this @"SELECT TeamA FROM Under11s.
UNION
SELECT TeamB FROM Under11s;";
But the result set mixes the columns I want them grouped together like
"TeamA"
Player1
Player2
Player3
"TeamB"
Player1
Player2
Player3
SQl Server Or MySql.
Flip Gabes
|
|
|
|
|
You are close make your query look like this;
SELECT TeamA FROM Under11s.
UNION ALL
SELECT TeamB FROM Under11s
This should work.
|
|
|
|
|
SELECT TeamA,1 as SortCol FROM Under11s<br />
UNION<br />
SELECT TeamB,2 as SortCol FROM Under11s<br />
order by SortCol,TeamB
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
how to convert date without 0 in sql
like 1/1/2006 , insted of 01/01/2006
|
|
|
|
|
ypki wrote: how to convert date without 0 in sql
I didn't find any built-in or custom format to cnvert date without leading zero.
well, Have a look to this[^]
wish you all the best.
_____________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
I'm learning Adminitrator SQL server 2000.
I don't known write code or establish timer backup database.
Can you help me.
thanks.
Quynh Nhi
|
|
|
|
|
Look at the database maintenance plan wizard tool in Enterprise manager. Open the local server node in the tree, then open the management folder. right click on the database maintenance plans icon and frome the menu choos new maintenance plan. Enjoy.
In Sql Server Books Online, search for "Database Maintenance plan wizard" for more guidance on using this.
|
|
|
|
|
Hi All,
we are calling a db2 storeProc(deleting data) from the asp.net App.(Asp.Net 2.0 & C#)
i have a situation, sometimes datareader returns saying "Unsuccessful execution caused by deadlock".
Do any one have any idea what might be the reason. i talked to one db person, he said i need to commit the transaction after i call the storeProc.
i haven't used commit from Application till now. Can some one tell me how to commit a transaction from the App?
(one of my friend told, he commits after calling storeProc update from his java App. looking similar to java one.)
|
|
|
|
|
Hi,
Have the following case statement:
select
case
when upper(code) = 'TWASH' then (@t_wash = count(ISNULL(code,0)))
when upper(s5.code) = 'TT-WASH' then (@tt_wash = count(ISNULL(s5.code,0)))
end
from table
for some reason it keep coming back with "Incorrect syntax near '='." that would be the first "when" statement. Can we assign variables in case-statement?
Thanks.
|
|
|
|
|
Hi - solved this using another way. Looks like you cannot assign values in then part of statement.
select @t_wash = case when upper(code) = 'TWASH' then count(ISNULL(code,0))
same for other - you get the basic idea.
Thanks.
|
|
|
|
|
hi,
try the following links, hope you will get some idea to solve the problem.
1 [^]
2 [^]
best regards.
_____________________________
Success is not something to wait for, its something to work for.
|
|
|
|
|
I believe you're missing a select or set before the variable:
VK-Cadec wrote: when upper(code) = 'TWASH' then (set @t_wash = count(ISNULL(code,0)))
|
|
|
|
|
I did try that - it did not help.
|
|
|
|
|
Hello,
I'm trying to use NHibernate, but I have several problems.
First of all, I am not sure that my App.config file works. Here it is:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section
name="nhibernate"
type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089"
/>
</configSections>
<nhibernate>
<add
key="hibernate.connection.provider"
value="NHibernate.Connection.DriverConnectionProvider"
/>
<add
key="hibernate.dialect"
value="NHibernate.Dialect.MsSql2005Dialect"
/>
<add
key="hibernate.connection.driver_class"
value="NHibernate.Driver.SqlClientDriver"
/>
<add
key="hibernate.connection.connection_string"
value="Server=localhost;initial catalog=pruebaNHibernate;Integrated Security=SSPI"
/>
</nhibernate>
</configuration>
I'm trying to connect to a SQL Server 2005 database, but when I run my application, I get this error message:
Unhandled Exception: NHibernate.MappingException: Could not instantiate dialect
class NHibernate.Dialect.MsSql2005Dialect ---> NHibernate.HibernateException: Co
uld not instantiate dialect class NHibernate.Dialect.MsSql2005Dialect ---> Syste
m.TypeLoadException: Could not load type 'NHibernate.Dialect.MsSql2005Dialect, N
Hibernate, Version=1.0.2.0, Culture=neutral, PublicKeyToken=154fdcb44c4484fc', c
heck that type and assembly names are correct
I think that it is cause the value of the key hibernate.dialect isn´t correct. Does anyone know what I have to put there? I found the dialect for almost any type of db except SQL Server 2005.
Thank you for your help!
|
|
|
|
|
Hi
I am running my database on a shared 3rd party server.
Recently, when I try to connect to the DB from my website, Asp.net gives me the following error:
"SQL Server does not exist or access denied."
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
MyCompany.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, String tableName)
.....
....
For instance, this morning the website was working fine, but now suddenly, I am getting the above error. The same problem happened on other days, as well.
Do you think, there is a problem with my code, or is this SQL Server problem?
|
|
|
|
|
Hi hasanali00
Did you try pinging the server when you got the error message in order to confirm that there were no connectivity issues?
Also place code so that yuo can catch the exception where it is being thrown and output the error message. That way you will be more clear on the part of code is throwing the exception and what the error message is saying.
Thanks and Regards,
Aby
|
|
|
|
|
the problem was that the log file was full:
run this command to delete the log:
dump transaction DATABASE_NAME with no_log
|
|
|
|
|
Hello friends,
I'm developing a .NET application using VS2005 and I want to use NHibernate to implement the persistence.
By the moment, in the hibernate web page, there are only two versions, the 1.0.2 version and the 1.2.0 version, which at this moment is only a beta version.
My question is: Are both versions compatible with .NET 2.0 and VS2005? Wich one should I use?
|
|
|
|