p2p.wrox.com: Archives - asp

asp_databases thread: Uploading to SQL Server 7

Message #1 by srobinson@g... on Mon, 17 Dec 2001 11:32:19

Hi All,



Can anyone tell me what the procedure is to Upload my local db in SQL 

Server 7 to a remote SQL Server 7 using Enterprise Manager and Query 

Analyzer?



I am in the middle of a Nuclear War over here so any help to appease the 

fall-out would be greatly appreciated.



Cheers,

Simon

Message #2 by Sam Clohesy <sam@e...> on Mon, 17 Dec 2001 11:31:34 -0000

Not sure what you mean. Do you have to transfer a lot of data fron one local

dbase to a remote one?



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 17 December 2001 11:32

To: ASP Databases

Subject: [asp_databases] Uploading to SQL Server 7





Hi All,



Can anyone tell me what the procedure is to Upload my local db in SQL 

Server 7 to a remote SQL Server 7 using Enterprise Manager and Query 

Analyzer?



I am in the middle of a Nuclear War over here so any help to appease the 

fall-out would be greatly appreciated.



Cheers,

Simon




$subst('Email.Unsub').

Message #3 by "Simon Robinson" <srobinson@g...> on Mon, 17 Dec 2001 11:36:53 -0800

Yeah,



I have an image library that contains tables, stored procedures and

everything else that you might imagine.



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Monday, December 17, 2001 3:32 AM

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7



Not sure what you mean. Do you have to transfer a lot of data fron one

local

dbase to a remote one?



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 17 December 2001 11:32

To: ASP Databases

Subject: [asp_databases] Uploading to SQL Server 7





Hi All,



Can anyone tell me what the procedure is to Upload my local db in SQL 

Server 7 to a remote SQL Server 7 using Enterprise Manager and Query 

Analyzer?



I am in the middle of a Nuclear War over here so any help to appease the



fall-out would be greatly appreciated.



Cheers,

Simon




$subst('Email.Unsub').






$subst('Email.Unsub').

Message #4 by Sam Clohesy <sam@e...> on Mon, 17 Dec 2001 11:45:35 -0000

The way I normally do it is (There may be a better/quicker way but this

works for me);(Best to do this stuff slowly and carefully)



1) Run a back up of all your important Data!!!!!!



2) make sure there is an appropriate account on the remote SQL server



3) generate SQL scripts on local machine (This will also generate stored

procs) (Right click dbase/Task/All Tasks/Generate SQL scripts



4) When you run SQL scripts on remote machine it will overwrite existing

tables with the same name as the one you are creating. It is good to be

aware of this



5) Upload/FTP/Move new SQL scripts to remote machine



6) Run them in query analyser



7) You can them export your date using one of the wizards or create your own

DTS



Thanks

Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 17 December 2001 19:37

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7





Yeah,



I have an image library that contains tables, stored procedures and

everything else that you might imagine.



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Monday, December 17, 2001 3:32 AM

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7



Not sure what you mean. Do you have to transfer a lot of data fron one

local

dbase to a remote one?



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 17 December 2001 11:32

To: ASP Databases

Subject: [asp_databases] Uploading to SQL Server 7





Hi All,



Can anyone tell me what the procedure is to Upload my local db in SQL 

Server 7 to a remote SQL Server 7 using Enterprise Manager and Query 

Analyzer?



I am in the middle of a Nuclear War over here so any help to appease the



fall-out would be greatly appreciated.



Cheers,

Simon




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').

Message #5 by "Simon Robinson" <srobinson@g...> on Mon, 17 Dec 2001 11:50:46 -0800

Cheers Sam. I will let you know how I get on.....



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Monday, December 17, 2001 3:46 AM

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7



The way I normally do it is (There may be a better/quicker way but this

works for me);(Best to do this stuff slowly and carefully)



1) Run a back up of all your important Data!!!!!!



2) make sure there is an appropriate account on the remote SQL server



3) generate SQL scripts on local machine (This will also generate stored

procs) (Right click dbase/Task/All Tasks/Generate SQL scripts



4) When you run SQL scripts on remote machine it will overwrite existing

tables with the same name as the one you are creating. It is good to be

aware of this



