migrate to MS SQL2000 from Sybase

Could somebody point me to websites that would help in the migration to MSSQL 2000 from Sybase ASE 12.5? I also need replication documents also. We have 7 SQL servers that all replicate and we are thinking about moving to MS because of some benifits for out inhouse program.

thanks for all help..Check out the following article - it is based on sql server 7:

article (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlsm/html/sybase2sql.asp)|||thanks..

Migrate MSDE data to SQL 2000

I have local copy of MSDE 2000 on an XP workstation.
My program has already been reconfigured to point to a remote (from the XP
viewpoint) SQL 2000 server. As such, it has created the 2 databases that it
uses and is already populating those databases with data.
The question is, how do I get the "old" data from MSDE on the XP box into
the "new" databases on the remote SQL server?
When I try to use DTS and choosing the default of OLE Provider for SQL for
the source, I can't connect to the XP MSDE, which is using SQL Auth. I know
I am using the correct "sa" password for the MSDE database.
Robert
You have a few options: DTS, Detatch/Reattach, or Backup/Restore.
I prefer to backup on the old server, copy the backup file to the new
server, and restore it on the new server. This is fairly easy to do. Just
make sure you create the users from the old server on the new server first,
and then run sp_change_users_login to eliminate orphaned users after you do
the restore.
"Robert Gandrud" wrote:

> I have local copy of MSDE 2000 on an XP workstation.
> My program has already been reconfigured to point to a remote (from the XP
> viewpoint) SQL 2000 server. As such, it has created the 2 databases that it
> uses and is already populating those databases with data.
> The question is, how do I get the "old" data from MSDE on the XP box into
> the "new" databases on the remote SQL server?
> When I try to use DTS and choosing the default of OLE Provider for SQL for
> the source, I can't connect to the XP MSDE, which is using SQL Auth. I know
> I am using the correct "sa" password for the MSDE database.
> Robert
|||As far as I know, the only user is the "sa" user in the old MSDE database.
What then?
"Dan" wrote:
[vbcol=seagreen]
> You have a few options: DTS, Detatch/Reattach, or Backup/Restore.
> I prefer to backup on the old server, copy the backup file to the new
> server, and restore it on the new server. This is fairly easy to do. Just
> make sure you create the users from the old server on the new server first,
> and then run sp_change_users_login to eliminate orphaned users after you do
> the restore.
> "Robert Gandrud" wrote:
|||hi Robert,
Robert Gandrud wrote:
> I have local copy of MSDE 2000 on an XP workstation.
> My program has already been reconfigured to point to a remote (from
> the XP viewpoint) SQL 2000 server. As such, it has created the 2
> databases that it uses and is already populating those databases with
> data.
> The question is, how do I get the "old" data from MSDE on the XP box
> into the "new" databases on the remote SQL server?
> When I try to use DTS and choosing the default of OLE Provider for
> SQL for the source, I can't connect to the XP MSDE, which is using
> SQL Auth. I know I am using the correct "sa" password for the MSDE
> database.
>
MSDE installs by default disabling network protocols...in order to them
after installation you have to run the
Server Network Utility (svrnetcn.exe) and enabling the desired
protocol(s)...
Win XP Windows Firewall could be an issue too and please have a look at
http://support.microsoft.com/kb/841251/en-us in order to enable remote
connectivity...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Migrate Login Control to SQL

Hi,

I was able to create an MSSQL database with the ASPNETDB.MDF file. But how do I get the Login Control to point to the MSSQL rather than the \App_Data\ASPNETDB.MDF file?

Hi

you need to see This

Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005

|||

check out below solved thread..

Login control And DB - ASP.NET Forums

you might need to include the tables and stored procedure which requires for login control into your DB...

hope it helps./.

Mid Data Point

I have a database table with 464473 records in it. The file is an opt-in
list. Each record has a unique id number which are not sequential. I need
to split the file in half or find the id number of the mid-point in the
file. At some point I might need to split the file 3 or 5 ways.
HELP. How do i find the mid-point...
I thought that "select top 232237 order by id desc" would show me the id
number. It does not. Any other techniques.William,
If the ID is not sequential and there are possibly gaps in the sequencing,
finding the mid-way point is virtually useless if you are truly trying to
access 50% of the 464,473 row table.
Consider using SET ROWCOUNT:
set rowcount 232236
insert into new_table select * from current_table
delete from current_table
set rowcount 0
"William" wrote:

> I have a database table with 464473 records in it. The file is an opt-in
> list. Each record has a unique id number which are not sequential. I nee
d
> to split the file in half or find the id number of the mid-point in the
> file. At some point I might need to split the file 3 or 5 ways.
> HELP. How do i find the mid-point...
> I thought that "select top 232237 order by id desc" would show me the id
> number. It does not. Any other techniques.
>
>|||I think some clarfications would be useful.
First of all a table isn't a file.
Secondly, what do you mean by "split the file [table?] in half"? That seems
like something quite different from "find the id number of the mid-point".
It would help if you would state your actual goal rather than hinting at
different ideas. If we know what you are trying to achieve we may be able to
suggest better alternatives.
To find the mid-point ID:
SELECT MIN(id) AS mid_point
FROM
(SELECT TOP 232237 id
FROM YourTable
ORDER BY id) AS T
However, I suspect you may be looking for something slightly different, such
as paging or sampling, to which there are likely to be different and maybe
better solutions.
David Portas
SQL Server MVP
--

Microsoft.Data.Odbc on 64-Bit Server

Hi!

Today we installed our ASP.NET Application on a 64-bit server for the first time. We got the error'Unable to find entry point named 'InterlockedIncrement' in DLL 'kernel32.dll''.

This error comes when we make a database query using Microsoft.Data.Odbc. I think it does not run on 64-bit machines.

Does anybody know something about this?

KaaN

I don't know why you need it with ODBC datasource but the link below Microsoft explains the reason for you error. Hope this helps.

(The variable pointed to by the Addend parameter must be aligned on a 32-bit boundary; otherwise, this function will behave unpredictably on multiprocessor x86 systems and any non-x86 systems.)

http://msdn2.microsoft.com/en-us/library/ms683614.aspx

|||

Thanks for your answer.

Actually I don't need this xxIncrement method, I only need the .Net Odbc Provider and probably this provider is using this function. Now I have to refactor my code to native providers or find another .Net ODBC Provider.