473,699 Members | 3,134 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 2155
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
4310
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
6426
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 the dark side of the moon"
11
4005
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
18528
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 run in the background while I
10
4216
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
3655
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
3633
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
106607
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
13649
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
3823
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
8706
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8633
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9199
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8902
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7787
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6552
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5891
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3076
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
2
2366
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.