5) Upload/FTP/Move new SQL scripts to remote machine



6) Run them in query analyser



7) You can them export your date using one of the wizards or create your

own

DTS



Thanks

Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 17 December 2001 19:37

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7





Yeah,



I have an image library that contains tables, stored procedures and

everything else that you might imagine.



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Monday, December 17, 2001 3:32 AM

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7



Not sure what you mean. Do you have to transfer a lot of data fron one

local

dbase to a remote one?



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 17 December 2001 11:32

To: ASP Databases

Subject: [asp_databases] Uploading to SQL Server 7





Hi All,



Can anyone tell me what the procedure is to Upload my local db in SQL 

Server 7 to a remote SQL Server 7 using Enterprise Manager and Query 

Analyzer?



I am in the middle of a Nuclear War over here so any help to appease the



fall-out would be greatly appreciated.



Cheers,

Simon




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').

Message #6 by "Simon Robinson" <srobinson@g...> on Mon, 17 Dec 2001 12:01:50 -0800

Am I right in saying that in order to connect to the remote SQL Server,

I type in the servers IP in Registration on Enterprise Manager? The

problem I am having is that my ISP says that the public IP is open but I

keep getting a connection failed error message.



Can any one help?



-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...] 

Sent: Monday, December 17, 2001 11:51 AM

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7



Cheers Sam. I will let you know how I get on.....



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Monday, December 17, 2001 3:46 AM

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7



The way I normally do it is (There may be a better/quicker way but this

works for me);(Best to do this stuff slowly and carefully)



1) Run a back up of all your important Data!!!!!!



2) make sure there is an appropriate account on the remote SQL server



3) generate SQL scripts on local machine (This will also generate stored

procs) (Right click dbase/Task/All Tasks/Generate SQL scripts



4) When you run SQL scripts on remote machine it will overwrite existing

tables with the same name as the one you are creating. It is good to be

aware of this



5) Upload/FTP/Move new SQL scripts to remote machine



6) Run them in query analyser



7) You can them export your date using one of the wizards or create your

own

DTS



Thanks

Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 17 December 2001 19:37

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7





Yeah,



I have an image library that contains tables, stored procedures and

everything else that you might imagine.



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Monday, December 17, 2001 3:32 AM

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7



Not sure what you mean. Do you have to transfer a lot of data fron one

local

dbase to a remote one?



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 17 December 2001 11:32

To: ASP Databases

Subject: [asp_databases] Uploading to SQL Server 7





Hi All,



Can anyone tell me what the procedure is to Upload my local db in SQL 

Server 7 to a remote SQL Server 7 using Enterprise Manager and Query 

Analyzer?



I am in the middle of a Nuclear War over here so any help to appease the



fall-out would be greatly appreciated.



Cheers,

Simon




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').

Message #7 by Prakash <anp@a...> on Mon, 17 Dec 2001 19:23:53 +0530

Do you wanna export complete database or only selected tables.... ???





Simon Robinson wrote:



> Yeah,

>

> I have an image library that contains tables, stored procedures and

> everything else that you might imagine.

>

> -----Original Message-----

> From: Sam Clohesy [mailto:sam@e...]

> Sent: Monday, December 17, 2001 3:32 AM

> To: ASP Databases

> Subject: [asp_databases] RE: Uploading to SQL Server 7

>

> Not sure what you mean. Do you have to transfer a lot of data fron one

> local

> dbase to a remote one?

>

> Sam Clohesy

> Project Manager

> Tel: 0208 772 3958

> E: samc@e...

> W: http://www.etypemedia.co.uk

>

> -----Original Message-----

> From: srobinson@g... [mailto:srobinson@g...]

> Sent: 17 December 2001 11:32

> To: ASP Databases

> Subject: [asp_databases] Uploading to SQL Server 7

>

> Hi All,

>

> Can anyone tell me what the procedure is to Upload my local db in SQL

> Server 7 to a remote SQL Server 7 using Enterprise Manager and Query

> Analyzer?

>

> I am in the middle of a Nuclear War over here so any help to appease the

>

> fall-out would be greatly appreciated.

>

> Cheers,

> Simon




> $subst('Email.Unsub').

>




> $subst('Email.Unsub').

>

