Re: Did u mean ?? - Database Discussion Boards

How to copy database from other database

C#Coudou6-Sep-07 21:19

6-Sep-07 21:19

Dudes,

I have a new project using SQL database. Here`s my scenario.
I have two database.

Database Name: PCON_A
Database Used: 2006/01 to 2006/12

Database Name: PCON_B
Database Used: 2007/01 to 2007/08

I want to copy the database PCON_A to PCON_B using sql script.
How to do that?

Thanks in advance,
Jeof;)

******************************
I just want to
know everything

Re: How to copy database from other database

pmarfleet6-Sep-07 21:57

pmarfleet

6-Sep-07 21:57

Have a look at this article.

Paul

Re: How to copy database from other database

C#Coudou6-Sep-07 22:12

C#Coudou

6-Sep-07 22:12

link doesn`t work. Frown | :(

******************************
I just want to
know everything

Re: How to copy database from other database

pmarfleet6-Sep-07 22:17

pmarfleet

6-Sep-07 22:17

Oops. Copy-and-paste error. D'Oh! | :doh:

This link should work.

Paul

Re: How to copy database from other database

C#Coudou6-Sep-07 22:32

C#Coudou

6-Sep-07 22:32

got it. this is very helpful. Smile | :)

thanks so much.

******************************
I just want to
know everything

Re: How to copy database from other database

Frank Kerrigan7-Sep-07 5:06

Frank Kerrigan

7-Sep-07 5:06

<br />
<br />
INSERT PCON_B.dbo.TABLE1<br />
select * from PCON_A.dbo.TABLE1<br />
<br />

or even

<br />
<br />
truncate table PCON_A.dbo.TABLE1<br />
<br />
INSERT PCON_B.dbo.TABLE1<br />
select * from PCON_A.dbo.TABLE1<br />
<br />

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Did u mean ??

samerh6-Sep-07 21:17

samerh

6-Sep-07 21:17

Can i implement the same concept that google use when u press search and gives u did u mean...

For example if i put Camille and press search it gives me the following possiblilities:
1- Camile
2- Kamil
3- Kameel

I was thinking of comapring first 4 characters and last 4 characters if we have 2 or 3 charcters common it displays it.

Re: Did u mean ??

pmarfleet6-Sep-07 21:54

pmarfleet

6-Sep-07 21:54

You could consider storing a dictionary of words in your database and using the SOUNDEX function to test for phonetic similarity.

Information on SOUNDEX can be found here.

Paul

INSERTING TWO TABLES IN ONE GRIDVIEW

shyne76-Sep-07 20:58

shyne7

6-Sep-07 20:58

How to insert two tables in one gridview?and how to connect it and to navigate...tnx;)

sunshine

Re: INSERTING TWO TABLES IN ONE GRIDVIEW

Frank Kerrigan7-Sep-07 5:10

Frank Kerrigan

7-Sep-07 5:10

You could use a stored procedure with a temp table and use that

<br />
<br />
create proc myproc <br />
<br />
AS<br />
<br />
SELECT * INTO #TEMP<br />
FROM Table1<br />
<br />
<br />
SELECT * INTO #TEMP<br />
From * Table2 <br />
<br />
select * from #temp<br />
<br />
go<br />
<br />

or use a Union SELECT

<br />
<br />
SELECT * FROM TABLE1<br />
UNION ALL<br />
SELECT * FROM TABLE2<br />
<br />

You get the idea, use SQL to do it.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: INSERTING TWO TABLES IN ONE GRIDVIEW

shyne710-Sep-07 8:54

shyne7

10-Sep-07 8:54

Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0; Data Source = C:\Users\--Sunshine--\Documents\thesis\Database1.mdb")
con.Open()

Dim da As New OleDbDataAdapter(sql, con)
sql = "Select * from Supplier_Information union all Select * from Products"
da.Fill(ds, "Supplier_Information and Products")
dgvSupplier.DataSource = ds.Tables("Supplier_Information and Products").DefaultView

is this right?how will i assigned in my textboxes the table name?

txtsuppID.Text = ds.Tables("which tablename??").Rows(inc).Item(0)

tnx

Can I modify ANSI_NULLS after table is created?

ckruger6-Sep-07 20:49

ckruger

6-Sep-07 20:49

I have a table that was created a few years ago (LIVE), but I need to change ANSI_NULLS from OFF to ON for this table. How can I do that without re-creating the table?

Thanks in advance!

Re: Can I modify ANSI_NULLS after table is created?

Frank Kerrigan7-Sep-07 5:11

Frank Kerrigan

7-Sep-07 5:11

Whats your database SQL Server ????????

You may have to change the value of any nulls in the table first

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

how to know the connection is establised

prasadbuddhika6-Sep-07 17:11

prasadbuddhika

6-Sep-07 17:11

i want to know when i log into the sql server db whether i have connected successfully, using sql login via my appilication. is there any parametre the server passes back to the applicatioin. Smile | :)

Re: how to know the connection is establised

Parwej Ahamad6-Sep-07 19:26

Parwej Ahamad

6-Sep-07 19:26

According to connection object provide the property named state which denote the connection is establish or not.

Parwej Ahamad
g.parwez@gmail.com

hide print button in reporting services

Luis Corrales6-Sep-07 9:59

Luis Corrales

6-Sep-07 9:59

hi all im using sql server reporting services, to do a report, but i want to disable or hide the print button of the report.... please somebody help me or tell me if is possible do that....

thanks

luis

Re: hide print button in reporting services

pmarfleet6-Sep-07 10:31

pmarfleet

6-Sep-07 10:31

Are you using the ReportViewer control to display the report? If so, set the value of its ShowPrintButton property to false.

Paul

Re: hide print button in reporting services

Luis Corrales6-Sep-07 10:58

Luis Corrales

6-Sep-07 10:58

paul im using sql server bussines intelligence, no the reportviewer contro, thanks any way...

i found a solution check this out if someone have the same problem:
http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx[^]

luis

Re: hide print button in reporting services

Frank Kerrigan7-Sep-07 5:15

Frank Kerrigan

7-Sep-07 5:15

You can modify the URL to hide all the toolbars.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: hide print button in reporting services

Frank Kerrigan7-Sep-07 5:13

Frank Kerrigan

7-Sep-07 5:13

See my article in there somewhere

http://www.codeproject.com/sqlrs/Reporting_Services.asp[^]

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

connecting a database on a lan network

gautam karan singh6-Sep-07 8:33

gautam karan singh

6-Sep-07 8:33

hello friends i am third year engineering student i have created a database system using vb.net and mysql which is working fine on a standalone system but now i want this system to be on multiple machines and connected through lan network with one pc working as the server
.
I am non-geek in networking so please can any one help me on this regard.please

gautam karan singh
student

Re: connecting a database on a lan network

Frank Kerrigan7-Sep-07 5:17

Frank Kerrigan

7-Sep-07 5:17

It depends on the database.

Access : needs a direct url path eg. \\server\share\db.mdb

ODBC: Need a SQL server connection string and a network compliant application

You question is a bit fluffy to answer.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

How can I save the image of PictureBox to Sql Server 2000 Again

kindman_nb6-Sep-07 6:33

kindman_nb

6-Sep-07 6:33

Hi ..
thanks for all here ..
on my example .. I want to save the image of a PictureBox to the Sql server 2000 database ...
I know how cant save it from a file ...
but I want to know how save the PictureBoc's image ...

again .. any one will try

jooooo

Re: How can I save the image of PictureBox to Sql Server 2000 Again

Pete O'Hanlon6-Sep-07 11:48