Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Transfering object to another database? How-To

5 posts in ,  Windows NTAdministrationUpgrades and ConfigurationGeneral Discussion Backup and Recovery Last posting was on 1998-01-21 18:11:10.0Z
Stefan de Vogelaere Posted on 1997-11-28 07:13:14.0Z
From: stefan.de.vogelaere@telenet.be (Stefan de Vogelaere)
Subject: Transfering object to another database? How-To
Date: Fri, 28 Nov 1997 08:13:14 +0100
Message-ID: <MPG.ee88d73a5bd088f989680@forums.powersoft.com>
Organization: Telenet Operations nv
X-Newsreader: Anawave Gravity v2.00
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.general,sybase.public.sqlserver.nt,sybase.public.sqlserver.upgrades+configuration
Lines: 13
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.administration:3164 sybase.public.sqlserver.backup+recovery:207 sybase.public.sqlserver.general:414 sybase.public.sqlserver.nt:274 sybase.public.sqlserver.upgrades+configuration:175
Article PK: 1060725

Hello,

I am moving from the M$ SQLServer to Sybase SqlServer on NT. One of the
things I am missing from the sybase product, is the ability to transfer
database objects to and from databases.

The only solution I found was to make a backup and restore to different
database, but in the M$ product, I can easily select which objects to
copy to another database.

Does Sybase has additional plugins for the SQLCentral that solves this
problem?

Stefan de Vogelaere


mo Posted on 1998-01-21 18:11:10.0Z
Message-ID: <34C63A3E.556A0E94@sfmny.com>
Date: Wed, 21 Jan 1998 13:11:10 -0500
From: mo <mark@sfmny.com>
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Stefan de Vogelaere <stefan.de.vogelaere@telenet.be>
Subject: Re: Transfering object to another database? How-To
References: <MPG.ee88d73a5bd088f989680@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.general,sybase.public.sqlserver.nt,sybase.public.sqlserver.upgrades+configuration
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.administration:3160 sybase.public.sqlserver.backup+recovery:203 sybase.public.sqlserver.general:410 sybase.public.sqlserver.nt:270 sybase.public.sqlserver.upgrades+configuration:171
Article PK: 1060718

DBArtisan does exactly what you are asking. I know it may be much, but it
has a "migrate" option that will extract the data as well as the table
definition.

regards
Mark LeScoezec
Soros Fund Management

Stefan de Vogelaere wrote:

> Hello,
>
> I am moving from the M$ SQLServer to Sybase SqlServer on NT. One of the
> things I am missing from the sybase product, is the ability to transfer
> database objects to and from databases.
>
> The only solution I found was to make a backup and restore to different
> database, but in the M$ product, I can easily select which objects to
> copy to another database.
>
> Does Sybase has additional plugins for the SQLCentral that solves this
> problem?
>
> Stefan de Vogelaere


Dinyar Posted on 1998-01-08 17:06:43.0Z
Message-ID: <34B507A3.BE3CCF7D@rocketmail.com>
Date: Thu, 08 Jan 1998 22:36:43 +0530
From: Dinyar <dinyar@rocketmail.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: Stefan de Vogelaere <stefan.de.vogelaere@telenet.be>
Subject: Re: Transfering object to another database? How-To
References: <MPG.ee88d73a5bd088f989680@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.general,sybase.public.sqlserver.nt,sybase.public.sqlserver.upgrades+configuration
Lines: 34
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.administration:3161 sybase.public.sqlserver.backup+recovery:204 sybase.public.sqlserver.general:411 sybase.public.sqlserver.nt:271 sybase.public.sqlserver.upgrades+configuration:172
Article PK: 1060721

hi,
when u say object - do u mean only tables?? or
defaults,views,procedures,etc.
if so here is what u can do
for tables
do
select * into target_db.owner.target_table
from source_db.owner.source_table
this will create the table structure for you as well as put the data for
you
this will not recreate the indexes on that table for you-nor will the
defaults if any be carried forward nor any other constraints be bound

for rules,defaults,procedures - use
defncopy
it is an sybase utility to be run from the command prompt
for this u would first have to defncopy the rule or procedure out from the
source database and then defncopy the object in to the target database