Message #8 by "Simon Robinson" <srobinson@g...> on Mon, 17 Dec 2001 14:37:08 -0800

Yeah, the whole db.



-----Original Message-----

From: Prakash [mailto:anp@a...] 

Sent: Monday, December 17, 2001 5:54 AM

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7



Do you wanna export complete database or only selected tables.... ???





Simon Robinson wrote:



> Yeah,

>

> I have an image library that contains tables, stored procedures and

> everything else that you might imagine.

>

> -----Original Message-----

> From: Sam Clohesy [mailto:sam@e...]

> Sent: Monday, December 17, 2001 3:32 AM

> To: ASP Databases

> Subject: [asp_databases] RE: Uploading to SQL Server 7

>

> Not sure what you mean. Do you have to transfer a lot of data fron one

> local

> dbase to a remote one?

>

> Sam Clohesy

> Project Manager

> Tel: 0208 772 3958

> E: samc@e...

> W: http://www.etypemedia.co.uk

>

> -----Original Message-----

> From: srobinson@g... [mailto:srobinson@g...]

> Sent: 17 December 2001 11:32

> To: ASP Databases

> Subject: [asp_databases] Uploading to SQL Server 7

>

> Hi All,

>

> Can anyone tell me what the procedure is to Upload my local db in SQL

> Server 7 to a remote SQL Server 7 using Enterprise Manager and Query

> Analyzer?

>

> I am in the middle of a Nuclear War over here so any help to appease

the

>

> fall-out would be greatly appreciated.

>

> Cheers,

> Simon




> $subst('Email.Unsub').

>




> $subst('Email.Unsub').

>




$subst('Email.Unsub').








$subst('Email.Unsub').

Message #9 by Prakash <anp@a...> on Mon, 17 Dec 2001 20:27:37 +0530

if you have "ftp" and "pcanywhere" services installed on the remote machine then i

can suggest

OSQL command method where in u will just export 2 files from here..

logon to remote machine attach those two files there.....ur job done...

let me know if those services are there...???



Simon Robinson wrote:



> Am I right in saying that in order to connect to the remote SQL Server,

> I type in the servers IP in Registration on Enterprise Manager? The

> problem I am having is that my ISP says that the public IP is open but I

> keep getting a connection failed error message.

>

> Can any one help?

>

> -----Original Message-----

> From: Simon Robinson [mailto:srobinson@g...]

> Sent: Monday, December 17, 2001 11:51 AM

> To: ASP Databases

> Subject: [asp_databases] RE: Uploading to SQL Server 7

>

> Cheers Sam. I will let you know how I get on.....

>

> -----Original Message-----

> From: Sam Clohesy [mailto:sam@e...]

> Sent: Monday, December 17, 2001 3:46 AM

> To: ASP Databases

> Subject: [asp_databases] RE: Uploading to SQL Server 7

>

> The way I normally do it is (There may be a better/quicker way but this

> works for me);(Best to do this stuff slowly and carefully)

>

> 1) Run a back up of all your important Data!!!!!!

>

> 2) make sure there is an appropriate account on the remote SQL server

>

> 3) generate SQL scripts on local machine (This will also generate stored

> procs) (Right click dbase/Task/All Tasks/Generate SQL scripts

>

> 4) When you run SQL scripts on remote machine it will overwrite existing

> tables with the same name as the one you are creating. It is good to be

> aware of this

>

> 5) Upload/FTP/Move new SQL scripts to remote machine

>

> 6) Run them in query analyser

>

> 7) You can them export your date using one of the wizards or create your

> own

> DTS

>

> Thanks

> Sam

>

> Sam Clohesy

> Project Manager

> Tel: 0208 772 3958

> E: samc@e...

> W: http://www.etypemedia.co.uk

>

> -----Original Message-----

> From: Simon Robinson [mailto:srobinson@g...]

> Sent: 17 December 2001 19:37

> To: ASP Databases

> Subject: [asp_databases] RE: Uploading to SQL Server 7

>

> Yeah,

>

> I have an image library that contains tables, stored procedures and

> everything else that you might imagine.

>

> -----Original Message-----

> From: Sam Clohesy [mailto:sam@e...]

> Sent: Monday, December 17, 2001 3:32 AM

