Can anyone refer me to good 'recipes' or sources of information on this
topic??
I have Visual Studio Tools for Office, which installs SS 2005 Express
locally to my XP box, and I want to develop in SS 2005, then copy the
tables or queries or reports etc. to a SS 2005 Standard server.
Thank you, Tom
3  8421 
Hi Tom
If the objects are on source code control you may just want to check out the
scripts and run them through SQLCMD.
If you want the whole database then you can either use backup/restore or
sp_detach_db/sp_attach_db, failing that you could use the import/export
wizard, If SQLExpress is does not allow external connections then you will
need to push it (export) from the SQLExpress machine.
Check out http://support.microsoft.com/kb/314546
John
"tlyczko" <tl*****@gmail. comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .
Can anyone refer me to good 'recipes' or sources of information on this
topic??
I have Visual Studio Tools for Office, which installs SS 2005 Express
locally to my XP box, and I want to develop in SS 2005, then copy the
tables or queries or reports etc. to a SS 2005 Standard server.
Thank you, Tom
I should have said SS 2005 Developer, not Express, I am installing SS
2005 Dev to my workstation here.
But everything you said should work, I just have to learn how!!!!!!!!
I will read the KB article, I suppose I could learn SSIS for just
tables or queries etc., or even just re-create the queries on the SS
dev box.
Thanks a lot for answering!!
:) tom
John Bell wrote:
Hi Tom
If the objects are on source code control you may just want to check out the
scripts and run them through SQLCMD.
If you want the whole database then you can either use backup/restore or
sp_detach_db/sp_attach_db, failing that you could use the import/export
wizard, If SQLExpress is does not allow external connections then you will
need to push it (export) from the SQLExpress machine.
Check out http://support.microsoft.com/kb/314546
John
"tlyczko" <tl*****@gmail. comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .
Can anyone refer me to good 'recipes' or sources of information on this
topic??
I have Visual Studio Tools for Office, which installs SS 2005 Express
locally to my XP box, and I want to develop in SS 2005, then copy the
tables or queries or reports etc. to a SS 2005 Standard server.
Thank you, Tom
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Hemang Shah |
last post by:
Hello I"m a seasonal Access developer.
How steep is the learning curve to start developing database applications
in c# ?
Could you suggest me any good books which teaches the ropes of
database development in C# ? Including making reports ?
|
by: Jim McGivney |
last post by:
I am a ASP.net 2.0 NewBee
I have a simple website I developed in Web Developer Express. I test it
with CTRL-F5 and it works.
I have found out that I can not Web Copy it to my hosted web site.
I am under the impression that I must first "pre-compile"
I use aspnet_compile.exe
Now I look for the results to copy to my website. Where are they ???
I see that aspnet_compile.exe generates a new folder in...
|
by: Dennis |
last post by:
I am totally confused between Access, SQL Express, and SQL Server and MSDE
and OLEDB vs SQL in .net. Please someone tell me if I"m correct in the
following:
With MSDE installed, I can program using OLEDB in ADO.Net for Access then
convert later to an SQL Express or SQL Server database and my program still
work if I change the connection string.
With MSDE installed, I can program ADO.Net for SQL and it will work for SQL
express or SQL...
|
by: Frederick Gotham |
last post by:
(Before I begin, please don't suggest to me to use "std::vector" rather
than actual arrays.)
I understand that an object can have resources (e.g. dynamically
allocated memory), and so we have to copy an object properly via copy-
construction rather than using memcpy.
However, is it okay to move an object manually (i.e. by using memcpy or
memmove)?
|
by: Frederick Gotham |
last post by:
(My dialect of English seems to puzzle people at times, so I'll first
clarify a few terms which I use in the following post:)
(1) By "domestic", I mean "ordinary, run-of-the-mill, not
extraordinary or strange".
(2) By "willy-nilly", I mean something along the lines of
"haphazardly", but without any sense of recklessness (i.e. gleefully
doing something without expecting any sort of negative effect, even
though there may in fact be a...
| | |
by: Rico |
last post by:
Hello,
I have a database in 2005 that I'd like to copy and attach in 2000. Is this
possible? if so, how do I do it? I've tried doing a number of things from
just trying to attach to the db file to trying to export and import via
access and I can't seem to get anything to work.
Any help would be greatly appreciated.
Thanks!
|
by: Thanks |
last post by:
Two Windows 2003 server,
one with SQL 2005 server,
another with SQL Express.
Is it possible to copy databases from SQL 2005 to SQL Express?
Thanks.
|
by: Randy Reimers |
last post by:
(Hope I'm posting this correctly, otherwise - sorry!, don't know what else
to do)
I wrote a set of programs "many" years ago, running in a type of basic,
called "Thoroughbred Basic", a type of business basic. I need to re-write
it, bring it kicking and screaming to run on Windows XP. This is for a
video rental place, tracks movie and game rentals, customers, employee
transactions, reservations, does reports,..... and on.
I know some of...
|
by: Scott Gifford |
last post by:
Hello,
I'm working on an providing an iterator interface to a database. The
basic thing I'm trying to accomplish is to have my iterator read rows
from the database and return constructed objects. My goal here is to
abstract away the database part, so that in the future these objects
could be constructed from a data source on disk, across the network,
etc. The interface I'm after is similar to the standard iterator
interface for an...
|
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...
|
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...
| | |
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
