Answer / venu

During the process of migrating to SQL Server 2005, many
development organizations will still be forced to support
SQL Server 2000 installations. As a result, a common
requirement is the ability to reverse-migrate: move
databases back from SQL Server 2005 to SQL Server 2000.

Unfortunately, this is not as easy. Backed-up databases from
SQL Server 2005 instances cannot be restored in SQL Server
2000 instances. Nor can detached SQL Server 2005 databases
be reattached to SQL Server 2000.

Because backup/restore and detach/attach are not supported,
the only methods available for moving data from SQL Server
2005 installations to SQL Server 2000 installations are
based on copying data. Data and schemas can be scripted
using a tool such as Red Gate's SQL Packager and scripts can
be applied on the SQL Server 2000 installations. Another
option is to use tools such as DTS or SSIS, both of which
include data copying wizards.

However, copying data and schema is a potentially
troublesome experience. SQL Server 2005 supports many
features that are not present in SQL Server 2000 and can
cause problems during cross-migration. It's important to be
cautious when attempting to develop solutions for both
platforms, and my recommendation is that development should
be done using SQL Server 2000 and the code and data migrated
forward to SQL Server 2005, rather than the other way around.

Answer / neeraj tyagi

Open SQL server managment studio
Connect to required SQL Server Instance
Right click on Database
Select properties
From property window, select Option
There is compatability mode drop down
Change drop down to required version
then save and close property dialog window.

Then take backup of database and restore it to older
version Sql server or attach the same sql serve database
file

Explain the difference between asp & asp.net.

0 Answers  

---

What is application session?

0 Answers  

---

How can we create a website?

0 Answers  

---

under which namespaces connection strings can be defined?

4 Answers  

---

Can u able to get the xml document in crystal report if yes how its possible

2 Answers  

---

There is a login page that has two text boxes with required field validators on it. The page has a login and cancel button. How can we ensure that the click on the cancel button doesnt fire a validation event.

2 Answers   Proteans,

---

Hi! Could any 1 please suggest me a free practice online exam for asp.net exams.. thanks

1 Answers  

---

what is shared assembly?

2 Answers   Microsoft,

---

I have around 200+ controls in a page. Each of the sets of controls are kept in divs and when header div is clicked, only those div controls pertaining to that header div will be displayed. Rest of the divs are kept invisible. When the page loads, all these 200+ controls are loaded simultaneously, that consumes much of the time. What my requirement is I want to get the div1 controls loaded when the page loads and rest of the div controls should be loaded asynchronously. it should not be loaded with page load, so that time for loading the page can be much minimised. Hope u understood my question and pls help me out with a solution asap....

2 Answers  

---

How to Page Execute in asp.net(inside browser)

1 Answers   Satyam, Wipro,

---

Explain the use of duration attribute of @outputcache page directive.

0 Answers  

---

How do you set language in web.cofig ?

3 Answers   Keane India Ltd,

---