> To: ASP Databases

> Subject: [asp_databases] RE: Uploading to SQL Server 7

>

> Not sure what you mean. Do you have to transfer a lot of data fron one

> local

> dbase to a remote one?

>

> Sam Clohesy

> Project Manager

> Tel: 0208 772 3958

> E: samc@e...

> W: http://www.etypemedia.co.uk

>

> -----Original Message-----

> From: srobinson@g... [mailto:srobinson@g...]

> Sent: 17 December 2001 11:32

> To: ASP Databases

> Subject: [asp_databases] Uploading to SQL Server 7

>

> Hi All,

>

> Can anyone tell me what the procedure is to Upload my local db in SQL

> Server 7 to a remote SQL Server 7 using Enterprise Manager and Query

> Analyzer?

>

> I am in the middle of a Nuclear War over here so any help to appease the

>

> fall-out would be greatly appreciated.

>

> Cheers,

> Simon




> $subst('Email.Unsub').

>




> $subst('Email.Unsub').

>




> $subst('Email.Unsub').

>




> $subst('Email.Unsub').

>




> $subst('Email.Unsub').

>

Message #10 by Prakash <anp@a...> on Mon, 17 Dec 2001 20:45:08 +0530


--------------4A741EFB033D45F99417EC37

Content-Type: text/plain; charset=us-ascii

Content-Transfer-Encoding: 7bit



Use this method which can prove very fast... but it requires

"ftp - for file transfer"

"PCAnywhere - for exectuting osql commands"



assume your database name is "testdb"



1. stop the MSSQL server so that you can copy the database files...

2. when you go to mssql7/binn/data  folder you can see two files which will be

    testdb.mdf   and testdb_log.ldf or somewhat similar to this..... which will

    contain all the data and structure of the db

3. just ftp them into the remote server

4. login to the remote server.. place the 2 files in mssql7/binn/data directory in

the remote server



let username of the database = "usrname"

password = "pwd"



Run this commands from command prompt:

c:> Osql -U usrname -P pwd   (enter)



by doint the above you will get  osql prompt

>sp_attach_db testdb,[this is database name] "testdb.mdf","testdb_log.LDF" (enter)



>successfully attach the database testdb



After you see the message like this your job is done

entire data with complete structure is transferred...

Hope this might save your time....



prakash..













Simon Robinson wrote:



> Yeah, the whole db.

>

> -----Original Message-----

> From: Prakash [mailto:anp@a...]

> Sent: Monday, December 17, 2001 5:54 AM

> To: ASP Databases

> Subject: [asp_databases] RE: Uploading to SQL Server 7

>

> Do you wanna export complete database or only selected tables.... ???

>

> Simon Robinson wrote:

>

> > Yeah,

> >

> > I have an image library that contains tables, stored procedures and

> > everything else that you might imagine.

> >

> > -----Original Message-----

> > From: Sam Clohesy [mailto:sam@e...]

> > Sent: Monday, December 17, 2001 3:32 AM

> > To: ASP Databases

> > Subject: [asp_databases] RE: Uploading to SQL Server 7

> >

> > Not sure what you mean. Do you have to transfer a lot of data fron one

> > local

> > dbase to a remote one?

> >

> > Sam Clohesy

> > Project Manager

> > Tel: 0208 772 3958

> > E: samc@e...

> > W: http://www.etypemedia.co.uk

> >

> > -----Original Message-----

> > From: srobinson@g... [mailto:srobinson@g...]

> > Sent: 17 December 2001 11:32

> > To: ASP Databases

> > Subject: [asp_databases] Uploading to SQL Server 7

> >

> > Hi All,

> >

> > Can anyone tell me what the procedure is to Upload my local db in SQL

> > Server 7 to a remote SQL Server 7 using Enterprise Manager and Query

> > Analyzer?

> >

> > I am in the middle of a Nuclear War over here so any help to appease

> the

> >

> > fall-out would be greatly appreciated.

> >

> > Cheers,

> > Simon




> > $subst('Email.Unsub').

> >




> > $subst('Email.Unsub').

> >




> $subst('Email.Unsub').

>




> $subst('Email.Unsub').

>

