|
Hi,
I'm in the process of migrating development databases from an old (soon to be decommissioned) database server to a VMWare-hosted virtual machine running Windows 2008 x64.
The old server runs SQL Server 2000, SQL Server 2005 and SQL Server 2008. I ...
Started by ArnieZ on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at serverfault):
Now we use the Microsoft SQL Server machine it would need to....
We used to use Backup and Restore functions.
Thought of using virtualisation? I had to deal to a SQL2000 box .
Won't be able to restore it to a SQL 2000 server.
|
|
Hi.... Please tell me the differences between sql server 2005 and sql server 2008
Started by sevugarajan on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
In sql server 2008 you do:
declare @DbName varchar(256)=@data.value('(/EVENT_INSTANCE/DatabaseName)[1('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)')
Sql server 2008 has the merge statement'
2005 set]',....
|
|
Hi,
Are there any performance benefits of using SQL Server 2008 over SQL Server 2005?
Started by Anonymous Cow on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
However if your application is ....
There are new tools and options available in SQL Server 2008 that you MIGHT be able to leverageMoving a single database from SQL Server 2005-2008 will not notice a difference really.
|
Ask your Facebook Friends
|
Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2005?
I need to work on an sample application for which database backup is in sql server 2008. But I'll not be able to install 2008. So is it possible to restore...
Started by AvidProgrammer on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
However, with SQL Server 2008 Management Studio, you can script data and schemas in SQL....
SQL Server 2008 database backups are not backward compatible with SQL Server 2005.
No, not directly.
|
|
Duplicate Advantages of MS SQL Server 2008 over MS SQL Server 2005?
What are the major differences between Sql Server 2005 and Sql Server 2008?
How could I convince my organization to invest in Sql Server 2008?
For me, one major aspect that I see is that...
Started by yoitsfrancis on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Cheers....
These eliminate the need for red sqling
It covers new features of SQL Server 2008 from the perspective of management, developers and a few other aspects.
SQL Server 2008 allows for table valued parameters.
|
|
Hi,
I'm trying to install Team Foundation Server using 2 machines:
Machine1: OS: Windows 2008 Server Installed applications: SQL Server 2008 SQL Server 2008 Analysis Services
Machine2: OS: Windows 2008 Server Installed applications: SQL Server 2008 Reporting...
Started by Pedro on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
You let the TFS install handle the SSRS and NOT configure SSRS and see how that ... .
Try to reinstall SQL Server 2008When you install SQL Server DO NOT configure SSRS.
This was one the errors I was experiencing.
Configuration.
|
|
Are there any issues backing up a database from SQL Server 2008, and then importing it into SQL Server 2005? I had upgraded to SQL Server 2008, but 2008 seems to be too problematic so now I want to downgrade. Are there any problems in doing this?
Started by gersh on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Easiest way to do it is to use the "Generate SQL Server Scripts" wizard to create a script (including schema and data) that you to the original issue....
Well, you won't be able to restore a 2008 backup to a SQL 2005 server.
|
|
I created a login with SQL authentication credential in SQL Server 2008. But, I am not able to login using that credential.
We followed the same steps in SQL Server 2005 and working without any problem.
What could be the problem?
Thanks, P.Gopalakrishnan...
Started by gopal on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
From ....
Have you confirmed that you are logging into the correct instance of sql server on the machine that you created the login for?
Have you checked that SQL Server Authentication is enabled? It is disabled by default.
|
|
Hello all you wonderfully helpful people,
What is the alternative to EnumParameters in SQL Server 2008? This MSDN article mentions that this method is going away, so what should be used instead?
http://msdn.microsoft.com/en-us/library/ms133474%28SQL.9...
Started by Paul on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Use SMO instead:....
Http://msdn.microsoft.com/en-us/library/ms162209%28SQL.90%29.aspx
Not only this method, but everything DMO that is deprecated since 2005 .
Swap from using DMO to SMO, the object model exposes the stored procedure parameter collection .
|
|
I have an existing application that transfers a Database from a source server to a target server via SMO "Transfer". We transfer only the data.
Both SQL-Servers are 2005.
Now we upgrade the target server to SQL-Server 2008. Will the transfer via SMO still...
Started by Malcolm Frexner on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
It was not necessary to native SQLServer 2008 mode..
They have slightly different names.
I had to use the SMO-dll of SQL Server 2008.
|
