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

What is the use of asp.net web api?

0 Answers  

---

Name the method that needs to be invoked on the dataadapter control to fill the generated dataset with data?

0 Answers  

---

True or False: To test a Web service you must create a windows application or Web application to consume this service?

1 Answers  

---

What is data reader in asp.net?

0 Answers  

---

Why do we use asp.net?

0 Answers  

---

What Is ASPNET_WP.exe? What Is The Use Of It? In Which Place Inproc Session Stored ? Explain Session State ?

2 Answers   Phoenix Technologies,

---

If we add a textbox and give the required field validator,and i add two radio buttons 1 is yes another one is No.And i add another one server control button ,if i click the button ,if the radio button Yes is checked the validation control is fired ,if no the validation control is not fired.So what you used to solve this problem.

6 Answers   CTS,

---

How to upload a file using file upload control inside the Update Panel???

2 Answers  

---

Can you edit data in the Repeater control? Which template must you provide, in order to display data in a Repeater control? How can you provide an alternating color scheme in a Repeater control? What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?

0 Answers  

---

Any alternative to avoid name collisions other then Namespaces?

1 Answers  

---

What is state management techniques in asp.net?

0 Answers  

---

When working with ASP.Net server controls, it is important to use the right event handlers to capture the event for the application to function properly. What event would you use to capture the selection of a new item in a DropDownList control? a) The Click event. b) The SelectionChanged event. c) The SelectionIndexChanged event. d) The ChangedSelection event.

4 Answers   Syntax Softtech,

---