473,581 Members | 2,818 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Re-creating an SQL server database to another MSDE server

NWx
Hi,

I write an ASP,NET application who uses SQL Server (MSDE) as Back-end
I'm an experienced developer, but haven't used SQL server before and I need
some help.

Since I don't have full SQL server (but only MSDE), I don't have Enterprise
manager.
So I used Access XP (using an ADP file) to create the database on MSDE
server (tables, views, stored procs etc)

The ASP.NET app works very well with this BE.

Now I'm in the process to upload application on another server for broader
testing.
This server have also IIS / ASP.NET and MSDE installed

I know how to install ASP.NET application, but have no idea how to recreate
the original SQL server database on my test MSDE instance.
Of course I can create the SQL database the same way as I did initially (by
hand, with AccessXP and an ADP file), but I don't want to do this, since I
could misspell a field name, use some slightly different data type, forget a
relation, etc.
What I want is to install EXACTLY the same database on the new server.
So, is there any way with MSDE to generate a script file, which, when run on
another sql server instance, will recreate a database exactly as original
one? Are there any stored procs on SQL server who does this? Any sql server
tools or free 3'rd party tools?

Any help and suggestion will be appreciated.

Regards
Nov 18 '05 #1
3 2147
You should be able to use BACKUP and RESTORE or sp_detach_db and sp_attach_db. You can execute these commands via the command line tool osql.exe. You should be able to execute the appropriate commands via ASP if you wanted.