Message #11 by "Simon Robinson" <srobinson@g...> on Mon, 17 Dec 2001 16:12:57 -0800

This is a multi-part message in MIME format.



------=_NextPart_000_0003_01C18715.B43FD630

Content-Type: text/plain;

	charset="us-ascii"

Content-Transfer-Encoding: 7bit



Cheers Prakash, I will give it a go..

 

-----Original Message-----

From: Prakash [mailto:anp@a...] 

Sent: Monday, December 17, 2001 7:15 AM

To: ASP Databases

Subject: [asp_databases] RE: Uploading to SQL Server 7

 

Use this method which can prove very fast... but it requires 

"ftp - for file transfer" 

"PCAnywhere - for exectuting osql commands" 

assume your database name is "testdb" 

1. stop the MSSQL server so that you can copy the database files... 

2. when you go to mssql7/binn/data  folder you can see two files which

will be 

    testdb.mdf   and testdb_log.ldf or somewhat similar to this.....

which will 

    contain all the data and structure of the db 

3. just ftp them into the remote server 

4. login to the remote server.. place the 2 files in mssql7/binn/data

directory in the remote server 

let username of the database = "usrname" 

password = "pwd" 

Run this commands from command prompt: 

c:> Osql -U usrname -P pwd   (enter) 

by doint the above you will get  osql prompt 

>sp_attach_db testdb,[this is database name]

"testdb.mdf","testdb_log.LDF" (enter) 

>successfully attach the database testdb 

After you see the message like this your job is done 

entire data with complete structure is transferred... 

Hope this might save your time.... 

prakash.. 

  

  

  

  

Simon Robinson wrote: 

Yeah, the whole db. 

-----Original Message----- 

From: Prakash [mailto:anp@a...] 

Sent: Monday, December 17, 2001 5:54 AM 

To: ASP Databases 

Subject: [asp_databases] RE: Uploading to SQL Server 7 

Do you wanna export complete database or only selected tables.... ??? 

Simon Robinson wrote: 

> Yeah, 

> 

> I have an image library that contains tables, stored procedures and 

> everything else that you might imagine. 

> 

> -----Original Message----- 

> From: Sam Clohesy [mailto:sam@e...] 

> Sent: Monday, December 17, 2001 3:32 AM 

> To: ASP Databases 

> Subject: [asp_databases] RE: Uploading to SQL Server 7 

> 

> Not sure what you mean. Do you have to transfer a lot of data fron one



> local 

> dbase to a remote one? 

> 

> Sam Clohesy 

> Project Manager 

> Tel: 0208 772 3958 

> E: samc@e... 

> W: http://www.etypemedia.co.uk 

> 

> -----Original Message----- 

> From: srobinson@g... [mailto:srobinson@g...] 

> Sent: 17 December 2001 11:32 

> To: ASP Databases 

> Subject: [asp_databases] Uploading to SQL Server 7 

> 

> Hi All, 

> 

> Can anyone tell me what the procedure is to Upload my local db in SQL 

> Server 7 to a remote SQL Server 7 using Enterprise Manager and Query 

> Analyzer? 

> 

> I am in the middle of a Nuclear War over here so any help to appease 

the 

> 

> fall-out would be greatly appreciated. 

> 

> Cheers, 

> Simon 

> --- 



> $subst('Email.Unsub'). 

> 

> --- 



> $subst('Email.Unsub'). 

> 

> --- 



$subst('Email.Unsub'). 

--- 



$subst('Email.Unsub'). 

--- 



$subst('Email.Unsub').




$subst('Email.Unsub').

Message #12 by "Reynolds, Josh" <Josh.Reynolds@E...> on Wed, 19 Dec 2001 13:50:29 -0500

I think there's a way to export/inport data between sql servers...I 

believe you click on the database in question, goto all tasks, and 

export on the machine with the data to copy.  You must have an 

appropriate user account to use on the remote server you're exporting 

to, sa works.  Also, there may be an item under the start menu under sql 

server called 'import/export data' or something like that.



josh



----- Original Message -----

From: "Simon Robinson" <srobinson@g...>

To: "ASP Databases" <asp_databases@p...>

Sent: Monday, December 17, 2001 7:12 PM

