Re: Migrating SQLServer DBs to Sybase
From: Mark Rae (mark_at_mark-N-O-S-P-A-M-rae.co.uk)
Date: 03/11/05
- Next message: Serg: "Is it possible to set CommandTimeout at connection level?"
- Previous message: Dumitru Sbenghe: "Re: Migrating SQLServer DBs to Sybase"
- In reply to: iva lopes via .NET 247: "Migrating SQLServer DBs to Sybase"
- Next in thread: gabriel: "Re: Migrating SQLServer DBs to Sybase"
- Reply: gabriel: "Re: Migrating SQLServer DBs to Sybase"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Mar 2005 09:52:56 -0000
"iva lopes via .NET 247" <anonymous@dotnet247.com> wrote in message
news:OZqg%23$gJFHA.2728@TK2MSFTNGP09.phx.gbl...
> Hi there, i have to move a bunch of SQLServer DBs onto SYbase.
As has been mentioned perviously, SQL Server and Sybase are about as similar
as two RDBMS could be so, chances are, you'll be fine. You will almost
certainly be able to migrate the databases using a combination of SQL
Server-generated scripts to create the structure in Sybase, and SQL Server
DTS to migrate the data into it.
>My VB.NEt code uses all the functions in System.Data.SqlClient... do i need
>to change all my code
>now for sybase? And do I have to use ODBC? My expeerience here is limited!
You will need to change some code certainly, but how much largely depends on
how you've structured your app. If you've created a data abstraction class
which the rest of your app uses to communicate with SQL Server, then that's
all you'll need to change. However, if you've written direct database
connectivity in the code behind each of your aspx pages, then you will
obviously have a bit more work to do :-)
You can use ODBC if you want, but I would strongly suggest you use the
native Sybase .NET provider e.g.
using Sybase.Data.AseClient;
string strConnectionString = "Data
Source='myASEserver';Port=5000;Database='myDBname';UID='username';PWD='password';"
AseConnection objCon = new AseConnection();
objCon.ConnectionString = strConnectionString;
objCon.Open();
or
Dim strConnectionString As String = "Data
Source='myASEserver';Port=5000;Database='myDBname';UID='username';PWD='password';"
Imports System.Data.AseClient
Dim objCon As AseConnection = New AseConnection()
obCon.ConnectionString = strConnectionString
objCon.Open()
- Next message: Serg: "Is it possible to set CommandTimeout at connection level?"
- Previous message: Dumitru Sbenghe: "Re: Migrating SQLServer DBs to Sybase"
- In reply to: iva lopes via .NET 247: "Migrating SQLServer DBs to Sybase"
- Next in thread: gabriel: "Re: Migrating SQLServer DBs to Sybase"
- Reply: gabriel: "Re: Migrating SQLServer DBs to Sybase"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
