Discontinued Features ???

[Dave Holtz]

Are there any features in 6.5 that have been discontinued in 7.0? I read in Technet that "future versions of SQL Server might not support some statements where the same functionality can be achieved using other means." Technet gave the following examples:

- Device Mirroring
- Outer Join Syntax
- SELECT FOR BROWSE
- Handling of NULLs

I`m curious how our applications will be effected. Will we be making a lot of code changes when we migrate to 7.0?

Thanks, Dave Holtz
First Penn-Pacific

[Anthony Kenitzki]

Add the `dump` and `load` commands to your list. They are supported but officially replaced with the `backup` and `restore` commands officially.

BTW: I dont believe there is a way in SQL 7.0 to perform a `dump table`.

With the new performance enhancements and (supposed) stability, I`m more than happy to overlook a few features that I rarely use in 6.5 that are missing in 7.0 (so long as it works).


Anthony Kenitzki

On 9/14/98 10:57:18 AM, Dave Holtz wrote:
> Are there any features in 6.5 that have been discontinued in 7.0? I read
> in Technet that "future versions of SQL Server might not support some
> statements where the same functionality can be achieved using other means."
> Technet gave the following examples:

- Device Mirroring
- Outer Join
> Syntax
- SELECT FOR BROWSE
- Handling of NULLs

I`m curious how our
> applications will be effected. Will we be making a lot of code changes
> when we migrate to 7.0?

Thanks, Dave Holtz
First Penn-Pacific

[Dave Holtz]

I`m more concerned about the Join syntax. If the old syntax is still supported in 7.0, conversion shouldn`t be that bad for us. Knock on Wood!!!

Thanks, Dave

On 9/14/98 12:58:17 PM, Anthony Kenitzki wrote:
>
Add the `dump` and `load` commands to your list. They are supported but
> officially replaced with the `backup` and `restore` commands
> officially.

BTW: I dont believe there is a way in SQL 7.0 to perform a
> `dump table`.

With the new performance enhancements and (supposed)
> stability, I`m more than happy to overlook a few features that I rarely use
> in 6.5 that are missing in 7.0 (so long as it works).


Anthony
> Kenitzki

On 9/14/98 10:57:18 AM, Dave Holtz wrote:
> Are there any
> features in 6.5 that have been discontinued in 7.0? I read
> in Technet
> that "future versions of SQL Server might not support some
> statements
> where the same functionality can be achieved using other means."
>
> Technet gave the following examples:

- Device Mirroring
- Outer Join
>
> Syntax
- SELECT FOR BROWSE
- Handling of NULLs

I`m curious how our
>
> applications will be effected. Will we be making a lot of code changes
>
> when we migrate to 7.0?

Thanks, Dave Holtz
First
> Penn-Pacific

[Hal Berenson]

On 9/15/98 8:08:05 AM, Dave Holtz wrote:
> I`m more concerned about the Join syntax. If the old syntax is still
> supported in 7.0, conversion shouldn`t be that bad for us. Knock on
> Wood!!!

The old join syntax is still supported (though the developers wish it didn`t need to be since it has a fairly ambiguous definition). You are encouraged to move to the new syntax.

The same is true for the other items you mentioned. You should not need to recode, but you could be using some features (or relying on some behaviors) which are not the long term direction.

As for dump table...the replacement is to assign the table to its own file or filegroup and then use the ability to backup/restore just that file/filegroup.

Hal

All opinions expressed above are my own