Re: How to Reattached database in SQL 2000 server after upgrading with SQL 2005 - Database Discussion Boards

xbiplav28-Mar-09 16:20

28-Mar-09 16:20

Is there anyway that we can extract or backup data from a sql server table to anything, and later importing them?

Is there any popular tool or technique to do so?

Re: Backing up data from a Sql Server Table

Reza Raad28-Mar-09 21:53

Reza Raad

28-Mar-09 21:53

you can generate sql script for you table structure and also data which exist in your table.
if you have sql server 2008 follow this instructions:
Open Sql Server Management Studio
Right Click on your database
go to : Tasks
then: generate scripts...
wizard will shown then

try this wizard you can find it very simple

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

Re: Backing up data from a Sql Server Table

xbiplav29-Mar-09 6:59

xbiplav

29-Mar-09 6:59

I have to do that programatically and i am using Vb.Net or may be C# will do.

Re: Backing up data from a Sql Server Table

Reza Raad29-Mar-09 10:34

Reza Raad

29-Mar-09 10:34

You can create your own SSIS package and then run it with your .NET application

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

Re: Backing up data from a Sql Server Table

Lambin6-Apr-09 18:59

Lambin

6-Apr-09 18:59

Hello ,

You can use SMO ( SQL Server Management Objects ) to do that but it might be complicated for a beginner ( in SMO )

How to Reattached database in SQL 2000 server after upgrading with SQL 2005

azad yadav28-Mar-09 3:02

azad yadav

28-Mar-09 3:02

Dear Friends,
I attached sql 2000 database in sql 2005 server and deattaching from 2005 again try to attached with sql 2000 then give error (could not find sysindexes for database id 9 Run dbcc chack table on sysindexes)
Please help me

Thanks and Regards
Azad Yadav

Re: How to Reattached database in SQL 2000 server after upgrading with SQL 2005

Mycroft Holmes28-Mar-09 16:00

Mycroft Holmes

28-Mar-09 16:00

I will be astonished if you can do this. The idea that you can take a 05 db back to 2000 seems unlikely in the extreme.

Never underestimate the power of human stupidity
RAH

Re: How to Reattached database in SQL 2000 server after upgrading with SQL 2005

Reza Raad28-Mar-09 23:25

Reza Raad

28-Mar-09 23:25

use Integration Service and transfer your database from 2005 to 2000.because you can not restore 2005 on 2000 on usual ways

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

Re: How to Reattached database in SQL 2000 server after upgrading with SQL 2005

Lambin6-Apr-09 18:56

Lambin

6-Apr-09 18:56

Hello,

If you have modified the structure of your database or introduced features specific to SQL Server 2005 like PIVOT in a view or stored procedure, bad luck.
Try to reattach your database to your SQL Server 2005 , check if the compatibility level of your database is always 80 ( SQL Server 2000 ). If yes, bad luck, if it is 90, try to modify it to 80.
Detach it properly and try to reattach it to your SQL Server 2000. You have a little hope of success ( except if you have introduced features specific to 2005 )

Recoverying deleted record from SQL server table

Saleem Tahiri28-Mar-09 0:34

Saleem Tahiri

28-Mar-09 0:34

I have deleted some of the records from my SQL server Database table

How can I recover those records?
Rose | [Rose]

Re: Recoverying deleted record from SQL server table

scottgp28-Mar-09 1:42

scottgp

28-Mar-09 1:42

By restoring from a backup? You could restore the backup to a new database and copy the rows over.
Scott

Sql server

anup keshari27-Mar-09 21:42

anup keshari

27-Mar-09 21:42

how i can create pyramid in sql server 2005.

Re: Sql server

Blue_Boy28-Mar-09 0:27

Blue_Boy

28-Mar-09 0:27

Which pyramid you want to create by SQL Server 2005?!

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: Sql server

anup keshari28-Mar-09 0:35

anup keshari

28-Mar-09 0:35

1 2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9

Re: Sql server

Blue_Boy28-Mar-09 0:47

Blue_Boy

28-Mar-09 0:47

Here it is:

DECLARE  @i AS INT<br />
SET @i=0<br />
<br />
DECLARE  @j AS INT<br />
SET @j=1<br />
<br />
DECLARE @kosova AS VARCHAR(255)<br />
SET @kosova=''<br />
<br />
WHILE(@i<10)<br />
BEGIN<br />
	WHILE(@j<@i)<br />
	BEGIN<br />
		SET @kosova=@kosova+CAST(@i AS VARCHAR(10))<br />
		<br />
		SET @j=@j+1	<br />
	END<br />
	PRINT @kosova<br />
	set @kosova=''<br />
	SET @j=0<br />
	SET @i=@i+1<br />