if it is all objects you are looking at, then a dump and load is faster
anyway hope this helps
-dinyar

Stefan de Vogelaere wrote:

> Hello,
>
> I am moving from the M$ SQLServer to Sybase SqlServer on NT. One of the
> things I am missing from the sybase product, is the ability to transfer
> database objects to and from databases.
>
> The only solution I found was to make a backup and restore to different
> database, but in the M$ product, I can easily select which objects to
> copy to another database.
>
> Does Sybase has additional plugins for the SQLCentral that solves this
> problem?
>
> Stefan de Vogelaere


Matt Van Rensburg Posted on 1997-12-01 08:50:45.0Z
Message-ID: <34827A65.698E@usa.net>
Date: Mon, 01 Dec 1997 08:50:45 +0000
From: Matt Van Rensburg <mattvan@usa.net>
Reply-To: mattvan@usa.net
Organization: Exabyte
X-Mailer: Mozilla 3.0 (WinNT; I)
MIME-Version: 1.0
Subject: Re: Transfering object to another database? How-To
References: <MPG.ee88d73a5bd088f989680@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.general,sybase.public.sqlserver.nt,sybase.public.sqlserver.upgrades+configuration
Lines: 24
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.administration:3162 sybase.public.sqlserver.backup+recovery:205 sybase.public.sqlserver.general:412 sybase.public.sqlserver.nt:272 sybase.public.sqlserver.upgrades+configuration:173
Article PK: 1060722

Hi Stefan

If you have Powersoft Infomaker or Powerbuilder, look at using the data
pipeline.
If the version of MS SQL Server is 4.2 then you could look at using
DB-Artisan (Embarcadero)
Other option is to bcp the data out and in using character format
bcp testdb..table out textfile -c -Uusername -Ppasswrd -Sservername

HTH
Matt Van Rensburg
mattvan@usa.net

Stefan de Vogelaere wrote:
>
> Hello,
>
> I am moving from the M$ SQLServer to Sybase SqlServer on NT. One of the
> things I am missing from the sybase product, is the ability to transfer
> database objects to and from databases.
>
> The only solution I found was to make a backup and restore to different
> database, but in the M$ product, I can easily select which objects to
> copy to another database.
>
> Does Sybase has additional plugins for the SQLCentral that solves this
> problem?
>
> Stefan de Vogelaere


Mark A. Parsons Posted on 1997-11-28 23:17:53.0Z
Message-ID: <347F5121.1F2D@compuserve.com>
Date: Fri, 28 Nov 1997 18:17:53 -0500
From: "Mark A. Parsons" <Iron_Horse@compuserve.com>
Reply-To: Iron_Horse@compuserve.com
Organization: Iron Horse, Inc.
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: Transfering object to another database? How-To
References: <MPG.ee88d73a5bd088f989680@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.general,sybase.public.sqlserver.nt,sybase.public.sqlserver.upgrades+configuration
Lines: 30
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.administration:3163 sybase.public.sqlserver.backup+recovery:206 sybase.public.sqlserver.general:413 sybase.public.sqlserver.nt:273 sybase.public.sqlserver.upgrades+configuration:174
Article PK: 1060724

Have you tried the 'bcp' (bulk copy) utility? This is an OS level
program which allows you to push and pull data into/out of your
dataserver/database. You should have received a small booklet on OS
utilities (bcp, isql, defncopy, dataserver, backupserver, startserver,
etc.) ... there are lots of options with bcp so play with it some and
see what works best for you.

Of course ... I'm not sure if Sybase's bcp will work against your MS
server ... but if you can get your MS data out in character format with
pre-defined column and row delimiters then you can use bcp to get the
data into Sybase.

Mark Parsons
Iron Horse, Inc.

Stefan de Vogelaere wrote:
>
> Hello,
>
> I am moving from the M$ SQLServer to Sybase SqlServer on NT. One of the
> things I am missing from the sybase product, is the ability to transfer
> database objects to and from databases.
>
> The only solution I found was to make a backup and restore to different
> database, but in the M$ product, I can easily select which objects to
> copy to another database.
>
> Does Sybase has additional plugins for the SQLCentral that solves this
> problem?
>
> Stefan de Vogelaere