|
I am a developer and I wanted to ensure that I have a full MS SQL Server at my disposal if need be.
Can I also install MS SQL Express 2008 on the same box, so I can do small dev projects using SQLExpress instead of MS SQL Server?
Started by James McFarland on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
There is no development diference between sql....
However you can also install up to 16 instances of the full sql server (standard) on the same box.
Yes you can, sql express will install as a named instance.
But they will work just fine.
|
|
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):
We used to use....
Thought of using virtualisation? I had to deal to a SQL2000 box .
Level is the SQL 2000 databased set to? If it is set to SQL 2005 compatibility level then no, you won't be able to restore it to a SQL 2000 server.
|
|
I'm looking for a Visual Studio 2008 add-in / plug-in that can provide Intellisense and flexible code formatting for T-SQL for use with SQL Server 2008. It needs to work with Team System Data Edition ("data dude").
I am familiar with the Red Gate tools...
Started by RickNZ on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You could also download the trial....
Edit: For formatting, you can also use SSMS Tools Pack but again it's SSMS only.. .
If you can use the SQL client tools, "Intellisense" is included in Management Studio for SQL Server 2008 already.
|
Ask your Facebook Friends
|
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]', 'varchar(256)....
|
|
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):
You can compress data in SQL 2008 which can have drasticMoving a single database....
There are new tools and options available in SQL Server 2008 that you MIGHT be able to leverage if your application is big / complicated.
|
|
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 .
|
|
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):
In the ....
You let the TFS install handle the SSRS and NOT configure SSRS and see how that goes .
Try to reinstall SQL Server 2008When you install SQL Server DO NOT configure SSRS.
This was one the errors I was experiencing.
Configuration.
|
|
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 Server the database ....
SQL Server 2008 database backups are not backward compatible with SQL Server 2005.
No, not directly.
|
|
I have a typical dev scenario: I have a SQL 2008 database that I want to copy every so often to my local instance of 2008 Express so that I can do dev, make changes, etc. to the local copy. I have some constraints though: the source db is part of a live...
Started by DaveBurns on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table,....
Try SQL Dumper .
|
|
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
SQL....
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.
|