Subject: [asp_databases] RE: Uploading to SQL Server 7





> Cheers Prakash, I will give it a go....

> 

> -----Original Message-----

> From: Prakash [mailto:anp@a...]

> Sent: Monday, December 17, 2001 7:15 AM

> To: ASP Databases

> Subject: [asp_databases] RE: Uploading to SQL Server 7

> 

> Use this method which can prove very fast... but it requires

> "ftp - for file transfer"

> "PCAnywhere - for exectuting osql commands"

> assume your database name is "testdb"

> 1. stop the MSSQL server so that you can copy the database files...

> 2. when you go to mssql7/binn/data  folder you can see two files which

> will be

>     testdb.mdf   and testdb_log.ldf or somewhat similar to this.....

> which will

>     contain all the data and structure of the db

> 3. just ftp them into the remote server

> 4. login to the remote server.. place the 2 files in mssql7/binn/data

> directory in the remote server

> let username of the database =3D "usrname"

> password =3D "pwd"

> Run this commands from command prompt:

> c:> Osql -U usrname -P pwd   (enter)

> by doint the above you will get  osql prompt

> >sp_attach_db testdb,[this is database name]

> "testdb.mdf","testdb_log.LDF" (enter)

> >successfully attach the database testdb

> After you see the message like this your job is done

> entire data with complete structure is transferred...

> Hope this might save your time....

> prakash..

>  

>  

>  

>  

> Simon Robinson wrote:

> Yeah, the whole db.

> -----Original Message-----

> From: Prakash [mailto:anp@a... <mailto:anp@a...> ]

> Sent: Monday, December 17, 2001 5:54 AM

> To: ASP Databases

> Subject: [asp_databases] RE: Uploading to SQL Server 7

> Do you wanna export complete database or only selected tables.... ???

> Simon Robinson wrote:

> > Yeah,

> >

> > I have an image library that contains tables, stored procedures and

> > everything else that you might imagine.

> >

> > -----Original Message-----

> > From: Sam Clohesy [mailto:sam@e...

> <mailto:sam@e...> ]

> > Sent: Monday, December 17, 2001 3:32 AM

> > To: ASP Databases

> > Subject: [asp_databases] RE: Uploading to SQL Server 7

> >

> > Not sure what you mean. Do you have to transfer a lot of data fron 

one

>

> > local

> > dbase to a remote one?

> >

> > Sam Clohesy

> > Project Manager

> > Tel: 0208 772 3958

> > E: samc@e...

> > W: http://www.etypemedia.co.uk <http://www.etypemedia.co.uk> 

> >

> > -----Original Message-----

> > From: srobinson@g... [mailto:srobinson@g...

> <mailto:srobinson@g...> ]

> > Sent: 17 December 2001 11:32

> > To: ASP Databases

> > Subject: [asp_databases] Uploading to SQL Server 7

> >

> > Hi All,

> >

> > Can anyone tell me what the procedure is to Upload my local db in 

SQL

> > Server 7 to a remote SQL Server 7 using Enterprise Manager and Query 



> > Analyzer?

> >

> > I am in the middle of a Nuclear War over here so any help to appease 



> the

> >

> > fall-out would be greatly appreciated.

> >

> > Cheers,

> > Simon

> > ---

> > Change your mail options at http://p2p.wrox.com/manager.asp

> <http://p2p.wrox.com/manager.asp>  or


> > $subst('Email.Unsub').

> >

> > ---

> > Change your mail options at http://p2p.wrox.com/manager.asp

> <http://p2p.wrox.com/manager.asp>  or


> > $subst('Email.Unsub').

> >

> > ---

> > Change your mail options at http://p2p.wrox.com/manager.asp

> <http://p2p.wrox.com/manager.asp>  or


> $subst('Email.Unsub').

> ---

> Change your mail options at http://p2p.wrox.com/manager.asp

> <http://p2p.wrox.com/manager.asp>  or


> $subst('Email.Unsub').

> ---

> Change your mail options at http://p2p.wrox.com/manager.asp

> <http://p2p.wrox.com/manager.asp>  or


> $subst('Email.Unsub').




> $subst('Email.Unsub').




> $subst('Email.Unsub').

Return to Index

P2P Archives