END

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: Sql server

anup keshari28-Mar-09 1:04

anup keshari

28-Mar-09 1:04

1 2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9

Re: Sql server

Blue_Boy28-Mar-09 1:08

Blue_Boy

28-Mar-09 1:08

And your question is?
I don't understand what you mean by this last pyramid!

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: Sql server

anup keshari28-Mar-09 1:17

anup keshari

28-Mar-09 1:17

1 2 2
3 3 3
4 4 4 4
5 5 5 5 5
6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9

here the 1 printed after 8 spaces 1 times
here 2 printed after 7 spaces 2 times .
and so on .

Re: Sql server

Eddy Vluggen29-Mar-09 1:33

Eddy Vluggen

29-Mar-09 1:33

You're cheating! You can't get a decent pyramid by adding a number, you'll have to add two numbers to get a decent pyramid Laugh | :laugh:

I are troll Smile | :)

Re: Sql server

anup keshari29-Mar-09 23:55

anup keshari

29-Mar-09 23:55

i think u should try it ,
its possible in sqlserver .
so dont laugh ,but try it.

Re: Sql server

Eddy Vluggen30-Mar-09 2:36

Eddy Vluggen

30-Mar-09 2:36

I enjoy making and solving these kind of riddles, it's a fun way of learning Smile | :)

I'm still @work, but I'll give it a try to build my pyramid when I'm home Thumbs Up | :thumbsup:

I are troll Smile | :)

Re: Sql server

Eddy Vluggen30-Mar-09 6:15

Eddy Vluggen

30-Mar-09 6:15

Result

         0
        111
       22222
      3333333
     444444444
    55555555555
   6666666666666
  777777777777777
 88888888888888888
9999999999999999999

Here's my homework;

DECLARE @R AS INT
SET @R = 0
DECLARE @FILL AS INT
SET @FILL = 10
DECLARE @NUMCNT AS INT
SET @NUMCNT = 1

DECLARE @ROWSTR AS VARCHAR(100)
DECLARE @I AS INT

WHILE (@R < 10)
BEGIN
      SET @ROWSTR = ''

      SET @I = 0
      WHILE (@I < @FILL)
      BEGIN
            SET @ROWSTR = @ROWSTR + ' '
            SET @I = @I + 1
      END

      SET @I = 0
      WHILE (@I < @NUMCNT)
      BEGIN
            SET @ROWSTR = @ROWSTR + CAST(@R AS VARCHAR)
            SET @I = @I + 1            
      END

      SET @R = @R + 1
      SET @FILL = @FILL - 1
      SET @NUMCNT = @NUMCNT + 2

    PRINT @ROWSTR
END

I are troll Smile | :)

Re: Sql server

anup keshari30-Mar-09 6:34

anup keshari

30-Mar-09 6:34

ITS GOOD BUT THE RESULT IS NOT SO DESIREABLE .

BECAE WHEN I PASS 5 THEN ITS NOT GINGING THE PROPER RESULT

I NEED A DYNAMIC FUNCTION FOR ANY INPUT VALUE

EX .FOR 5
1 ,1 TIMES
2 2 ,2 TIMES
3 3 3 ,3 TIMES
4 4 4 4 ,4 TIMES
5 5 5 5 5 ,5 TIMES
I NEDD LIKE ABOVE

Re: Sql server

Eddy Vluggen30-Mar-09 8:05

Eddy Vluggen

30-Mar-09 8:05

Well, it's *your* homework obvious, not mine Poke tongue | ;-P

Besides, my pyramid differs from yours, so you'll have to write your own anyway.. See, this below was your desired pyramidresult:

        1
       2 2
      3 3 3
     4 4 4 4
    5 5 5 5 5
   6 6 6 6 6 6
  7 7 7 7 7 7 7
 8 8 8 8 8 8 8 8
9 9 9 9 9 9 9 9 9

and this was mine:

         0
        111
       22222
      3333333
     444444444
    55555555555
   6666666666666
  777777777777777
 88888888888888888
9999999999999999999

Your pyramid should only grow by a single number (e.g. 22 -> 333), whilst mine adds two numbers to each row (e.g. 111 -> 222 + 22 = 22222)

Good luck Thumbs Up | :thumbsup:

I are troll Smile | :)

Re: Sql server

Luc Pattyn28-Mar-09 6:55

Luc Pattyn

28-Mar-09 6:55

That is similar to calculating Mandelbrot sets in SQL, only somewhat faster.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

modified on Saturday, March 28, 2009 1:46 PM

Last Visit: 31-Dec-99 18:00 Last Update: 25-Apr-24 6:23

Refresh

ᐊ Prev 1...876 877 878 879880881 882 883 884 885 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.