You will find the specific syntax for the commands listed above within Books Online (SQL Server's documentation). If you don't have access to Books Online you can download it from this location: http://www.microsoft.com/sql/techinf...2000/books.asp

--
Keith
"NWx" <te**@test.co m> wrote in message news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
Hi,

I write an ASP,NET application who uses SQL Server (MSDE) as Back-end
I'm an experienced developer, but haven't used SQL server before and I need
some help.

Since I don't have full SQL server (but only MSDE), I don't have Enterprise
manager.
So I used Access XP (using an ADP file) to create the database on MSDE
server (tables, views, stored procs etc)

The ASP.NET app works very well with this BE.

Now I'm in the process to upload application on another server for broader
testing.
This server have also IIS / ASP.NET and MSDE installed

I know how to install ASP.NET application, but have no idea how to recreate
the original SQL server database on my test MSDE instance.
Of course I can create the SQL database the same way as I did initially (by
hand, with AccessXP and an ADP file), but I don't want to do this, since I
could misspell a field name, use some slightly different data type, forget a
relation, etc.
What I want is to install EXACTLY the same database on the new server.
So, is there any way with MSDE to generate a script file, which, when run on
another sql server instance, will recreate a database exactly as original
one? Are there any stored procs on SQL server who does this? Any sql server
tools or free 3'rd party tools?

Any help and suggestion will be appreciated.

Regards

Nov 18 '05 #2
NWx
Thanks for the info.

Regards
"Keith Kratochvil" <sq***********@ comcast.net> wrote in message
news:e4******** ******@TK2MSFTN GP12.phx.gbl...
You should be able to use BACKUP and RESTORE or sp_detach_db and
sp_attach_db. You can execute these commands via the command line tool
osql.exe. You should be able to execute the appropriate commands via ASP if
you wanted.

You will find the specific syntax for the commands listed above within Books
Online (SQL Server's documentation). If you don't have access to Books
Online you can download it from this location:
http://www.microsoft.com/sql/techinf...2000/books.asp

--
Keith
"NWx" <te**@test.co m> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
Hi,

I write an ASP,NET application who uses SQL Server (MSDE) as Back-end
I'm an experienced developer, but haven't used SQL server before and I need some help.

Since I don't have full SQL server (but only MSDE), I don't have Enterprise manager.
So I used Access XP (using an ADP file) to create the database on MSDE
server (tables, views, stored procs etc)

The ASP.NET app works very well with this BE.

Now I'm in the process to upload application on another server for broader
testing.
This server have also IIS / ASP.NET and MSDE installed

I know how to install ASP.NET application, but have no idea how to recreate the original SQL server database on my test MSDE instance.
Of course I can create the SQL database the same way as I did initially (by hand, with AccessXP and an ADP file), but I don't want to do this, since I
could misspell a field name, use some slightly different data type, forget a relation, etc.
What I want is to install EXACTLY the same database on the new server.
So, is there any way with MSDE to generate a script file, which, when run on another sql server instance, will recreate a database exactly as original
one? Are there any stored procs on SQL server who does this? Any sql server tools or free 3'rd party tools?

Any help and suggestion will be appreciated.

Regards

Nov 18 '05 #3
Hi,

You could either write an sql script, or copy the .mdf to the other server.
( dunno if MSDE has these, as I have SQL 2000).

Jodie Rapson

"NWx" <te**@test.co m> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
Hi,

I write an ASP,NET application who uses SQL Server (MSDE) as Back-end
I'm an experienced developer, but haven't used SQL server before and I need some help.

Since I don't have full SQL server (but only MSDE), I don't have Enterprise manager.
So I used Access XP (using an ADP file) to create the database on MSDE
server (tables, views, stored procs etc)

The ASP.NET app works very well with this BE.

Now I'm in the process to upload application on another server for broader
testing.
This server have also IIS / ASP.NET and MSDE installed

I know how to install ASP.NET application, but have no idea how to recreate the original SQL server database on my test MSDE instance.
Of course I can create the SQL database the same way as I did initially (by hand, with AccessXP and an ADP file), but I don't want to do this, since I
could misspell a field name, use some slightly different data type, forget a relation, etc.
What I want is to install EXACTLY the same database on the new server.
So, is there any way with MSDE to generate a script file, which, when run on another sql server instance, will recreate a database exactly as original
one? Are there any stored procs on SQL server who does this? Any sql server tools or free 3'rd party tools?

Any help and suggestion will be appreciated.

Regards

Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4277
by: Nel | last post by:
I have a question related to the "security" issues posed by Globals ON. It is good programming technique IMO to initialise variables, even if it's just $foo = 0; $bar = ""; Surely it would be better to promote better programming than rely on PHP to compensate for lazy programming?
4
6414
by: Craig Bailey | last post by:
Anyone recommend a good script editor for Mac OS X? Just finished a 4-day PHP class in front of a Windows machine, and liked the editor we used. Don't recall the name, but it gave line numbers as well as some color coding, etc. Having trouble finding the same in an editor that'll run on OS X. -- Floydian Slip(tm) - "Broadcasting from...
11
3995
by: James | last post by:
My form and results are on one page. If I use : if ($Company) { $query = "Select Company, Contact From tblworking Where ID = $Company Order By Company ASC"; }
4
18520
by: Alan Walkington | last post by:
Folks: How can I get an /exec'ed/ process to run in the background on an XP box? I have a monitor-like process which I am starting as 'exec("something.exe");' and, of course the exec function blocks until something.exe terminates. Just what I /don't/ want. (Wouldn't an & be nice here! Sigh) I need something.exe to disconnect and...
10
4207
by: James | last post by:
What is the best method for creating a Web Page that uses both PHP and HTML ? <HTML> BLA BLA BLA BLA BLA
8
3649
by: Lothar Scholz | last post by:
Because PHP5 does not include the mysql extension any more is there a chance that we will see more Providers offering webspace with Firebird or Postgres Databases ? What is your opinion ? I must say that i like it to see mysql replaced by a real database (stored procedures etc.)
1
3628
by: joost | last post by:
Hello, I'm kind of new to mySQL but more used to Sybase/PHP What is illegal about this query or can i not use combined query's in mySQL? DELETE FROM manufacturers WHERE manufacturers_id NOT IN ( SELECT manufacturers_id FROM products )
2
106595
by: sky2070 | last post by:
i have two file with jobapp.html calling jobapp_action.php <HTML> <!-- jobapp.html --> <BODY> <H1>Phop's Bicycles Job Application</H1> <P>Are you looking for an exciting career in the world of cyclery? Look no further! </P> <FORM NAME='frmJobApp' METHOD=post ACTION="jobapp_action.php"> Please enter your name:
1
13632
by: Brian | last post by:
I have an array like this: $events = array( array( '2003-07-01', 'Event Title 1', '1' //ID Number (not unique) ), array( '2003-07-02',
1
3817
by: Clarice Almeida Hughes | last post by:
tenho um index onde tenho o link pro arq css, como sao visualizados pelo include todas as paginas aderem ao css linkado no index. so q eu preciso de alguns links com outras cores no css, o q devo fazer?
0
7883
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7808
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8312
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8182
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5685
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5366
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3809
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2311
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1147
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.