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 3 2141
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.com> wrote in message news:%2****************@TK2MSFTNGP12.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
Thanks for the info.
Regards
"Keith Kratochvil" <sq***********@comcast.net> wrote in message
news:e4**************@TK2MSFTNGP12.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.com> wrote in message
news:%2****************@TK2MSFTNGP12.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
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.com> wrote in message
news:%2****************@TK2MSFTNGP12.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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...
|
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";
}
|
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...
|
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
| |
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...
|
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 ...
|
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...
|
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',
|
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...
|
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,...
| |
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...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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 ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |