Hi! We are trying to convert the database from Sybase 11.0.3 to MS SQL 6.5. Is there any quick/easy way to do the conversion without using bcp? any third party software we may use to make the conversion easier? Thank you very much!
View 2 Replieshi,
i tried the document below pertaining to linking sybase 12.5 to sqlserver 2000 and sqlserver 2005
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=311875&SiteID=17
http://www.sybase.com/content/1029118/1029118.doc
but when our company upgrade the sybase to 15.x i can't find the oledb configuration stated on the document.
so i can't linked the sybase 15.x now to sqlserver 2005. can somebody help me.!!!please...
where i can find the oledb configuration in sybase 15.xx..
tnx..
At first my office had blackout and sybase server unable to shutdown properly.
I have 4 database in that sybase server on unix AIX5 and only 3 database up and can be access after restart except for 1 database(mydb) show message recovery failed:
00:00000:00001:2008/02/02 21:08:30.73 server Recovering database 'mydb'.
00:00000:00001:2008/02/02 21:08:30.76 server Starting diagnostics for read fail
ure:
00:00000:00001:2008/02/02 21:08:30.77 server Device Information:
Device number = 8
Phyname = /data/my_db/mydbdatadev
00:00000:00001:2008/02/02 21:08:30.77 server Buffer Information:
Buf addr = 0x5068965c, Mass addr = 0x5068965c
Buf pageno = 114268, Mass pageno = 114268, dbid
= 6
00:00000:00001:2008/02/02 21:08:30.77 server
Buf virtpg = 134331998, Mass virtpg = 134331998
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00001:2008/02/02 21:08:30.77 server Page Information from first read a
ttempt: Page read from disk ppageno = 114268, pobjid = 1680005985, pindid = 255
pnextpg = 0, pprevpg = 0 plevel = 241, pstat = 0x4030 pts_hi = 0, pts_lo = 52098
23
00:00000:00001:2008/02/02 21:08:30.77 server Page Information from second read
attempt: Page read from disk ppageno = 114268, pobjid = 1680005985, pindid = 255
pnextpg = 0, pprevpg = 0 plevel = 241, pstat = 0x4030 pts_hi = 0, pts_lo = 5209
823
00:00000:00001:2008/02/02 21:08:30.77 server SDES Information:
dbid = 6, objid = 8, scur.pageid = 114268
sstat = 0x0, sstat2 = 0x4000000
suid = 1, cacheid = 0
00:00000:00001:2008/02/02 21:08:30.77 server PSS Information:
pstat = 0x1000, pcurdb = 6, pspid = 1
p2stat = 0x110, p3stat = 0x1000081e
plasterror = 0, preverror = 0, pattention = 0
00:00000:00001:2008/02/02 21:08:30.77 server End diagnostics for read failure:
00:00000:00001:2008/02/02 21:08:30.77 server Run the DBCC command 'dbcc tableal
loc' for both the objects 8, 1680005985
00:00000:00001:2008/02/02 21:08:30.78 server Error: 605, Severity: 21, State: 1
00:00000:00001:2008/02/02 21:08:30.78 server An attempt was made to fetch logic
al page '114268' in database 'mydb' from cache 'default data cache'. Page belo
ngs to object with id '1680005985', not to object 'syslogs'.
00:00000:00001:2008/02/02 21:08:30.80 server Error: 3414, Severity: 21, State:
1
00:00000:00001:2008/02/02 21:08:30.80 server Database 'mydb' (dbid 6): Recove
ry failed. Check the SQL Server errorlog for further information as to the cause
then i used sql to dbcc mydb and this message come out:
server message:number 921,severity 14
server 'mydb_prod',line1:
database 'mydb' has not been recovered yet - please wait and try again
tq for reply, any added information please let me know.
please help.
Hi, i already create a connection to sybase(ASA) with odbc from ssis (from "data sources" section). but when i try to make data flow source it cann't. so i try to make a connection using "data source views" but when the process comes to end, it becomes error. from my analysis, the Sybase db cannot accept sql command with "[]", because in the fase "data source views" i have to select one or more table, and the default microsoft is using "[]", like: select * from [dbo].[customer], but sybase db cannot handle this. does anyone have the solution for this? Thanks.
Sincerely
Yugicm
Can anyone help me with this scenario!!!!
I have a sybase database and a sqlserver 2000 database.
I want to insert data into sybase database table thru sql-server 2000 using distributed queries
When i execute the following the transaction
Create procedure myCurrentDataBaseProcedure
as
begin
begin tran
insert into mytable values(1)
if @@error <>0
begin
rollback transaction
return
end
insert into sybasedatabaseserver.databasename.dbo.tablename values(1)
if @@error <>0
begin
rollback transaction
return
end
commit transaction
end
The procedure is created in sql server database
trying to execute this procedure..shows error
The first part of the procedure is executed.
But the error is here
insert into sybasedatabaseserver.databasename.dbo.tablename values(1)
The data is succesfully inserted in the local database
I am unable to insert data into the remote database
Can anyone suggest me wht shd i do in this scenario
Are there any drivers to be loaded to commit this transactions
Pl.Help
Hello,
I took our SYBASE DDL and created the tables on an SQL Server Express datbase on a PC and then downloaded our data from UNIIX using the WinSCP utility and BULK Inserted the data into the SQL Server database and everything uploaded fine apparently, but when we go to use the data we are getting some data differences.
Do you know of any data conversion issues that may be coming into play here maybe?
Thanks very much!
BobK
I would like to start using SQL, how would I convert my data in MS Access over to an SQL Server Database?
View 2 Replies View RelatedHo do I convert Oracle 8 database into SQL server 7.0 database ? Is it possible ? Please let me know at skbhaduri@rediffmail.com
View 1 Replies View RelatedI remember having "converted" a mdb (Access ) DB into SQL Server 7, some motnhs ago.
Now I have installed SQL Express, and would like to do the same (just
converting the tables, so I don't have to create them by hand again).
But I am unable to find any menu option to do that in SSMSEE. Is it
feasible?
thanks
The website i'm building is using an access97 database. Actually the database isn't very big but i hope it will become. So i would like to convert it to SQL 7.0 which seems to be more powerfull. Is there a software which can do it automatically? What are the modifications needed by ODBC ?
Thanks !
hi all,
How to convert a database from MS Access to MS SQL, is there some tool like that?
We are in the process of converting an existing database to Unicode. Has anyone encountered any problems in doing this?
View 1 Replies View RelatedHi,
Please i would like to know if msde or SQL Express need a license to the customer. If no does anyone know how to convert sql database to msde or SQl express?
I have a sql server database and i need to convert to Access, how can i do this using sql server?
View 4 Replies View RelatedHello ,
I'd like to convert the database + sp + tables + data into .sql file?
How
Hello sir,
I send you this message to told hwo can i do to convert one database which is in Access97 to SQL Server6.5.
I must create a interface in the web which is able to interrogate the database that the reason why i want to do that.
Thanks for any help in advance.
We have an application with database with Sortid 50 (binary) in SQL 6.5
We're planning to upgrade to SQL2000 and use the default Sortid 52.
Can we change it when using the SQL2000 upgrade wizard ?
I tried and got a warning msg
"code page / sort order configuration between import and export SQl server do not match or not supported. A successful converison cannot be guarenteed"
Or we should bcp the database out from the old SQL 6.5(soritd 50) and then
bcp in another new SQL 6.5(with sortid 52),then rebuild all schema,
then migrate this new SQL 6.5 to 2000 with migration wizard as normal ?
Or we do the migration first, then use copy database wizard to copy it
into another SQL2000 database with different sortid, i.e 52 ?
(As I recall SQL2000 support databases with different character set and
sorting order )
Anyone has any thoughts ?any pros and cons for various ways of converting it, Thanks.
Anthony
is it possible to convert an Access database to SQL Server 2005 or 2000?
View 3 Replies View RelatedHi
I want to convert the access2000 database to SQL server 2000.
I am able to convert the tables but unable to convert the query as view in SQL server 2000.
please quide how to convert the query as view in sql server 2000.
thanks
asm
Hi there.
How can i convert a Ms Access Database file (.mdb) to an SQL Server 2005 Database ????
is there any tools ?? or what ever can help me .
Thank you.
I have a database has the following linklist structure. A, B, B1, B2 and B3 are records.
A is a group and the others are group members
***************************************
A.PointertoB
B.ForwardPointertoB1
B1.ForwardPointertoB2
B2.ForwardPointertoB3
B3.end
***************************************
I want to convert them to relational database structure so I need to find following pointers
B.PointertoA
B1.PointertoA
B2.PointertoA
Can I use sql to find the pointers? Thanks in advance.
Hi,
Can anybody tell me that how to convert database from sql server 2005 to sql server 2000. I tried with generated script and in that i selected the option for sql server 2000 but still while trying to run that script it is throwing an error. the error is:
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
plz help.
Thanks,
Poonam
Hi
I need to convert on existing Access database to SQL Server database. If I convert though sql DataTransformation, it taking only data from the Acccess Database not all the constraints like Primary Key, Default Value, Relations .........
Any one can give the solution to this
----->nRk
I have some question about SQLServer Expresss.
1. I want attach a SQLServer Expresss database to sqlserver2005.is it possible? How?
2. Can I get script by SQLServer Expresss?
3. And my important question is: How can I convert a SQLServer Expresss database to sqlserver2000?
Please help me.
Thanks in advance.
Hi,
I need to convert all datetime columns to smalldatetime in the whole database. I really don't want to do it by hand and It would probably take me a whole day to figure out how to write such a procedure. If someone could help me out that would be great.
My database is divided into schemas just like AdventureWorks.
Also, no need to worry about date conversion, value could be set to current date.
Thanks
Hi,
I am working on my database design for a webapplication.
Every table is setup with an id. I have used an identity int.
Now I was looking at uniqueidentifier, newid() and was wondering if this was a better solution.
I have created several relations between my tables etc
Is it possible to convert these identity int's to uniqueidentifiers and use newid() to declare the id ?
Greetings
Hi,How could i do to convert data from CSV files to tables on database in SQL server 2000 ? Please show me !Thank very muchdvl_lang
View 3 Replies View RelatedHi;
I have a database in sql server 2000 and i want to convert it to sql express 2005, so please tell me how I can do this. Thanks
Adnan
Can anyone help me on this!I've got more than a 1000 records in a SQL server database.The problem is that the the date field is set to varchar, and that gives a lot of trouble. (for example by sorting a table, it's a mess)How can i make sure that i will have a table with the date field set to datettime en that those 1000 records still will be in it. thanks in advance!
View 1 Replies View RelatedHello,
Can anyone tell me, how to convert an rtf string to text string using a function in SQL Server? I got a table in SQL Server database with field datatype text(16), which holds an rtf. I've to extract it as a text using a function.
thank you,
Hey @ all,I have a question:It is possible to convert an existing SQL Server 2000 Database to SQL Server2005?best wishes!
View 1 Replies View Related1) What is the current version of SQL Server Express?
2) HOw much SQL Server Express costs (figure about 500 branch servers)
3)Are there any Tools from Microsoft to convert Access 97 directly to SQL Server express, and how much do they cost?
4)Server Hardware requirements to run SQL Server Express - disk size, memory size, security settings, pre-requisite, service needed.
5)Maximum capacity / capabilities of SQL Server Express-max # of simultaneous users,tables,rows,database size.
6)Any installation instruction for SQL Server Express.
Is there any way to convert an Access or SQL server 2005 database to SQL server 2005 compact edition database??
Thank you very much!!